步骤一:先停止数据库服务
[root@GGB ~]# systemctl stop mysql.service
[root@GGB ~]# systemctl status mysql.service
● mysql.service - MySQL Server
Loaded: loaded (/etc/systemd/system/mysql.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since 五 2024-07-12 01:03:45 CST; 1s ago
Process: 3738 ExecStop=/usr/local/mysql/bin/mysqladmin shutdown (code=exited, status=1/FAILURE)
Process: 2951 ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/data/3306/data (code=exited, status=0/SUCCESS)
Main PID: 2951 (code=exited, status=0/SUCCESS)
步骤二:采用安全模式启动数据库(空密码方式进入数据库)
#mysqld_safe 一个命令
#--skip-grant-tables Start wi