Learning how to create a database in MySQL is one of the first practical steps I recommend to anyone exploring SQL, web development, or application development. A database gives your project an organized place to store customers, products, orders, posts, or any other information your application needs.
In this guide, I’ll show you how to create a MySQL database with the command line and MySQL Workbench. I’ll also explain character sets, permissions, naming rules, common errors, and how to create your first working table.
What Do You Need Before Creating a MySQL Database?
Before starting, make sure MySQL Server is installed and running on your computer or hosting server. You’ll also need access to MySQL through the terminal, MySQL Command Line Client, or MySQL Workbench.
Your MySQL user account must have the CREATE privilege. The official MySQL documentation confirms that MySQL requires this privilege before an account can create a database. MySQL also treats CREATE SCHEMA as a synonym for CREATE DATABASE.
For local development, many people sign in with the root account. For production applications, I recommend creating a dedicated database user with only the permissions the application needs.
How to Create a Database in MySQL Using the Command Line
The command line provides the fastest and most direct method. When someone asks me how to create a database in MySQL, I usually start with this approach because it works consistently across Windows, macOS, and Linux.
Step 1: Log In to the MySQL Server
Open Command Prompt, Terminal, or MySQL Command Line Client and enter:
mysql -u root -p
Press Enter and type your MySQL password when prompted. MySQL does not display password characters while you type, which is normal.
Step 2: Check Existing Databases
Before creating anything, view the databases already available to your account:
SHOW DATABASES;
Checking first helps you avoid choosing a name that is already in use.
Step 3: Create the New Database
Run the CREATE DATABASE statement followed by your chosen name:
CREATE DATABASE my_new_database;
MySQL should return a success message. To prevent an error when the database may already exist, use this safer variation:
CREATE DATABASE IF NOT EXISTS my_new_database;
Without IF NOT EXISTS, MySQL returns an error when it finds a database with the same name.
Step 4: Verify and Select the Database
Confirm that MySQL created the database:
SHOW DATABASES;
Next, select it before creating tables:
USE my_new_database;
Creating a database does not automatically select it for every new session. The USE statement tells MySQL which database should receive your tables and queries.
You can confirm the active database with:
SELECT DATABASE();
For additional verification, run:
SHOW CREATE DATABASE my_new_database;
This displays the SQL definition MySQL uses for the database.
How to Create a Database in MySQL Workbench
MySQL Workbench provides a graphical interface for people who prefer clicking through menus instead of working entirely in a terminal. MySQL describes Workbench as a visual tool for database architects, developers, and administrators.
Option A: Use the Create Schema Wizard
Open MySQL Workbench and connect to your server. Click the database cylinder with a plus sign in the toolbar, or right-click inside the Schemas panel and choose Create Schema.
Enter a name such as my_new_database, review the character set and collation options, and click Apply. Workbench will display the SQL statement it plans to execute. Review it, click Apply again, and then select Finish.
Refresh the Schemas panel if the new database does not appear immediately.
Option B: Use the SQL Editor
Open a new query tab and enter:
CREATE DATABASE IF NOT EXISTS my_new_database;
Click the lightning bolt icon to execute the statement. You can then run:
USE my_new_database;
The SQL Editor method provides the convenience of Workbench while helping you practice real MySQL commands.
How Do You Set utf8mb4 When Creating a Database?
For applications that store names, symbols, multilingual content, or emojis, use the utf8mb4 character set.
CREATE DATABASE my_new_database
CHARACTER SET utf8mb4;
A character set determines which characters MySQL can store. A collation controls how text is compared and sorted. MySQL allows both settings to be defined at the database level.
You can also specify a compatible collation:
CREATE DATABASE my_new_database
CHARACTER SET utf8mb4
COLLATE utf8mb4_0900_ai_ci;
Check your MySQL version and application requirements before selecting a collation, since availability can vary between versions.
How Should You Name a MySQL Database?
Use a short, descriptive name that explains the database’s purpose. Database names should not contain spaces, so use underscores to separate words.
For example, choose customer_portal, inventory_system, or online_store instead of vague names such as database1. I also recommend using lowercase letters consistently and avoiding special characters or reserved SQL words.
Clear naming conventions make your SQL easier to understand and reduce mistakes when you manage multiple projects.
How Do You Create Your First Table?
A database acts as a container, but tables hold the actual records. After selecting your database, create a simple customer table:
CREATE TABLE customers (
customer_id INT PRIMARY KEY AUTO_INCREMENT,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
email VARCHAR(100) UNIQUE
);
Insert a sample record:
INSERT INTO customers (first_name, last_name, email)
VALUES (‘John’, ‘Smith’, ‘john.smith@example.com’);
Then retrieve it:
SELECT * FROM customers;
This complete test confirms that you can create objects, insert information, and query your new database.
How Do You Fix Common MySQL Database Errors?
Why Does MySQL Say the Database Already Exists?
This error means another database uses the same name. Choose a different name or add IF NOT EXISTS to your command.
Why Am I Getting an Access Denied Error?
Your account probably lacks the CREATE privilege. Sign in with an authorized account or ask the server administrator to grant the required permission.
Why Is the MySQL Command Not Found?
MySQL may not be installed, its service may not be running, or its executable directory may be missing from your system’s PATH environment variable.
Why Is the Database Missing in Workbench?
Refresh the Schemas panel, verify that the SQL statement executed successfully, and confirm that you are connected to the correct MySQL server.
How Do You Delete a MySQL Database Safely?
Use the following statement only when you are certain you no longer need the database:
DROP DATABASE my_new_database;
This command permanently removes the database and every table stored inside it. Double-check the name and create a backup before running it on important data.
Frequently Asked Questions (FAQs)
1. Is a MySQL schema the same as a database?
Yes. In MySQL, CREATE SCHEMA and CREATE DATABASE perform the same function.
2. Can I create a MySQL database without writing code?
Yes. MySQL Workbench provides a visual schema wizard that lets you create a database through a graphical interface.
3. Which command displays all MySQL databases?
Run SHOW DATABASES; to display the databases your user account has permission to view.
4. Why must I run USE after creating a database?
The USE database_name; statement selects the database that should receive your subsequent table creation and data queries.
Start Building Your MySQL Project
Once I learned how to create a MySQL database, creating tables and managing application data became much easier. The essential workflow is simple: connect to the server, create the database, verify it, select it, and test it with a table.
Whether you prefer the command line or MySQL Workbench, practicing both methods will help you work confidently across local development computers, cloud servers, and professional database environments.
This foundation is also useful when comparing the best database for ecommerce websites, since understanding database creation and management makes it easier to evaluate scalability, reliability, and performance.
Leave a Reply