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

Pubblicato il: 19 febbraio 2023
sul canale di: PHP Technical & Framework

1,660

#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.

In questa pagina del sito puoi guardare il video online how to create mysqli database in xampp using cmd || create database in xampp using command della durata di ore minuti seconda in buona qualità , che l'utente ha caricato PHP Technical & Framework 19 febbraio 2023, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,660 volte e gli è piaciuto 10 spettatori. Buona visione!