MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost'
来源:互联网 发布:淘宝有哪些好的零食店 编辑:程序博客网 时间:2024/05/22 14:20
mysql -uroot -p
输入设置的密码
竟然报错了!
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YSE)
问朋友,他说初始密码是空的,可我命名设置了密码的啊
密码留空
还是错误!
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:
mysql>
搞定!
0 0
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- MySQL Error 1045(28000) Access Denied for user 'root'@'localhost'
- Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- mysql ERROR 1045 access denied for user 'root'@'localhost' using
- ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- ERROR 1045 (28000): Access denied for user'root'@'localhost'
- 解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' 错误
- mysql root登陆报错 ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- hdu 1864 实数离散化+动态规划+滚动数组
- 八条千金不卖的人生感悟
- HDU 2768 Cat vs. Dog 最大独立集+匈牙利算法(提高题)
- const、volatile、mutable的用法
- poj 3984 迷宫问题(BFS+输出路径)
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- 64位window下安装memcache扩展
- 黑马程序员——java基础—String类和StringBuffer类
- poj2752
- 利用HTML5 Canvas和Javascript实现的蚁群算法求解TSP问题演示
- UVA 1218 (树形DP)
- mybatis的逆向工程
- hdu 1171 Big Event in HDU(母函数)
- n阶乘求最后非0数字及最后面连续0的个数