linux mysql access denied for user ‘root’@’localhost'(using password:YES)
来源:互联网 发布:木村秋则 知乎 编辑:程序博客网 时间:2024/06/05 17:07
inux安装完mysql后,使用程序连接报以上错误
解决方法,重新设置密码,步骤如下
1.先停掉原来的服务
service mysqld stop
2.使用安全模式登陆,跳过密码验证
mysqld_safe --user=mysql --skip-grant-tables --skip-networking&
3.登陆
mysql -uroot mysql
4.修改密码
mysql > update user set authentication_string = password('123456') where user = 'root' and Host = 'localhost'
5.刷新权限
mysql > flush privileges;
6.重新使用正常模式登陆
#mysql -uroot -p#enter password : 123456
可以正常登陆。
7.执行其他命令:show databases; 提示如下错误
You must reset your password using ALTER USER statement before executing this statement.
8.重新将密码设置一遍即可
mysql > set password = password ('123456');
9.配置完成。
阅读全文
0 0
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- MySql Access denied for user 'root'@'localhost' (using password: YES)
- mysql access denied for user'root'@'localhost' using password yes
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- mysql:Access denied for user 'root'@'localhost' (using password:YES)
- MySQL:Access denied for user 'root'@'localhost' (using password:YES)
- linux下连接windows mysql的错误:Access denied for user 'root'@'localhost' (using password: YES)
- Linux下连接Mysql出现:Access denied for user 'root'@'localhost' (using password:YES)的解决方法
- linux 下mysql 报 ERROR 1045 (28000): Access denied for user '-root'@'localhost' (using password: YES)
- linux下使用mysql数据库出现 “Access denied for user 'root'@'localhost' (using password: YES)”
- linux mysql access denied for user ‘root’@’localhost'(using password:YES)
- linux下安装mysql后Access denied for user 'root'@'localhost' (using password: YES)
- linux安装MySQL出现ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- 总结linux下使用mysql数据库出现 “Access denied for user 'root'@'localhost' (using password: YES)”
- linux下mysql Access denied for user 'root'@'localhost' (using password:YES)
- Linux 连接mysql数据库ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- linux下使用mysql数据库出现 “Access denied for user 'root'@'localhost' (using password: YES)”
- 螺旋矩阵
- poj3666-基础DP
- 乐观锁和悲观锁介绍
- 1.1 组件注册 vue shop
- ubuntu下mysql基本操作笔记
- linux mysql access denied for user ‘root’@’localhost'(using password:YES)
- synchronized和ReentrantLock
- Activity启动过程简要介绍
- 下拉多选控件介绍
- x86内存框架简介
- redis集群之添加节点
- linux yum命令详解
- eclipse背景设置什么颜色缓解眼睛疲劳
- Java集合--ArrayBlockingQueue