Simple Steps to Create a Database in MySQL
Step 1: Launch XAMPP
If XAMPP is not running, initiate the application. Next, launch your web browser and type http://localhost/ into the address bar. Finally, press Enter to access the database.
Step 2: Access phpMyAdmin
Navigate to the “phpMyAdmin” tool under the “Tools” section at the bottom-left of the XAMPP homepage. Click on it to open the phpMyAdmin interface.
Step 3: Navigate to SQL Tab
Inside phpMyAdmin, find and click on the “SQL” tab. This is where you can execute SQL commands.
Step 4: Execute SQL Command
Type the following command in the SQL tab:
CREATE DATABASE designer;
Press the “Go” button to execute the command. This creates a new database named “designer.”
Step 5: Verify Database Creation
Look on the left side of the phpMyAdmin interface; you should see a new database named “designer.”
Step 6: Alternative Method – Create Database Directly
If you prefer an alternative method, you can create a database directly from the “Databases” tab. Enter your desired database name in the “Create database” field and click “Create.”
Step 7: Selecting a Database (Optional)
If you have multiple databases on one server and want to work with a specific one, use the following SQL command:
USE designer;
Replace “designer” with your desired database name.
Step 8: Deleting a Database (Use with Caution)
To delete a database, use the following SQL command:
DROP DATABASE designer;
Be careful, as this action is irreversible and permanently deletes the database along with its tables and data.
Remember to handle database deletion with caution, as undoing this action is not possible.