我刚刚擦了我的Mac,并重新安装了El Capitan。我现在努力连接到Mysql。经过一个Web服务器设置过程,我创建了一个简单的PHP测试文件:
$conn = new mysqli("127.0.0.1", "root", "xxxxxxxx");
if ($conn->connect_error) echo "Connection failed: " . $conn->connect_error;
else echo "Connected successfully";
phpinfo();
?>
当我运行它,我得到这个错误:
Warning: mysqli::mysqli(): (HY000/1862): Your password has expired. To log in you must change it using a client that supports expired passwords. in /Users/rich/Documents/DESIGN/test/index.php on line 3
Connection failed: Your password has expired. To log in you must change it using a client that supports expired passwords.
我从来没有见过来自连接的响应。如果我无法连接,我该如何解决?
编辑
在终端我输入命令:
mysql -u root -p
这问我我的密码(当前一个),我放入。我现在有访问mysql命令,但任何我尝试导致此错误:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
如何使用ALTER USER重置密码?
博主在更新Mac系统后遇到了MySQL连接失败的问题,错误提示显示密码已过期。通过尝试使用终端命令`mysql -u root -p`进入MySQL,但执行任何操作时都收到需要使用ALTER USER语句重置密码的错误。目前,博主正寻求如何使用ALTER USER来更新密码的方法。
1062

被折叠的 条评论
为什么被折叠?



