How to Create Databases in MySQL

Creating databases in MySQL is a fundamental task for managing data efficiently. It allows you to organize, store, and retrieve data for applications and services. This tutorial will take you through the steps to create a new database in MySQL.

1. Logging Into MySQL

Before creating a database, you need to log into the MySQL shell. Use the following command:

mysql -u username -p

Replace username with your actual MySQL username. You will be prompted to enter the password.

2. Viewing Existing Databases

To see a list of existing databases, run the following command inside the MySQL shell:

SHOW DATABASES;

This will display all databases currently in MySQL.

3. Creating a New Database

To create a new database, use the CREATE DATABASE command. For example, to create a database called my_database:

CREATE DATABASE my_database;

After executing this command, you should see a message indicating that the database has been created successfully.

4. Selecting the Database

Once the database is created, you can select it to perform operations:

USE my_database;

This command sets my_database as the current database for subsequent operations.

5. Creating Tables within the Database

After selecting your database, you can create tables to store data. Here’s a simple example of creating a table called users:

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    password VARCHAR(50) NOT NULL
);

This command creates a table with three columns: an auto-incrementing ID, a username, and a password.

6. Viewing Tables

To view all tables in the current database, run:

SHOW TABLES;

This command lists all tables that have been created in the selected database.

7. Conclusion

By following this tutorial, you have successfully created a new database and table in MySQL. Understanding how to create and manage databases is essential for organizing and retrieving data within applications. Continue to explore MySQL’s powerful features to enhance your database management skills!

About the Author

Dorian Kane

Author

View All Posts