how to create mysqli database in xampp using cmd || create database in xampp using command

Опубликовано: 19 Февраль 2023
на канале: PHP Technical & Framework
1,660
10

#phpfortech #phptechnicalframework #phpforbeginner #phpforbeginners

Website: https://phpfortech.com/blog

To create a MySQL database using the mysqli extension in XAMPP, you can use the command prompt (cmd) on your computer. Here are the steps to follow:

1.Open the command prompt on your computer by pressing the Windows key + R, then type "cmd" and press Enter.

2.Navigate to the XAMPP installation directory by using the command "cd C:\xampp\mysql\bin" or whatever path XAMPP is installed on your computer.

3.Connect to the MySQL server using the command "mysql -u root -p" and enter your MySQL root password when prompted.

4.Create a new database using the command "CREATE DATABASE database_name;" where "database_name" is the name of the database you want to create. For example, "CREATE DATABASE mydatabase;"

5.Verify that the database was created by using the command "SHOW DATABASES;" which will list all databases currently in MySQL.

6.Once you have created the database, you can start creating tables and adding data to it using SQL commands.

That's it! You have successfully created a MySQL database using the mysqli extension in XAMPP via command prompt.


Смотрите видео how to create mysqli database in xampp using cmd || create database in xampp using command онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь PHP Technical & Framework 19 Февраль 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,660 раз и оно понравилось 10 людям.