Can't perform ODBC connection to MySQL server on local network
- by Emmanuel
I have a wamp server running on LAN ip address 192.168.1.101 . From the browser on my PC which is on the LAN I can access the webserver and have as well set the phpmyadmin.conf file to be able to access the phpmyadmin interface. This works smoothly.
On the wamp server I have a database which I'd need to access from any PC on the LAN using the MySQL Connector/ODBC. The problem is that I do not manage to setup the connection correctly. Here are the paramenters I use:
Data Source Name: test_connection
Description: test conenction
Server: 192.168.1.101
Port: 3306
User: root
Password:
Database:
The error message I get is the following:
Connection Failed: [HY000][MySQL][ODBC 5.1 Driver]Can's connect to MySql server on '192.168.1.101' (10060)
Would anybody have a hint to set up correctly the connection?