Menu
adrii
By:
adrii

Make public port on MySQL on Ubuntu

March 19, 2016 786 views
MySQL Linux Basics

I installed MySQL on 3306 port. Change bind_address property of /etc/mysql/my.cnf file to 0.0.0.0. Then reload server. But still can`t access from Toad client.

Log In to Comment
2 Answers
Woet March 19, 2016

Most likely ufw, but you shouldn't do this. MySQL sends data and passwords plaintext. Use a SSH tunnel.

Reply
ashwinmuni March 20, 2016

Its True that MYSQL sends data in plain text format, but with that said do the following to check if your server is reachable

  • Ping the Server from the client node
  • use NMAP or telnet to see if you can telnet to port 3306 [Windows Use : Dtelnet, Linux Already has telnet]
  • Also see if you have firewall enabled on the server.
Reply
Have another answer? Share your knowledge.

Related Questions