Database related Q&A
1. FAQ: I can't connect to MySQL 4.x from the IDE. When I tried to connect to mysql it returns with Client does not support authentication protocol requested by server; consider upgrading MySQL client error box.
It means you have to replace libmysql.dll that comes with phped with one shipped with mysql database.
Starting with build 3397 PHPEd supports libmysql.dll version 4.x. But can not be distributed with it because of MysqL license.
2. FAQ: I can't connect to MySQL 4.x from my script
When I execute the mysql_connect istruction accur this error: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client
It means that you have to install appropriate mysql library and mysql for php extension. Without them you can't connect to mysql database server version 4 or higher as they use different authentication protocol.
BTW, appopriate modules are shipped with php5 and php4.1.
3. FAQ: I can't connect to MySQL (error 10061)
Whenever I try to connect to database I get Cant conect to MYSQL server on localhost(10061)
Error 10061 means that no service is running on the port you selected for in mySQL settings OR mySQL server is NOT running.
- Make sure mysql service is running
- Make sure mysql is running on TCP/3306 port and this port is selected for the account.
The following command will show you all listening sockets (and daemons PIDs) running on your computer.
netstat -naop TCP
For example an output like below ensures that the process 932 is listening on port 3306:
Proto Local Address Foreign Address State PID
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING 1560
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING 4
TCP 0.0.0.0:1025 0.0.0.0:0 LISTENING 1768
TCP 0.0.0.0:1031 0.0.0.0:0 LISTENING 4
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING 932
Then open Task Manager, enable PID column and see what process name corresponds to the PID (932 in my example).
| 
Installation and Configuration Q&A
