引用 | 編輯
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
|