ERROR 1045 (28000): Access denied for user 'root'@'localhost'
错误提示:
# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
解决方法：1# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
方法一：
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/223555/viewspace-681425/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- Oracle中exists与in的效率探讨 ( 转存)
- So many TIME_WAIT connection
- Recover MySQL root Password
- 查看数据库字符集
- Shareplex 7 activation failed due to horizontal partioning support limitation
- 创建永久性本地SCSI设备名称
- 3岁-4岁幼儿情感有什么特点
- ORA-15071: ASM disk "VOL_DATA2" is already being dropped
- 创建永久性本地SCSI设备名称
- mysql backup and restore
