Question

Make public port on MySQL on Ubuntu

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.


Submit an answer

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!

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

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.

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.

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