ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
来源:互联网 发布:剑灵卡刀软件 编辑:程序博客网 时间:2024/06/05 20:02
CentOS命令登录MySQL时,报错ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)错误解决方法
1、停用mysql服务:# /etc/init.d/mysql stop
2、输入命令:# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
3、登入数据库:# mysql -u root mysql
4、mysql> use mysql; 结果如下:
Database changed
5、mysql> UPDATE user SET Password=PASSWORD('root')where USER='root';
结果如下:
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3 Changed: 3 Warnings: 0'
mysql> FLUSH PRIVILEGES;
结果如下:
Query OK, 0 rows affected (0.00 sec)
mysql> quit
# /etc/init.d/mysql restart
# mysql -u newuser –p
Enter password: newpassword
mysql><登录成功>
0 0
- error: 'Access denied for user 'root'@'localhost' (using password: YES)'
- ERROR 1045 (28000): Access denied for user'root'@'localhost'(using password:YES)
- 解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 问题
- ERROR 1045 (28000): Access denied for user’root’@'localhost’(using password:YES)
- ERROR 1045 (28000): Access denied for user root@localhost (using password: YES)
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- 解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 问题
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 解决办法
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- 解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 问题
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- ERROR 1045 (28000): Access denied for user ’root’@’localhost’ (using password: YES)
- ERROR 1045 (28000): Access denied for user'root'@'localhost'(using password:YES)最近解决方法在!
- 解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 问题
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- 解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 问题
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- NYOJ 170 网络的可靠性
- Oracle数据库程序设计学习笔记
- HLGOJ 1101 Bombs of HRBUST(kruskal)
- 工作流基础
- SQL Server 触发器
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- LVS和Heartbeat的安装配置说明
- IOS高级编程(网络编程一)
- iOS7适配问题总结
- Java SE 8 在并发工具方面的加强
- 基因芯片(Affymetrix)分析1:芯片质量分析
- Java 单例模式详解
- 迷宫问题递归与非递归求解
- Javascript刷新页面的几种方法