In this tutorial I will demonstrate how you can quickly create a new MySQL database using the command line interface. Most of the dedicated servers that you can buy will come with a nice web interface to manage you mysql server. Something like phpmyadmin. But in case you are building a dedicated databases server you most definitely will need to know how to set your first database from the command line.

First thing you need to do is to login into your database server. For the purposes of this tutorial I have installed mysql on a Linux server but the approach is pretty much the same even if you operate on a server with Windows operating system.

On Linux the command to enter in Mysql Command Line Interfate (CLI) is pretty intuitive.

Just to note that the administrative username might not be root but something else. It depends on your specific installation but by default it is root.
After that you will be prompted for the root user password. Please type the password and hit Enter.

Note: if you have just installed mysql you should login with no password. That way the command is just mysql -u root

Once you are logged in you are ready to create your first database using the command line. Use the following CREATE DATABASE syntax.

You are half-way there. We need to enter one more command and the database will be ready for use. We need to create a user for the database.

The database is ready for use. In case you need to manage or access your database from remote server please check this tutorial : remote connection to MySQL