Linux OS 下遗忘MYSQL密码，重设步骤

1 连接数据库，Access Denied

使用./mysql -uroot -padmin 连接Mysql时出现了：

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

2 密码重设步骤

2.1 检查MySQL服务,若启动，则关闭；

[root@master bin]# whereis mysql
[root@master bin]# chkconfig --list | grep -i mysql
[root@master bin]# service mysql stop

2.2 使用mysqld_safe脚本启动MySQL，连接MySQL；

[root@master bin]# ./mysqld_safe --user=root --skip-grant-tables --skip-networking & 

./mysql -uroot mysql

2.3 执行SQL语句，更新密码；

mysql> update user set password=password('123456') where user='root';
Query OK, 1 row affected (0.07 sec)
Rows matched: 5  Changed: 1  Warnings: 0

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

mysql> quit
Bye

2.4 重启服务，连接Mysql

[root@master bin]#   service mysql stop
  Shutting down MySQL..160203 10:53:47 mysqld_safe mysqld from pid file /var/lib/mysql/master.pid ended
     SUCCESS! 
  [1]+  Done  ./mysqld_safe --user=root --skip-grant-tables --skip-networking
[root@master bin]# service mysql start
  Starting MySQL. SUCCESS! 
[root@master bin]# ./mysql -uroot -p123456

资源链接

• [ Linux命令大全 ] ： http://www.runoob.com/linux/linux-command-manual.html
• [mysqld与mysqld_safe区别] ： http://blog.csdn.net/rj03hou/article/details/5143434