In the MySQL configuration file, change the bind-address = directive to your droplet's public IP address.

Thank you Pablo!

I treyed with this, but indicated the following:

In the file /etc/my.cnf
==============================
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
bind-address ###.###.###.## //IP of my Server Droplet

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
==============================

# /etc/init.d/mysqld restart
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

bind-address ###.###.###.## //IP of my Server Droplet
make that
bind-address = ###.###.###.## //IP of my Server Droplet

Hi guys!

I followed the steps you indicated and corrected the detail, but I still without being able to connect.

This is the message:

Connection Failed
Host 'my.ip.work.station.static.axtel.net' is not allowed to connect to this MySQL server

Best regards!

Did you open MySQL's port in the firewall?

Hi Pablo,
as I can see this?

Check out How To Setup a Basic IP Tables Configuration on Centos 6

Hi Pablo!

This is my firewall

# iptables -L -n
Chain INPUT (policy DROP)
target prot opt source destination
ACCEPT all -- 0.0.0.0/0 0.0.0.0/0 state RELATED,ESTABLISHED
DROP tcp -- 0.0.0.0/0 0.0.0.0/0 tcp flags:0x3F/0x00
DROP tcp -- 0.0.0.0/0 0.0.0.0/0 tcp flags:!0x17/0x02 state NEW
DROP tcp -- 0.0.0.0/0 0.0.0.0/0 tcp flags:0x3F/0x3F
ACCEPT all -- 0.0.0.0/0 0.0.0.0/0
ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:80
ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:443
ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:25
ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:26
ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:465
ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:110
ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:995
ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:143
ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:993
ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:22
ACCEPT tcp -- my.ip.work.station 0.0.0.0/0 tcp dpt:22
ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:3306

Chain FORWARD (policy ACCEPT)
target prot opt source destination

Chain OUTPUT (policy ACCEPT)
target prot opt source destination

see something strange?

Firewall looks okay. After you changed the bind-address, did you restart MySQL?

Also, instead of opening up the MySQL port to the entire world, are you able to limit it to a few IPs? The question is, how many remote hosts need to connect to MySQL? If (i) a few and (ii) they have static IPs, then you're best advised to limit MySQL access to those IPs, only.

Lastly, are the remote hosts trying to connect to MySQL also behind a firewall?

Hello Pablo,

Thank you very much for the help.

Restart MySQL?
Yes, yes I did.

How many remote hosts need to connect to MySQL?
I need to connect remotely from 2 teams mac os , one at home and one in my work.

the remote hosts are trying to connect to MySQL Also behind a firewall?
No, because I could connect to other servers without problem.

any other idea?

Best regards

Did you grant your MySQL user privileges to access the database on the public IP?

Hi Pablo,

I tried entering the following command but it gives me error

# mysql -u root -p

mysql> update db set Host=’111.11.11.1‘ where db=’db_name‘;
ERROR 1046 (3D000): No database selected

think you are missing a step?

Where did you get that command from?

Did you add a user for connecting remotely? See https://www.digitalocean.com/community/articles/how-to-create-a-new-user-and-grant-permissions-in-mysql

Replace localhost with 1.2.3.4 where 1.2.3.4 is your home IP address.

restart mysql on ubuntu: sudo service mysql restart