how to create mysqli database in xampp using cmd || create database in xampp using command
#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.
Watch video how to create mysqli database in xampp using cmd || create database in xampp using command online without registration, duration hours minute second in high quality. This video was added by user PHP Technical & Framework 19 February 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,660 once and liked it 10 people.