我刚刚擦除了我的Mac,并重新安装了El Capitan。我现在正在努力连接到Mysql。在完成web服务器设置过程之后,我创建了一个简单的PHP测试文件:
<?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
重置密码
https://stackoverflow.com/questions/33387879
复制相似问题