mysql忘记root密码

最新推荐文章于 2025-03-06 15:08:40 发布

DBAdream

最新推荐文章于 2025-03-06 15:08:40 发布

阅读量724

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/DBAdream/article/details/38414299

mysql 专栏收录该内容

32 篇文章

订阅专栏

本文指导如何在忘记MySQL管理员密码时，通过启动skip-grant-tables模式，修改密码，并刷新权限，确保数据库系统的正常运行。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[root@bssnusb03 ~]# mysql -uroot -proot
Warning: Using a password on the command line interface can be insecure.

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

密码忘记，使用skip-grant-tables模式启动mysql，修改密码

# /etc/init.d/mysql stop
Shutting down MySQL (Percona Server)..

[root@bssnusb03 ~]# mysqld_safe --skip-grant-tables &
[1] 758
[root@bssnusb03 ~]# 140807 10:33:37 mysqld_safe Logging to '/BSS/data/error.log'.
140807 10:33:37 mysqld_safe Starting mysqld daemon with databases from /BSS/data

[root@bssnusb03 ~]# ps -ef|grep mysql
root 758 630 0 10:33 pts/4 00:00:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables
mysql 1041 758 36 10:33 pts/4 00:00:03 /usr/sbin/mysqld --basedir=/usr --datadir=/BSS/data --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --skip-grant-tables --log-error=/BSS/data/error.log --pid-file=/BSS/data/percona.pid --socket=/BSS/data/percona.sock --port=3306
root 1071 630 0 10:33 pts/4 00:00:00 grep mysql
root 11572 1 0 Aug05 ? 00:00:00 mysql -uroot -px xx
[root@bssnusb03 ~]# mysql

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> UPDATE user SET Password = password('root8989') WHERE User = 'root' ;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

mysql> flush privileges ;
Query OK, 0 rows affected (0.00 sec)

mysql> \q

# mysql -uroot -proot8989