Hello.
I am trying to acces a MySql server from another one with no results.
I configured MySql to accept connections remotely. Open firewall at 3306…
Inserted new DB remote users, checked their passwords…
And no results yet.
Any idea ?
Thanks in advance.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Accepted Answer
Please follow the steps in the link below to get remote access to MySQL - http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html
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.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.