$handle = mysql_connect("localhost","root","passwordi") or die("连接到服务器时发生错误.");
mysql_select_db("learning") or die("Select db error.");
$res = mysql_query("select * from users");
$row = mysql_fetch_row($res);
echo $row[0];
?>
修改php.ini文件
error_reporting = E_ALL
让php显示所有的错误信息,
再次执行该脚本出现如下的错误信息:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in D:\www\yaya.php on line 11
连接到服务器时发生错误.
google了一下发现是酱紫的(新版的mysql密码算法不一样):
环境:WINDOWS/IIS/PHP/MYSQL
自由生活的一种方式,所以我也选者了PHP.
原因
当我把phpMyAdmin安装完以后进行测试时出现了配置文件错误的提示其中一句是
"Client does not support authentication protocol requested by server"
解决方法:
(原文地址http://dev.mysql.com/doc/mysql/en/Old_client.html)
CMD进入命令提示符窗口
cd c:\mysql
cd \bin
mysql
mysql>SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
然后任意选着下面两种方法:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
就可以了.