I am trying to connect to a remote MySQL server 5.7 installed on Ubuntu 16.04 from my workstation.
Here is the error i am getting:
2003 - Can't connect to MySQL server on '220.127.116.11' (10061)
To make it work I followed the following steps.
GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ IDENTIFIED BY ‘my_password’ WITH GRANT OPTION;
sudo /etc/init.d/mysql restart
Some forums recommends commenting line starts with “bind-address” on my.cnf which resides in /etc/mysql/my.cnf. The problem is there is no such line on my installation.
# # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it would actually understand and use. # # For explanations see # http://dev.mysql.com/doc/mysql/en/server-system-variables.html # # * IMPORTANT: Additional settings that can override those from this file! # The files must end with '.cnf', otherwise they'll be ignored. # !includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mysql.conf.d/
I also tried to open ports on firewall using the following commands.
sudo ufw allow 3306/tcp sudo service ufw restart
But still stuck with the same problem.
Update: To make MySQL to listen to all interfaces i added bind-address=0.0.0.0 to my.cnf file. Now MySQL is not even restarting and throws the following error.
demo@ubuntu:~$ sudo /etc/init.d/mysql restart […] Restarting mysql (via systemctl): mysql.serviceJob for mysql.service failed because the control process exited with error code. See “systemctl status mysql.service” and “journalctl -xe” for details. failed! demo@ubuntu:~$
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!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Click below to sign up and get $200 of credit to try our products over 60 days!