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

This article is mainly about starting mysql-5.7.21 error reports and changing the location of the database storage directory. 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 that starting the mysql-5.7.21 error report and changing the location of the database storage directory can bring you some practical help.

Mysql-5.7.21 initiates error reporting and permanent resolution

Chmod + x / etc/rc.d/rc.local

# write two commands into it to automatically create mysqld and modify owner permissions when booting

Ehco "mkdir-p / var/run/mysqld

Chown-R mysql:mysql / var/run/mysqld

"/ etc/rc.d/rc.local

# modify the database storage directory

Systemctl stop mysqld # stop the database cloud server

Mkdir-p / data/mysql/ # create directory

Chown-R mysql:mysql / data/mysql # modify folder owner

Cp-r / var/lib/mysql/ / data/mysql

Chown-R mysql:mysql / data/mysql/

Ls-1 / data/mysql/

Vi / etc/my.cnf

Datadir=/data/mysql

Socket=/data/mysql/mysql.sock

Save exit

Systemctl start mysqld

Systemctl status mysqld

Start mysql-5.7.21 error report, change the location of the database storage directory 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.