How to find and change the installation path of MySQL on Linux

MySQL is a commonly used relational database management system. As an open source operating system, Linux is also a widely used platform. Installing MySQL on Linux is a very common requirement, however, the default installation path of MySQL after installation may not match the user's expectations. Therefore, this article will introduce how to find and change the installation path of MySQL on Linux.

1. Find the installation path of MySQL

On Linux, you can find the installation path of MySQL in the following ways:

1.1 Execute the command

Enter the following command in the terminal:

which mysql

This command will output the path to the MySQL installation location.

1.2 View the status of the MySQL service

Enter the following command in the terminal:

service mysql status

This command will list the status information of the MySQL service. In the status information, you can find the installation path of MySQL.

1.3 View the MySQL configuration file

Enter the following command in the terminal:

cat /etc/mysql/my.cnf

This command will display the MySQL configuration file. In the configuration file, you can find the installation path of MySQL.

2. Change the installation path of MySQL

If the user wants to install MySQL to a custom path, he can follow the following steps to set it up:

2.1 Create Custom directory

Enter the following command in the terminal:

sudo mkdir /data/mysql

This command will create a directory named "mysql", which is located in the /data directory.

2.2 Change the MySQL configuration file

Enter the following command in the terminal:

sudo vim /etc/mysql/my.cnf

This command will open the MySQL configuration file. Find the following line in the file:

datadir = /var/lib/mysql

Change the line to:

datadir = /data/mysql

Save and close the file.

2.3 Move existing MySQL data

Enter the following command in the terminal:

sudo service mysql stop
sudo cp -R /var/lib/mysql/* /data/mysql/
sudo rm -Rf /var/lib/mysql

This command will stop the MySQL service and then move the existing MySQL data to the new Customize the directory /data/mysql, and delete the original /var/lib/mysql directory.

2.4 Restart the MySQL service

Enter the following command in the terminal:

sudo service mysql start

This command will start the MySQL service and install the MySQL service to the new custom directory/ under data/mysql.

Summary

MySQL is a very powerful database management system, while Linux is a widely used operating system platform. Installing MySQL is a very common requirement on Linux. This article introduces how to find and change the MySQL installation path on Linux, allowing users to customize the MySQL installation path according to their own needs to better meet their business needs.

The above is the detailed content of How to find and change the installation path of MySQL on Linux. For more information, please follow other related articles on the PHP Chinese website!