php code:
Code: Select all
<?php
mysql_connect("localhost", "root", "rootPassword");
mysql_select_db("forum_db");
?>Code: Select all
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in j:\apache\apache\htdocs\test\dbconnection.php on line 2
Warning: mysql_select_db(): Access denied for user 'ODBC'@'localhost' (using password: NO) in j:\apache\apache\htdocs\test\dbconnection.php on line 3
Warning: mysql_select_db(): A link to the server could not be established in j:\apache\apache\htdocs\test\dbconnection.php on line 3Code: Select all
mysql> select user,host,password from mysql.user;
+----------+-----------+-------------------------------------------+
| user | host | password |
+----------+-----------+-------------------------------------------+
| root | localhost | *9BC01A49104D6960C8C288548AD36884E0B580D8 |
| root | % | rootPassword |
| raghavan | localhost | *7ED9914DFC68CFA990B39A56635E9CBDE3E1F4E0 |
| francis | localhost | *63DAA25989C7E01EB96570FA4DBE154711BEB361 |
| visitor | localhost | *BE9CCED926640666CC59F47E0B9D3A98A2CB94C4 |
| dummy | localhost | |
+----------+-----------+-------------------------------------------+
6 rows in set (0.02 sec)