How to change the default installation path of mysql

How to modify the default installation path of mysql: First use the command [service mysqld stop] to stop mysql and check the default path of the mysql database; then modify the MySQL configuration file and modify the MySQL startup script.

The operating environment of this tutorial: windows7 system, mysql8.0.22 version, thinkpad t480 computer.

How to modify the default installation path of mysql:

1,

Use the command: service mysqld stop to stop mysql and view the default path of the mysql database: / var/lib/mysql Create the target storage directory: mkdir /home/data Use the command to copy the file: cp -R /var/lib/mysql /home/data/mysql

2,

Modify MySQL configuration file: /etc/my.cnf Use VIM to edit: vim /etc/my.cnf and change the datadir to the new path datadir=/home/data/mysql. To ensure that MySQL can function normally, mysql.sock does not need to be modified. The location of the file, or specify the location where the new mysql.sock file is generated. socket　=/var/lib/mysql/mysql.sock (Original content, you can use "#" to comment this line, this line can also be left unchanged) socket　=/home/data/mysql/mysql.sock　 (Add this line )

3,

Modify the MySQL startup script/etc/init.d/mysqld, find getmysqloption mysqld datadir "/var/lib/mysql/mysql" and change the content in double quotes to actual Storage path/home/data/mysql

4,

If you modify the generation location of mysql.sock in the MySQL configuration file/etc/my.cnf, you need to make a link to point to New file location.

ln -sv /home/data/mysql/mysql.sock /var/lib/mysql/mysql.sock The above command creates a soft link to mysql.sock, otherwise it will fail when logging in using the mysql client. Prompt that the file /var/lib/mysql/mysql.sock cannot be found

5,

Restart mysqld service mysqld restart

Related free learning recommendations: mysql database(Video)

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