How to view the storage location of MySQL data files

This article mainly introduces how to view the storage location of MySQL data files, the contents of the articles are carefully selected and edited by the author, with a certain pertinence, the reference significance for you is still relatively great, the following with the author to understand how to view the storage location of MySQL data files.

Here, I will teach you a very simple method to locate the storage location of the MySQL data file immediately, that is, type the following command on the MySQL client:

Show global variables like "datadir%"

As shown in the figure above, the data files for MySQL are stored in the Data directory. As for the next want to view the specific database or table, it depends on everyone's mood!

However, you may also have a question, that is, we all found the data file of MySQL in the ProgramData directory of disk C, but we searched the whole disk C but still couldn't find the ProgramData folder. Why? The answer is: by default, the ProgramData folder is hidden.

As for how to show hidden folders, I believe everyone has played very smoothly ah!

After reading the above about how to view the storage location of MySQL data files, many readers must have some understanding. If you need to get more industry knowledge and information, you can continue to follow our industry information column.