IIS5+php5.2+MYSQL,配置完成后,我写了两个测试文件testphp.php和testMysql.php
发现php和IIS配置成功,但mysql老是连接不上,testMysql.php内容如下:
<?php
$link=mysql_connect("localhost","root","root");
if(!$link) echo "没有连接成功!";
else echo "连接成功!";
?>
错误内容如下:
Notice: mysql_connect() [function.mysql-connect]: SQL safe mode in effect - ignoring host/user/password information in E:\PHPDownloads\phpmps_v2.0_build091130_utf8\upload\testMysql.php on line 2Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in E:\PHPDownloads\phpmps_v2.0_build091130_utf8\upload\testMysql.php on line 2
没有连接成功! 我已进行了如下配置:
1、extension=php_dba.dll,extension=php_dbase.dll,extension=php_mysql.dll
2、把libmysql.dll php_mysql.dll php5ts.dll 和 php5gd2.dll放到xp系统windows\system32\下面救命....
发现php和IIS配置成功,但mysql老是连接不上,testMysql.php内容如下:
<?php
$link=mysql_connect("localhost","root","root");
if(!$link) echo "没有连接成功!";
else echo "连接成功!";
?>
错误内容如下:
Notice: mysql_connect() [function.mysql-connect]: SQL safe mode in effect - ignoring host/user/password information in E:\PHPDownloads\phpmps_v2.0_build091130_utf8\upload\testMysql.php on line 2Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in E:\PHPDownloads\phpmps_v2.0_build091130_utf8\upload\testMysql.php on line 2
没有连接成功! 我已进行了如下配置:
1、extension=php_dba.dll,extension=php_dbase.dll,extension=php_mysql.dll
2、把libmysql.dll php_mysql.dll php5ts.dll 和 php5gd2.dll放到xp系统windows\system32\下面救命....
safe_mode = Off
这是不是表明安全模式已关呢,可是问题依旧啊...郁闷...
通过这个工具可以登陆吗?
要是实在不行,那建议你去别的可以的机子上看一下php.ini文件的配置
看看跟你的有什么不一样,可以通过WinMergeU软件来看一下,这个软件我感觉挺好用
[SQL]
sql.safe_mode = Off //查看你的是不是On,改为Off