I am having difficulty accessing MySQL remotely.
I have tried accessing the database via MySQL Workbench (the “Standard TCP/IP over SSH” option) and phpMyAdmin. Both fail when I try to login.
I followed the ‘how to secure MySQL’ tutorial to set up the database and my sense is some of the options enabled through the tutorial block remote access… but I’m not sure exactly what is going on.
I have gone through other tutorials here on the topic but none have overcome this problem.
I can login and access the database locally using putty.
My VPS is running ubuntu and have Java, Tomcat and MySQL installed. I use my server to run a mobile android app. I have also installed fail2ban and I have set up IP tables.
Thanks
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.
hi, in my case i am trying to access mysql workbench remotly , the thing is , the two computers are binded using a home group , will that work ?
I had issues to, until I found this thread relating to the SSH pub key: https://www.digitalocean.com/community/questions/trying-to-connect-to-mysql-database-server-through-mysql-workbench-using-ssh?comment=42471
Same problem here