Re: mysql_connect - Access Denied

[Benjamin Choi]

The error returned indicates that the MySQL client (within PHP) is incompatible with the MySQL server.

Note that PHP 4's MySQL client is unable to authenticate correctly with MySQL 4.1 server unless one configures MySQL server to support the old password scheme. See workarounds at http://dev.mysql.com/doc/mysql/en/Old_client.html.

And if you want to use MySQL 4.1 as is with your PHP applications, you must use PHP 5. Furthermore, with PHP 5, you must use the MySQLi extension in order to connect to MySQL servers 4.1.3 and up. Bear in mind that MySQLi has a different set of functions from the regular ones and also introduces new classes. See http://www.php.net/mysqli for details.