Unable to connect to remote MySQL

iamsam · #1 (**permalink**) 06-20-09, 20:04

Hey, guys. I've got a problem I hope you could help me with. I've been trying to connect to my MySQL database using SQLyog so I can manage it remotely. However, I keep getting an error that says "Can't connect to MySQL server". I've checked and made sure that all the settings (mysql server, username and password, etc.) are correct and they are, but I just can't seem to connect to my database.

Is there anything I could do to fix this?

JeremyWJ · #2 (**permalink**) 06-21-09, 16:53

Quote:

Originally Posted by iamsam

Hey, guys. I've got a problem I hope you could help me with. I've been trying to connect to my MySQL database using SQLyog so I can manage it remotely. However, I keep getting an error that says "Can't connect to MySQL server". I've checked and made sure that all the settings (mysql server, username and password, etc.) are correct and they are, but I just can't seem to connect to my database.

Is there anything I could do to fix this?

Make sure external connections are allowed. Sometimes its set so only localhost can connect.

If that is the case you have two options.

1) Change the setting to allow external connections or at least connections from your IP

2) Connect through SSH (I believe SQLyog offers this)

The other possibility is your firewall if you have one.

iamsam · #3 (**permalink**) 06-21-09, 17:57

Thanks for your help, Jeremy! Looks like connecting through SSH did it. SQLyog only offers the feature in their premium editions (I think) and not in the free one, so I went ahead and uninstalled SQLyog and then installed Navicat. The SSH tunneling option in Navicat worked wonderfully.

Looks like it's goodbye SQLyog, hello Navicat! :D

JeremyWJ · #4 (**permalink**) 06-21-09, 19:50

Quote:

Originally Posted by iamsam

Thanks for your help, Jeremy! Looks like connecting through SSH did it. SQLyog only offers the feature in their premium editions (I think) and not in the free one, so I went ahead and uninstalled SQLyog and then installed Navicat. The SSH tunneling option in Navicat worked wonderfully.

Looks like it's goodbye SQLyog, hello Navicat! :D

Navicat is what I use

Like I said though, if you go in and allow external connections in the mysql config you wont have to use SSH. Although, honestly I think its better to use ssh for obvious reasons.

iamsam · #5 (**permalink**) 06-21-09, 20:23

I did allow external connections, but it just wouldn't connect, not even in Navicat. It was set to allow %, which should allow all IPs, I believe (I'll have to tweak that later to only my IP range). Strange that I could connect via SSH, though, but like you said, it's better that way. ;)

Thanks again!