Blog

Create a MySQL Database on Linux via Command Line

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:

mysql>

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:

CREATE DATABASE IF NOT EXISTS tutorial_database;

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:

SHOW DATABASES;

Your result should be similar to this:

mysql> SHOW DATABASES;
+--------------------+
| 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 >>

Related posts

Cây ăn thịt chuột

admin

Phát triển vi chip có hiệu suất cao

admin

Viêm cơ tim, phù thũng vì thiếu vitamin B1

admin

Sun Solaris UNIX display list for loaded kenel device driver / modules

admin

Mộ cổ Trung Quốc: Những thông tin quý giá về tục tế người cổ xưa

admin

Người đàn ông già nhất thế giới

admin

Xác định thuế môn bài của hộ kinh doanh nhỏ có thu nhập thấp ?

admin

Tàu vũ trụ Mỹ bay vào không gian

admin

Công nghệ xác định nho chín từ xa

admin

Leave a Comment