Home >Database >Mysql Tutorial >How to check where the mysql database file is

How to check where the mysql database file is

(*-*)浩
(*-*)浩Original
2019-05-07 15:56:1735285browse

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.

How to check where the mysql database file is

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

How to check where the mysql database file is


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

How to check where the mysql database file is

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

How to check where the mysql database file is

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

How to check where the mysql database file is

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

How to check where the mysql database file is

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

How to check where the mysql database file is

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn