我现在改用PHP4了 但是MYSQL是5.0的phpmyadmin还是不对显示 #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client 怎么办
我现在把ROOT密码设置为空居然就可以了 但是在PHP5下面还是不能连接MYSQL大家看看怎么办
用root用户登录Mysql后mysql>set password for 'root'@'localhost' = old_password('password');然后重启Mysql服务即可
IIS已经帮你全部搞好了。
但是MYSQL是5.0的phpmyadmin还是不对显示
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
怎么办
但是在PHP5下面还是不能连接MYSQL大家看看怎么办
extension=php_mysqli.dll然后复制libmysqli.dll到System32或者Apache的bin目录,重启Apache,用以下代码连接<?php
$host = "localhost";
$user = "root";
$passwd = "password";
$dbname = "dbname";$mysqli = new mysqli($host,$user,$passwd,$dbname);if (mysqli_connect_errno()) {
printf("连接数据库失败");
exit();
}?>
不过还是想知道为什么PHP5不能用MYSQL5?
要么用低版本客户端的password算法,要么用PHP5的mysqli
低版本客户端密码的修改方法前面我给了