Question
how to create a database and add all the privileges in MySQL
- Posted August 12, 2013
Subscribe
Share
Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Sign in to AnswerThese answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
We have an article on this: https://www.digitalocean.com/community/articles/how-to-create-a-new-user-and-grant-permissions-in-mysql
GRANT ALL PRIVILEGES ON . TO ‘myuser’@‘localhost’ WITH GRANT OPTION; <br> <br>For specified database: (mydatabase) <br> <br>GRANT ALL ON mydatabase TO ‘myuser’@‘localhost’;