mysql remote access

Hi, maybe is late … but if you are running your mysql in mysql secure installation you have to :

• create a user with related privileges on schema/tables you want and set limit hosting access to the IP you are connecting from (this means that the user can access only from that IP)

• comment in the file /etc/mysql/mysql.conf/mysql.cnf (this is the configuration file used by mysql secure installation) the following line:

#bind-address=127.0.0.1

• restart mysql sudo service mysql restart

• add to your mysql server firewall the following rule: sudo ufw allow from IP_FROM_YOU_CONNECT to any port 3306

• test from your remote location with mysql -u *USER_CREATED_BEFORE *-h *MYSQL_SERVER_IP* -p

if everything is ok you will prompt for the user password and you will get to mysql shell

Tested on UBUNTU 16.04 and mySQL 5.7

I found that changing the bind-address in the /etc/mysql/mysql.cnf the bind-address is ignored. You can check with mySQL Workbench under System Variables (search for bind keyword)

I hope this helps.

Elizine sent a very good link.

It was a my.cnf bad configuration combined with a firewall problem. I could finally solve it.

Thanks a lot to eveybody !

MySQL firewall provide by Datasunrise work as an intermediary between users and database. That fitlers each incoming and outgoing traffic.

For more information please visit here:- https://www.datasunrise.com/firewall/mysql/

Please post the following section of your mysql config:

[mysqld]
...
skip-networking
...
bind-address = 
...

Also please post the output of the following mysql command:

SELECT User, Host FROM mysql.user WHERE Host <> 'localhost';

Which user are you trying to grant remote access? Also please post any error you get.