How to check where the mysql database file is

How to check where the mysql database file is: You can check it by executing the [SHOW VARIABLES LIKE 'datadir';] command, which will return the saving path of the database file.

#Everyone operates the database every day, but where are the files in the database stored? Now let's take a look.

Recommended course: mysql video tutorial

The first step, click [Start]→[Run]

#The second step is to fill in cmd in the open text box.

The third step is to hit the Enter key to open the cmd window.

The fourth step is to enter the mysql -u root -p command and press Enter

##The fifth step, prompt for password, enter the correct password, enter the mysql command line

The sixth step, Enter the SHOW VARIABLES LIKE 'datadir'; command to return the database file saving path

The above is the detailed content of How to check where the mysql database file is. For more information, please follow other related articles on the PHP Chinese website!