First we’ll login to the MySQL server from the command line with the following command:

mysql -u root –p

You should now be at a MySQL prompt that looks very similar to this:

mysql>

To create a database with the name web_e_tutorial_database type the following command:

CREATE DATABASE IF NOT EXISTS web_e_tutorial_database;

View All MySQL Databases

To view the database you’ve created simply issue the following command:

SHOW DATABASES;

Your Answer
Sign In
Enter email and password to comment or answer
Not the answer you are looking for? Browse other questions tagged or ask your own question.