Creating MySQL database and user from command line

This serves as my own notes – I always forget the syntax.


  • How to deal with UNIX command line programs

Use MySQL command to login to running MySQL instance. If this is on local host you can try

mysql -uroot # no password


mysql -uroot -p # asks for password

Use -H option to connect to external MySQL host (on shared hosting).

Then create a new database using CREATE DATABASE command. Here we create a database called joomla.

mysql> create database joomla;
Query OK, 1 row affected (0.00 sec)

And then we create a MySQL user whose access is limited to this database only. In this case we create admin user with admin password. Note that MySQL accepts local connections only by default, so MySQL or this user is not exposed to Internet (and potential attacks).

Username is joomla and password is joomladbpassword.

GRANT ALL ON joomla.* TO 'joomla'@'localhost' identified by 'joomladbpassword';

… and now you can proceed to install Joomla.

\"\" Subscribe to RSS feed Follow me on Twitter Follow me on Facebook Follow me Google+

One thought on “Creating MySQL database and user from command line

Leave a Reply

Your email address will not be published. Required fields are marked *