To grant all privileges to a user, run the following command in MySQL shell:
Replace user and localhost with your user's username and host.
GRANT ALL PRIVILEGES TO 'user'@'localhost';
Now reload MySQL privileges:
Answered by Double
Last updated on Aug 04, 2016