mysql remote access

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/

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.