Question

how to create a database and add all the privileges in MySQL

Posted August 12, 2013 13.2k views
Add a comment
subratmca85
By:
subratmca85

These 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.

×
Submit an Answer
2 answers
digitalocean214802 August 12, 2013
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'localhost' WITH GRANT OPTION;

For specified database: (mydatabase)

GRANT ALL ON mydatabase TO 'myuser'@'localhost';
Reply Report
kamaln7 August 12, 2013
We have an article on this: https://www.digitalocean.com/community/articles/how-to-create-a-new-user-and-grant-permissions-in-mysql
How To Create a New User and Grant Permissions in MySQL
by Etel Sverdlov
MySQL is a powerful database management system used for organizing and retrieving data. This tutorial explains how to to create new MySQL users and how to grant them the appropriate permissions.
Reply Report

Looking for something else?

Ask a new question Search for more help