Connection to MySQL on server via ODBC

I'm writing a desktop application (in Delphi). I would like to connect to MySQL database on a server. Up till now I tested my application using MySQL installed on my local computer. I used ODBC connector and all tests went successfully. Problems have started when I tried to connect database on server via ODBC. I'm getting connection failed message all the time and I cannot do anything.

Please tell me, how should I connect to this MySQL?

Answers


By default, mysql listens for incoming connections on port 3306. Use can use telnet to test if a networking problem or firewall is preventing you from connecting to the server that MySQL is running on, using the following command:

telnet fqdn.of.mysqlserver.com 3306

If successful, you should see that it connects, followed by some encrypted gibberish from MySQL. If it doesn't connect, then the problem is a firewall, a networking problem, the MySQL server is unreachable, or something else blocking the connection.


Need Your Help

Receiving multiple HTTP requests from Firefox 12.0 on an App Engine handler

python google-app-engine firefox webapp2

I'm experiencing some bizarre behavior with Firefox 12.0 and a Python handler on GAE.