Standalone MySQL server, unable to connect

Question

Standalone MySQL server, unable to connect

development

Hi,

I've followed this guide:

http://library.linode.com/databases/mys … -etc-hosts">http://library.linode.com/databases/mysql/standalone-mysql-server#sph_edit-etc-hosts

I've got two Linodes (in the same data center) and followed each step in the guide. However, I'm unable to connect to the MySQL-Linode from my App-Linode. I'm able to ping from "foo.app1" to "foo.mysql1" and vice versa, but when I'm trying to connect to MySQL I'm getting:ERROR 2003 (HY000): Can't connect to MySQL server on 'foo.mysql1' (110)

MySQL is working on the MySQL-Linode though when I'm connecting using mysql -h localhost -u root -p.

I have no idea what's going on, nothing in the logs so I'm a bit stuck here. Thanks!

4 Replies

forum:Guspaz · Answer 1 · Dec. 6, 2012, 7:11 p.m.

forum:Guspaz 11 years, 9 months ago

You're sure you did the bind-address part, and restarted mysql after doing it? You're sure you don't have any sort of firewall rules that might be blocking the connection?

forum:Webkungen · Answer 2 · Dec. 6, 2012, 7:52 p.m.

forum:Webkungen 11 years, 9 months ago

Yes! It's exactly as the guide tells me: (/etc/mysql/my.cnf)bind-address = foo.mysql1

And restarted…

forum:obs · Answer 3 · Dec. 7, 2012, 4:25 a.m.

forum:obs 11 years, 9 months ago

You should use your internal ip address for bind address not foo.mysql1

forum:Webkungen · Answer 4 · Dec. 7, 2012, 6:21 p.m.

forum:Webkungen 11 years, 9 months ago

Thanks! It worked well! Also, the connection was locked by CSF.. :) Wasn't thinking about that, so after I added the exception in the firewall and changed to the servers' ip it works fine.

Compute

Storage

Databases

Networking

Developer Tools

Delivery

Security

Services

Industries

Pricing

Community

Engage With Us

Standalone MySQL server, unable to connect

4 Replies

Reply

Tips: