Mysql: creating a new user and assign all permission to it

Mysql: creating a new user and assign all permission to it

i create this user for my backup script:

GRANT ALL PRIVILEGES ON *.* TO 'mybackup'@'localhost' IDENTIFIED BY 'mybackuppassword';
GRANT SELECT ON *.* TO 'mybackup'@'localhost';

 

Leave a Reply

Your email address will not be published. Required fields are marked *