Can't setup MySQL remote access on Ubuntu 15.04

1. Installed mysql fresh with apt-gets (~~[https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql" target="_blank">](https://www.digitalocean.com/community/ … with-mysql">https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql]()

2. Edited etc/mysql/mysql.conf.d

1. Replaced bind-address = 127.0.01 with bind-address = xx.xx.xx.xxx (my Linode host address)

3. Ran: sudo service mysql restart from terminal (returned without errors)

4. Tried to connect to xx.xx.xx.xxx from Sequel Pro, which resulted in following connection timeout message:

–-

Unable to connect to host xx.xx.xx.xxx, or the request timed out.

Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout.

MySQL said: Can’t connect to MySQL server on ‘xx.xx.xx.xxx’ (4)

netstat:

![](" />

1 Reply

Did you open the port in your firewall?

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct