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.
Sur cette page du site, vous pouvez voir la vidéo en ligne how to create mysqli database in xampp using cmd || create database in xampp using command durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur PHP Technical & Framework 19 février 2023, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 1,660 fois et il a aimé 10 téléspectateurs. Bon visionnage!
