本人之前用 Dreamweaver、Wampserver、Navicat for sql 三个工具创建过动态页面。但很久没用,最近再次打开Wampserver、Navicat for sql,连接时发现sql调试过程中出现了1862的错误:Your password has expired. To log in you must change it using a client that supports expired passwords.
在网上看过相关的问题,但没找到适合的解决办法。这方面有经验的能帮忙看下怎么解决吗?谢谢啦!具体的问题如下:
利用代码测试,sql出现如下图所示错误:
<?php
/* Using "mysqli" instead of "mysql" that is obsolete.
* Utilisation de "mysqli" ?la place de "mysql" qui est obsol鑤e.
* Change the value of parameter 3 if you have set a password on the root userid
* Changer la valeur du 3e param鑤re si vous avez mis un mot de passe ?root
*/
$mysqli = new mysqli('127.0.0.1', 'root', '');
if ($mysqli->connect_error) {
die('Connect Error (' . $mysqli->connect_errno . ') '
. $mysqli->connect_error);
}
echo 'Connection OK';
$mysqli->close();
?>
还有:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>连接数据库</title>
</head>
<body>
<?php
error_reporting(E_ALL & ~E_DEPRECATED);
$mysql_server_name='localhost';
$mysql_username='root'; //登录mysql的账号
$mysql_password=''; //登录mysql的密码
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password) ;
//mysql_query("set names 'utf8'");
if(!$conn){
echo '<p align=center>服务器连接失败...</p><br>';
exit(-1);
}else{
echo "<p align=center>服务器连接成功...yeak!</p><br>";
}
?>
</body>
</html>
上面是Wampserver两种调试过程中出现的问题,下面是Navicat for sql连接时出现的问题:
麻烦有懂的可以帮忙看一下,告诉一下解决的方法,谢谢谢谢啦!