php連接mysql常見四種情況與錯誤訊息

Home Home
引用 | 編輯 anstd
2005-08-21 13:14
樓主
推文 x0
編輯一個php連接nysql的網頁 包括下列四種情況
假設web server與mysql都在同一部server
連線位置用 localhost即可
假設帳號為bbb
密碼為ccc


複製程式
<?
echo "===================完整無誤的連接=================<br>";
mysql_connect("localhost","bbb","ccc");
echo "===================連接server位置錯誤=================<br>";
mysql_connect("111.111.111.111","bbb","ccc");
echo "===================server與user正確,但passwd錯誤=================<br>";
mysql_connect("localhost","bbb","xxx");
echo "===================server正確,但user,passwd錯誤=================<br>";
mysql_connect("localhost","aaa","aaa");
?>

連上測試網頁後將看到

===================完整無誤的連接=================
(連線成功無任何訊息)
===================連接server位置錯誤=================

Warning: mysql_connect(): Can't connect to MySQL server on 飇.111.111.111' (4) in /srv/www/htdocs/phptest/php_mysql.php on line 5
===================server與user正確,但passwd錯誤=================

Warning: mysql_connect(): Access denied for user: 'bbb@localhost' (Using password: YES) in /srv/www/htdocs/phptest/php_mysql.php on line 7
===================server正確,但user,passwd錯誤=================

Warning: mysql_connect(): Access denied for user: 'aaa@localhost' (Using password: YES) in /srv/www/htdocs/phptest/php_mysql.php on line 9

獻花 x0