CentOS 命令登录MySQL时,报错 ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
来源:互联网 发布:正交矩阵和实对称矩阵 编辑:程序博客网 时间:2024/06/05 05:30
CentOS 命令登录MySQL时,报错 ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
错误解决方法
1、停用mysql服务:
# /etc/rc.d/init.d/mysqld 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('newpassword')where USER='newuser';
比如给root设置新密码:
UPDATE user SET Password=PASSWORD('myDB_112233')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><登录成功>
- CentOS 命令登录MySQL时,报错 ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
- CentOS命令登录MySQL时,报错ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)错误解
- 解决MySQL 报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- linux下登录mysql报错“ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO“)
- 解决MySql登录错误ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql登录账号出错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Centos下登陆mysql报错#1045 - Access denied for user 'root'@'localhost' (using password: NO)
- centOS下mysql-ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- centOS下mysql-ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql安装在centos7报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql安装在centos7报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql安装在centos7报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- MySQL 报错 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 的解决办法
- mac系统中mysql登录报错:Access denied for user 'root'@'localhost' (using password: NO)
- CentOS 下mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
- mysql报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- 解决数据库连接报ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)问题
- CentOS下进入MySQL提示ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- poj 1251 Jungle Roads(最小生成树)
- LeetCode198. House Robber
- 【推荐】大规模的自然场景文字检测与识别数据库
- AC自动机入门
- LeetCode213. House Robber II
- CentOS 命令登录MySQL时,报错 ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
- Unity Android 阴影不显示、阴影显示不正确 解决备忘
- C++10
- 1548-Cannot load from mysql.proc. The table is probably corrupted
- HDU 1181 DFS
- poj 1287 Networking(最小生成树)
- 银行家算法
- JAVA中的Object类
- Minecraft题解