I'm having trouble connecting to Mysql on IIS 6 across a lan on Win Server 2003. No problem logging in as root at the command prompt. PhpMyAdmin says:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
MySQL said: Documentation
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
My own connection script produces:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\inetpub\wwwroot\index.php on line 1
I'm running Mysql 4.1.
I don't know if 3306 is blocked or not.
Can anyone tell me if there is something else besides 3306 block that might be causing this problem or is there a fix to this problem?
that's usually an incompatibility between the client API you're using and the one MySQL wants. What version of MySQL are you using and what API are you using in PHP? I'll guess you're running 4.1+ for MySQL and 3.23+ for PHP. That'd be the problem. Try switching to MySQLi