Mysql create user and privileges assign.

 Remove privileges

REVOKE ALL PRIVILEGES ON aws_oxtoolstaging.* FROM ‘aws_oxtoolstaging’@’localhost’;

Assign privileges

CREATE USER ‘username’@’localhost’ IDENTIFIED BY ‘S1@gingin’;

GRANT ALL PRIVILEGES ON databases . * TO ‘username’@’localhost’;

show privileges

show grants for ‘username’@’localhost’;

Puneet Kumar Magento Developer
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply