【错误处理】CentOS命令登录MySQL时,报错ERROR 1045 (28000):
来源:互联网 发布:华雄深孔钻编程视频 编辑:程序博客网 时间:2024/06/05 08:47
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'; 结果如下:
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/rc.d/init.d/mysqld restart
# mysql -u newuser–p
Enter password:newpassword
mysql><登录成功>
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'; 结果如下:
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/rc.d/init.d/mysqld restart
# mysql -u newuser–p
Enter password:newpassword
mysql><登录成功>
0 0
- 【错误处理】CentOS命令登录MySQL时,报错ERROR 1045 (28000):
- 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)
- mysql登录报错 ERROR 1045 (28000)
- mysql登录报错ERROR 1045 (28000) 的解决方法
- linux登录MySQL,报错ERROR 1045 (28000)解决办法
- Mysql登录时报错 ERROR 1045 (28000): 错误解决办法
- mysql登录时,ERROR 1045 (28000): 错误解决办法
- centos中卸载mysql,Mysql中添加用户之后可能出现登录时提示ERROR 1045 (28000): Access denied for user的错误
- mysql报ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password)错误或者远程用户不能登录
- MySQL 登录报错 1045
- mysql root用户登录报ERROR(1045)
- linux下登录mysql报错“ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO“)
- 解决mysql数据库登录报1045错误,修改root密码
- mysql恢复报ERROR 2006 (HY000) at line 5303856: MySQL server has gone away错误处理
- mysql登录报错
- mysql ERROR 2003 错误处理
- 统计学学习笔记
- 数学上一些结论
- 最简单的小公司子网划分,望高手指教
- URAL 1389 Roadworks
- 黑马程序员-----网络编程
- 【错误处理】CentOS命令登录MySQL时,报错ERROR 1045 (28000):
- IOS Android 手机助手原理以及源码(iTunesMobileDevice.dll 函数)
- CSS轮廓,突出元素
- poj 2068 Nim 博弈论dp
- SCU 4438 Censor (KMP)
- JavaScript跨域总结与解决办法
- python的timer带参数传递
- BNUoj 50401 Right turn 转向问题
- ccs框模型与可视化格式模型