Shulou(Shulou.com)05/31 Report--

This article will give you a detailed explanation on how to view the mysql installation location, the editor thinks it is very practical, so share it with you for reference. I hope you can get something after reading this article.

View the mysql installation location: 1, execute the "show variables like'% basedir%';" command in the mysql command line to view the output results; 2, directly execute the "ps-ef | grep mysql" command in the terminal to view the output results.

The operating environment of this tutorial: linux5.9.8 system, mysql8 version, Dell G3 computer.

Sometimes we don't always remember the installation path of the database during the development process. For example, to see where the installation directory of the mysql database is:

We can view the installation path of mysql through the mysql command:

# either of the following two sql can query select @ @ basedir as basePath from dual; show variables like'% basedir%'

You can see the basic installation path above. Check the path of the database data. It is simple to change the above parameter variable to datadir:

# any of the following queries can be select @ @ datadir as dataPath from dual; show variables Like'% datadir%'

Of course, the above is based on the ability to log in to the mysql window to check, then friends will ask, if you do not know the password to log into the mysql account, then how to check the mysql path?

Method 1:

1: query the path where the running file is located

Which mysql

You can then enter a password through / usr/bin/mysql-u account-p to connect to Mysql:

Then execute any of the above MySQL to view the installation path. Is this kind of tedious, but also more simple?

Method 2:

View the installation information for mysql:

Ps-ef | grep mysql

Marked in red, you can see the specific path.

On "how to view mysql installation location" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.