Q: How do you grant all privileges to a MySQL user?

MySQL GRANT Privileges

Answer:

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:

FLUSH PRIVILEGES;
    No comments found for this tutorial, be the first to leave a comment!

Answered by
Double

Last updated on
Aug 04, 2016

Share