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

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 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

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.