How to view the database installation path in MySQL

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

# Either of the following two SQL statements can be queried: select @@basedir as basePath from dual;
show variables like '%basedir%';

The basic installation path can be seen above. To check the path of the database data, it is very simple. Just replace the above parameter variable with datadir:

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

Of course, the above is based on being able to log in to the MySQL window to view it. Then friends will ask, if you don’t know the account password to log in to MySQL, how can you view the MySQL path?

Method 1:

1: Query the path where the running file is located

which mysql

Then you can connect to Mysql through /usr/bin/mysql -u account -p password:

Then execute any of the above MySQL to view the installation path. Is this too complicated? It can be simpler.

Method 2:

View the installation information of mysql:

ps -ef | grep mysql

The red mark shows the specific path.

This is the end of this article about how to view the database installation path in MySQL. For more information about MySQL database installation path, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!