Make public port on MySQL on Ubuntu

March 19, 2016 2k views
MySQL Linux Basics

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

2 Answers

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

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.
Have another answer? Share your knowledge.