mysql安装在centos7报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
mysql版本：5.7.13
- [root@localhost opt]# /usr/bin/mysql -u root
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
1、找到密码
- [root@localhost opt]# cat /var/log/mysqld.log | grep password
- 2016-07-16T05:01:47.771362Z 1 [Note] A temporary password is generated for root@localhost: q.)aq!YaH6y-
- 2016-07-16T05:02:32.000199Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
- 2016-07-16T05:02:39.063852Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
- [root@zzs171 opt]# /usr/bin/mysql -u root -p
- Enter password:
进入mysql客户端之后，show databases; 会提醒先修改密码：
- mysql> show databases;
- ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
- SET PASSWORD FOR 'root'@'localhost' = PASSWORD('Mysqlpassw0rd.');
- alter user 'root'@'localhost' identified by 'Mysqlpassw0rd.';
- mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123');
- ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
网上还有几种方案，但是都不行。例如：
- 方案一：
- mysqladmin -u root password 123456，结果提示错误：error: 'Access denied for user 'root'@'localhost' (using password: NO)'
- 方案二：
- 用mysqld_safe skip-grant-tables进入mysql，然后sql语句修改root密码，还是提示错误：-bash: mysqld_safe: command not found
本文从 http://blog.csdn.net/kuluzs/article/details/51924086 转载
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！