Hi,
I'm trying to run a PHP web application with MySQL on IIS. It's an existing application (running at the moment on a Linux server) written for PHP4 and it uses MySQL 4. So I've downloaded the latest version of PHP4 (4.4.9) and the version of the MySQL server that's already running (4.1.12). I can get the IIS server to serve php pages, but I can't connect to the MySQL server; mysql_connect gives the following error message:
"Client does not support authentication protocol requested by server; consider upgrading MySQL client"
I verified that the MySQL server is running (the service is running) using the MySQL Administrator, I was able to connect and check existing databases.
These are the setup steps I followed (I found them on this page:
http://www.atksolutions.com/articles/install_php_mysql_iis.html)
- I put the PHP related files in C:\php and copied all files from the sapi subdirectory to the root;
- copied the php.ini-recommended file to the windows directory, renamed it to php.ini and changed the extenstions_dir entry to "c:\php\extenstions" (this subdirectory is present in the c:\php);
- IIS configuration: I added the .php extension to the Application Configuration, pointing to c:\php\php4isapi.dll (all verbs);
- I installed MySQL with these settings: "Detailed Configuration", "Developer Machine", "Non-Transactional Database Only", "Decision Support (DSS)/OLAP", "Check Enable TCPIP Networking", Port 3306, "Standard Character Set", "Install as a Windows Service"
- Afterwards I copied the libmysql.dll (c:\php\dlls) to the System32 folder.
(I skipped adding the following entries extension=php_mysql.dll and extension=php_mysqli.dll to php.ini )
The following values for MySQL I found using phpinfo:
>>>>
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.49
Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off
<<<<
I would appreciate if anyone could point out what I'm missing. Thanks in advance.
Best regards,
Wim.
Start Free Trial
