I am currently setting up a database driven website and am trying out some new software to quicken my development time. The software is called dbQwiksite (www.dbqwiksite.com
The hosting provider uses phpMyadmin and access to the database is remote
Although the database is a MySQL database, dbQwiksite requires that I set up a DSN (usually not required for MySQL and php).
Naturally when setting up a DSN, I cannot stipulate “localhost” otherwise it simply looks on my machine for the database. I therefore asked for the IP address.
The IP address I used was 18.104.22.168
When I try to test the connection, I get the following error:
[MySQL][ODBC 3.51 Driver] can’t connect to MySQL server on ‘22.214.171.124’ (10060)
Please advise what can be done to enable me to connect properly.