How to create a new MySQL (MariaDB) Database, user, and grant it privileges

How to create a new MySQL (MariaDB) Database, user, and grant it privileges Thumbnail image

To create a new database table and user by the command line, you have to enter this command:

mysql -u root -p

(The -u root = login as root user. The -p part = enter a password (it'll prompt you for the password - it isn't a good idea to type passwords directly into a command))

You should now be in the mysql prompt.

Let's pretend we want to set up the following:

  • Database name new_database
  • New user new_username
  • And the password for the new user pAs5w0rd

At the mysql prompt enter the following 4 sql statements.

Remember to add a ; at the end of every sql statement.

 CREATE USER  'new_username'@'localhost' IDENTIFIED BY 'pAs5w0rd';

CREATE DATABASE new_database;

GRANT ALL PRIVILEGES ON new_database.* TO 'new_username'@'localhost' ;

FLUSH PRIVILEGES;

exit;

And you should be all done!

webdevetc profile pic
webdevetc

I am a 29 year old freelance backend web developer from London, mostly focusing on PHP and Laravel lately. This is my site - I mostly write about PHP here. Contact me here (especially for any contracting jobs early 2019 in London ;) ).

Leave a Comment