Can't connect to MySQL server (10060) and (4)

Asked Jul 20 '12 at 19:11

Active Nov 11 '12 at 05:04

Viewed 3,429 times

I'm trying to make an application in RealBasic. I'm failing to create a connection with the remote server.

On XP (VirtualMachine):

Can't connect to MySQL server on 'xxx' (10060)

On the latest OS X:

Can't connect to MySQL server on 'xxx' (4)

However: HeidiSQL & Sequel Pro connect fine. Another self-made app in .NET connects fine. Yet everything seems to be firewall related if I Google.

The code, if it helps:

dim db as new MySQLCommunityServer
db.host = ""
db.port = 3306
db.databasename = "dbname"
db.username = "dbuser"
db.password = "dbpass"
if (db.connect = true) then MsgBox("Connected") else MsgBox(db.errormessage)

edited Nov 11 '12 at 05:04

dda

6,030
2
25
34

asked Jul 20 '12 at 19:11

krtek

Check that your mysql server is set to allow TCP connections. Most default installs do not, and work with local unix-domain sockets only. – Marc B Jul 23 '12 at 16:34
Are you using SSL? Have you tried db.ConnectSSL instead? – Paul Lefebvre Jul 23 '12 at 16:17
why the host is an empty string? – Mario Sep 14 '12 at 22:03
Its just empty because it's an example. The problem is solved though - it had nothing to do with the app but with the mysql server just like Marc B suggested. – krtek Sep 17 '12 at 18:18

Can't connect to MySQL server (10060) and (4)

0 Answers0