Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
configure LAMP for website on intranet instead of its default setting on internet Question Question
How can I kill all MySQL sleeping queries? Question Question

Question

Make public port on MySQL on Ubuntu

Posted March 19, 2016 3.6k views
Linux BasicsMySQL

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.

Add a comment
adrii
By:
adrii

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
configure LAMP for website on intranet instead of its default setting on internet Question Question
How can I kill all MySQL sleeping queries? Question Question

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.

×
Submit an Answer
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 Report
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 Report

Related

Looking for something else?

Ask a new question Search for more help