Ubuntu: How to create a new database in MySQL

Last updated on

Firstly, you must log in as root.

mysql -u root -p

Now you can create a new database. Replace your_dbname with the name of your database.

CREATE DATABASE your_dbname;

You may want ot grant privileges to this database.

GRANT ALL PRIVILEGES ON your_dbname.* To 'your_username'@'localhost' IDENTIFIED BY 'your_password';

Once you have finalised the permissions, always be sure to reload all the privileges.


Let me know if this helped. Follow me on Twitter, Facebook and YouTube, or 🍊 buy me a smoothie.

Leave a reply

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