mac下修改mysql密码

比眉伴天荒 2022-08-20 12:14 175阅读 0赞

安装完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

[mac mysql error You must reset your password using ALTER USER statement before executing this statement.][]

标签：[style][]   [com][]   [http][]   [si][]   [使用][Link 1]   [sp][]   [html][]   [for][]   [io][]

原文：http://www.cnblogs.com/debmzhang/p/5013540.html

[new]: http://cpro.baidu.com/cpro/ui/uijs.php?adclass=0&app_id=0&c=news&cf=1001&ch=0&di=128&fv=20&is_app=0&jk=eb91805f7228b385&k=new&k0=new&kdi0=0&luki=1&mcpm=0&n=10&p=baidu&q=65035100_cpr&rb=0&rs=1&seller_id=1&sid=85b328725f8091eb&ssp2=1&stid=9&t=tpclicked3_hc&td=1836545&tu=u1836545&u=http%3A%2F%2Fwww%2Ebubuko%2Ecom%2Finfodetail%2D1231425%2Ehtml&urlid=0
[mysql]: http://cpro.baidu.com/cpro/ui/uijs.php?adclass=0&app_id=0&c=news&cf=1001&ch=0&di=128&fv=20&is_app=0&jk=eb91805f7228b385&k=mysql&k0=mysql&kdi0=0&luki=2&mcpm=0&n=10&p=baidu&q=65035100_cpr&rb=0&rs=1&seller_id=1&sid=85b328725f8091eb&ssp2=1&stid=9&t=tpclicked3_hc&td=1836545&tu=u1836545&u=http%3A%2F%2Fwww%2Ebubuko%2Ecom%2Finfodetail%2D1231425%2Ehtml&urlid=0
[mac mysql error You must reset your password using ALTER USER statement before executing this statement.]: http://www.bubuko.com/infodetail-1231425.html
[style]: http://www.bubuko.com/so/1/style
[com]: http://www.bubuko.com/so/1/com
[http]: http://www.bubuko.com/so/1/http
[si]: http://www.bubuko.com/so/1/si
[Link 1]: http://www.bubuko.com/so/1/%e4%bd%bf%e7%94%a8
[sp]: http://www.bubuko.com/so/1/sp
[html]: http://www.bubuko.com/so/1/html
[for]: http://www.bubuko.com/so/1/for
[io]: http://www.bubuko.com/so/1/io