Creating Your First MySQL Database: A Step-by-Step Walkthrough

What a database is and why you create one in MySQL

A database in MySQL is a container that holds organized information — think of it like a filing cabinet where each drawer is a table, and each table holds rows and columns of related data. When you create a database, you are setting up an empty space where MySQL will store that information. You do not put the actual data in yet; you are just telling MySQL "I want a place called this name to exist."

MySQL is software that manages databases. It runs on your computer or a web server and listens for instructions. Creating a database is the first step before you can store anything — it is the equivalent of building the cabinet before you start filing papers.

Key Takeaways

A database in MySQL is a named container where you will eventually store tables and data, created with a single command.
You access MySQL through a command-line tool or a graphical program, and the command to create a database is always CREATE DATABASE followed by the name you choose.
Database names should be lowercase, use underscores instead of spaces, and describe what the database holds — like "customer_records" or "inventory_system".
After you create a database, you must tell MySQL to use it before you can add tables or data to it.
If a database with that name already exists, MySQL will refuse to create it unless you add the words IF NOT EXISTS to your command.

Accessing MySQL and opening a connection

Before you can create anything, you need to connect to MySQL. On Windows, open Command Prompt. On Mac or Linux, open Terminal. Type mysql -u root -p and press Enter. MySQL will ask for a password — this is the password you set when you installed MySQL. If you have not set one yet, just press Enter.

After you enter the password, you will see a prompt that looks like mysql>. This means you are now inside MySQL and it is listening for commands. Everything you type from this point forward is a MySQL instruction, not a regular computer command.

The command to create a database

At the mysql> prompt, type exactly this:

CREATE DATABASE my_first_database;

Replace "my_first_database" with whatever you want to call your database. The name should be lowercase, use underscores for spaces (not actual spaces), and describe what it holds. Good examples are "school_records", "blog_posts", or "sales_data". Press Enter after you type the command. If MySQL responds with "Query OK, 1 row affected", the database has been created.

The semicolon at the end is required — it tells MySQL that your command is finished. If you forget it, MySQL will wait for more input and will not run the command.

What to do if the database name is already taken

If you try to create a database with a name that already exists, MySQL will show an error: "Error 1007: Can't create database 'my_first_database'; database exists". This means someone or something already created a database with that exact name.

You have two choices. First, you can pick a different name and run the CREATE DATABASE command again with the new name. Second, you can add the words IF NOT EXISTS to your command, like this:

CREATE DATABASE IF NOT EXISTS my_first_database;

This tells MySQL: "Create this database, but if it already exists, do not complain — just move on." This is useful when you are running the same command multiple times and do not want to worry about whether the database is already there.

Telling MySQL to use your new database

Creating a database does not automatically put you inside it. You have to tell MySQL to use it. Type:

USE my_first_database;

Replace "my_first_database" with the actual name you created. MySQL will respond with "Database changed", which means you are now working inside that database. Any tables or data you create from this point will go into this database.

If you close your connection to MySQL and open a new one later, you will need to run the USE command again to get back into the same database. The USE command does not stick between sessions.

Checking that your database was created

To see a list of all databases that exist on your MySQL installation, type:

SHOW DATABASES;

MySQL will display a list. You should see your new database name in that list. You will also see databases called "information_schema", "mysql", and "performance_schema" — these are built-in databases that MySQL uses internally and you should not delete them.

If you do not see your database in the list, go back and check that you typed the CREATE DATABASE command correctly, including the semicolon at the end.

What happens next: adding tables and data

Once your database exists and you have told MySQL to use it with the USE command, you are ready to create tables inside it. A table is where the actual data lives — it has columns (like "name", "email", "phone number") and rows (the actual records). Creating a table is a separate step that comes after creating the database.

For now, you have completed the foundation: you have a named space in MySQL where information can be organized. The database itself is empty until you add tables to it.

Frequently Asked Questions

Can I use spaces or capital letters in my database name?

MySQL technically allows both, but it causes problems across different operating systems and makes commands harder to read. Use lowercase letters and underscores instead. "customer_records" is better than "Customer Records" or "CUSTOMER_RECORDS".

What if I want to delete a database I created by mistake?

Type DROP DATABASE database_name; where database_name is the name you want to remove. MySQL will delete it when ready and permanently. There is no undo, so be certain before you run this command.

Do I need to create a database for every project I work on?

Yes. Each separate project or process should have its own database. This keeps data organized and prevents one project from accidentally affecting another. You can create as many databases as you need.

What is the difference between creating a database and creating a table?

A database is the container; a table is what goes inside it. You create the database first, then create tables inside that database, then add rows of data to those tables. Think of the database as the filing cabinet and the table as a drawer inside it.

Can I rename a database after I create it?

MySQL does not have a straightforward rename command for databases. The safest way is to create a new database with the name you want, copy all the tables from the old one to the new one, then delete the old database. This is more advanced and usually only necessary if you made a spelling mistake.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.