ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
来源:互联网 发布:电脑网络延迟高 编辑:程序博客网 时间:2024/05/01 22:03
在Mysql安装以后,登陆出现提示,使用:
[root@localhost]# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
然后输入命令:
mysql -u root mysql
进入安全模式下的Mysql
然后通过修改字段使用:
UPDATE user SET Password=PASSWORD('新密码') WHERE user=`root`;
完成修改。
然后使用命令:
mysql> FLUSH PRIVILEGES;
mysql> quit
再次登陆可以使用root和新密码登陆。
但是在进行操作的时候仍然会报错:
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
这时我们需要在Mysql命令行下使用命令:
mysql> SET PASSWORD =PASSWORD('刚刚设置的新密码‘);
然后就可以正常使用Mysql了。
0 0
- ERROR 1820 (HY000): You must SET PASSWORD before executing this
- ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- mysql:ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- 解决ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- 解决mysql,出现错误 ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- ubuntu14.10下解决"ERROR 1820 (HY000): You must SET PASSWORD before executing this statement"
- ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- mysql密码丢失 ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- MySql5.7 ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- Mysql 密码报错ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- linux mysql 报错ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- mysql安装过程中出现错误 ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- PHP并发IO编程之路
- runapps
- 12C-OCP升级1z-060-017
- 关于myeclipse里web工程访问src下servlet问题!!!急!
- 张量的展开与matlab下的工具包操作
- ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- Cg入门19:Fragment shader - 片段级模型动态变色
- 实验五:分析system_call中断处理过程
- Android官方开发文档Training系列课程中文版:添加ActionBar之自定义ActionBar样式
- vs2012安装opencv3.0
- Eclipse安装SVN教程
- eclipse转AndroidStudio
- 广度优先搜索应用一:着色法
- 一篇很全面的freemarker教程