Q: How do you grant all privileges to a MySQL user?
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;
Comments
Add comment