Create a MySQL Database on Linux via Command Line

MySQL via Command Line 101: Basic Database Interaction Change a Password for MySQL on Linux via Command Line Create a MySQL Database...

Written by admin · 1 min read >

Pre-Flight Check

Create a MySQL Database

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

mysql -u root -p

In this case, I’ve specified the user root with the -u flag, and then used the -p flag so MySQL prompts for a password. Enter your current password to complete the login.

If you need to change your root (or any other) password in the database, then follow this tutorial on changing a password for MySQL via the command line.

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


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

CREATE DATABASE tutorial_database;

If a database of the same name already exists, then a new database will not be created and you’ll receive this error:

ERROR 1007 (HY000): Can't create database 'tutorial_database'; database exists

To avoid seeing this error use the following command instead:


The above command will only create the database tutorial_database if a database of that name does not already exist.

View All MySQL Databases

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


Your result should be similar to this:

| Database           |
| information_schema |
| mysql              |
| test               |
| tutorial_database  |
4 rows in set (0.00 sec)

When standard uptime is not enough, you don’t have to wage war alone. Liquid Web’s High-Availability Databases provides the bleeding edge hardware needed for keeping your site online. Does significantly reducing overhead while not having to worry about managing MySQL sounds like a dream come true?  Then check out our affordable plans!

Series Navigation

<< Change a Password for MySQL on Linux via Command LineSelect a MySQL Database on Linux via Command Line >>

Bitcoin Exchange Script

admin in Blog
  ·   1 min read

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *