RE: mysql odbc connector 5.1 connection error
"Bonnett, John" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
It is good if you tell us exactly what error you are seeing. One issue that springs to mind since you are connecting from a remote client is, Is the user you are trying to connect as allowed to connect from the IP address of the client. The security in MySQL is very specific and you not only need to have a valid user name and password but also be allowed to connect from the desired IP address. Check the GRANTs for the user name you are trying to use and look for restrictions on where it can connect from. John Bonnett -----Original Message----- From: Martin Mabuwa [mailto:[email protected]] Sent: Tuesday, 22 July 2008 5:03 AM To: [email protected] Subject: mysql odbc connector 5.1 connection error I have not able to connect to mysql dababase using the odbc connector from a client windows workstation. I am able to connect using the odbc from the machine that is hosting my sql server (localhost). I am using the ip address of the server to try and configure the odbc connector and I continue to receive errors. I have turned off the firewall but this does not seem to help. Any recommendations -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]