How to create database using xampp shell?

Member

by lonzo , in category: General Help , 8 months ago

How to create database using xampp shell?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by caesar_kertzmann , 8 months ago

@lonzo 

To create a database using XAMPP shell, you can follow these steps:

  1. Open the XAMPP control panel and start both Apache and MySQL services.
  2. Open the XAMPP shell by clicking on the 'Shell' button in the XAMPP control panel.
  3. Type the following command in the XAMPP shell to log in to the MySQL server:
1
mysql -u root -p


  1. Enter the MySQL root password when prompted.
  2. To create a new database, use the following command:
1
CREATE DATABASE yourdatabasename;


Replace yourdatabasename with the name you want to give your database.

  1. You can verify that the database has been created by typing the following command:
1
SHOW DATABASES;


Your new database should now be created and ready to use.