mac mysql error You must reset your password using ALTER USER statement before executing this statem
来源:互联网 发布:学数据库有前途吗 编辑:程序博客网 时间:2024/05/22 12:03
安装完 mysql 之后,登陆以后,不管运行任何命令,总是提示这个
Step 1:
SET PASSWORD = PASSWORD('your new password');
Step 2:
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
Step 3:
flush privileges;
完成以上三步退出再登,使用新设置的密码就行了
参考1: https://dev.mysql.com/doc/refman/5.6/en/alter-user.html
参考2: http://dev.mysql.com/doc/refman/5.7/en/password-expiration-policy.html
参考3: http://stackoverflow.com/questions/33467337/reset-mysql-root-password-using-alter-user-statement-after-install-on-mac
0 0
- mac mysql error You must reset your password using ALTER USER statement before executing this statem
- mac mysql error You must reset your password using ALTER USER statement before executing this statem
- mysql error You must reset your password using ALTER USER statement before executing this statement.
- 错误mac mysql error You must reset your password using ALTER USER statement before executing this stat
- 【mysql】You must reset your password using ALTER USER statement before executing this statement.
- MySQL错误:You must reset your password using ALTER USER statement before executing this statement.
- Mysql报错:You must reset your password using ALTER USER statement before executing this statement.
- ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this ..
- mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing t
- 【MySQL】ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing
- [mysql] ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing
- You must reset your password using ALTER USER statement before executing this statement.
- You must reset your password using ALTER USER statement before executing this statement.
- You must reset your password using ALTER USER statement before executing this statement.
- You must reset your password using ALTER USER statement before executing this statement.
- You must reset your password using ALTER USER statement before executing this statement.
- mysql5.7 You must reset your password using ALTER USER statement before executing this statement.
- You must reset your password using ALTER USER statement before executing this statement.
- Page Cache的优化(随笔)
- hibernate_刚开始犯的错!
- Hexo个人博客搭建问题之 './build/Release/DTraceProviderBindings'] code: 'MODULE_NOT_FOUND'
- android activity之间传递ArrayList<HashMap<String,Object>>
- 实时系统动态内存算法分析dsa(二)——TLSF代码分析
- mac mysql error You must reset your password using ALTER USER statement before executing this statem
- Ostu(大津法)二值化图像简介
- 图解Wireshark安装
- python phantomjs+ selenium2 抓取动态js网页(版本python2.7+)
- Intent 和 Intent 过滤器
- 9.进程间通信---信号量集
- PowerPoint2007不能撤消所做的更改
- python dict与json转换
- 123