Shulou(Shulou.com)06/01 Report--

This article mainly tells you about the modification method of the default storage directory of mysql data. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. I hope this article can bring you some practical help. I hope that the modification method of the default storage directory of mysql data can bring you some practical help.

Change the default mysql data storage directory / var/lib/mysql to / data directory

1. Stop the mysql service

Service mysql stop

2. Copy the data file of mysql

Cp-R / var/lib/mysql / data

3. Modify mysql configuration file / etc/my.cnf

Modify socket = / var/lib/mysql/mysql.sock to: socket = / data/mysql/mysql.sock

In versions after mysql 5.5, we found that the configuration file my.cnf could not be found, so we need to set the

Copy / usr/share/mysql/my-huge.cnf to the / etc directory, rename it to: my.cnf, and then modify socket

4. Modify mysql startup item configuration / etc/init.d/mysql

Modify datadir= to: datadir=/data/mysql

5. Start mysql

Service mysql start

You will find that the service failed to start because we used the root user to copy / var/lib/mysql to the / data directory

As a result, the mysql does not have permission to access, and the service startup fails. Modify the corresponding permissions:

Chown-R mysql / data/mysql

Chgrp-R mysql / data/mysql

Just restart the service.

Mysql data default storage directory modification method to tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

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.