我刚刚重新安装了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.
我无法连接,我该如何解决?
发布于 2018-01-11 08:46:36
使用
ALTER USER
语句,一个简单的解决方案:
SET PASSWORD = PASSWORD('xxxxxxxx');
发布于 2018-01-11 09:18:59
首先,使用:
mysql -u root -p
为“root”提供当前密码。下一步:
mysql> ALTER USER `root`@`localhost` IDENTIFIED BY 'new_password',
`root`@`localhost` PASSWORD EXPIRE NEVER;
更改'new_password'
用户“root”的新密码。
https://stackoverflow.com/questions/-100004130
复制相似问题