mysql修改密码后无法启动_MySQL无法启动，修改密码问题分析

MySQL无法启动，修改密码问题分析

遇到第一件事就是查看错误日志

位置：在mysql数据存放目录下的，主机名.err文件[root@mysql ~]# tail /data/mysql/data/mysql.err

2020-03-06T03:00:07.267361Z 0 [Note] Shutting down plugin 'MEMORY'

2020-03-06T03:00:07.267394Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

2020-03-06T03:00:07.267453Z 0 [Note] Shutting down plugin 'MRG_MYISAM'

2020-03-06T03:00:07.267459Z 0 [Note] Shutting down plugin 'MyISAM'

2020-03-06T03:00:07.267480Z 0 [Note] Shutting down plugin 'CSV'

2020-03-06T03:00:07.267486Z 0 [Note] Shutting down plugin 'sha256_password'

2020-03-06T03:00:07.267488Z 0 [Note] Shutting down plugin 'mysql_native_password'

2020-03-06T03:00:07.267781Z 0 [Note] Shutting down plugin 'binlog'

2020-03-06T03:00:07.268267Z 0 [Note] /server/tools/mysql/bin/mysqld: Shutdown complete

如果看日志内不显示，可以把日志显示到屏幕里

/server/tools/mysql/bin/mysqld --defaults-file=/etc/my.cnf

ctrl +\ -----结束

一般启动不了的情况：配置文件my.cnf不正确

目录没有配置权限，或者没有递归配置

/tmp/mysql.sock文件被删除或者被修改

参数改错了

管理员忘记mysql的密码怎么办

1.首先关闭数据库[root@mysql ~]# systemctl stop mysqld

2.启动数据库到维修模式

mysqld_safe  --skip-grant-tables  --skip-networking &

--skip-grant-tables          跳过授权表

--skip-networking           禁止远程登陆[root@mysql ~]# mysqld_safe --skip-grant-tables --skip-networking &

[1] 10410

[root@mysql ~]# 2020-03-06T03:33:13.771897Z mysqld_safe Logging to '/data/mysql/data/mysql.err'.

2020-03-06T03:33:13.811456Z mysqld_safe Starting mysqld daemon with databases from /data/mysql/data

[root@mysql ~]# mysql

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.7.26 MySQL Community Server (GPL)