How to Allow Remote MySQL Database Connection

I’ll put my 2 cents in here and per Clifton’s follow-up. You can connect remotely with no adjustment to your MySQL settings if you use SSL connections with your MySQL client. I use Sequel Pro (on OSX) and you simply enter your SSH credentials (allows you to designate an SSH Key file) and you enter the MySQL credentials as usual. Not only easy, no change to settings, but you don’t have to open more ports, etc so it’s more secure to boot!.

Hello beautiful people, <br> <br>Well, I have a desktop application and I need to access my vps database to manipulate the data. <br> <br>What I already did: <br>Commented bind-address in /etc/mysql/my.cnf <br>Grant permissions to myuser@‘%’ <br>(allow all ips because anyone with any ip who are using the applications would be allowed to connect, I think need to be that way for a desktop application, isn’t?) <br>Restart mysql (service mysql restart) <br>Did netstat -plutn to see and mysql are listening in port 3306 <br> <br>So, I copy the IP to my string connection in the application, set the username, password and database name, and It can’t connect. <br> <br>If I use these values (to connect to localhost) my app works fine: <br> <br>// LOCALHOST (Wamp in my personal computer) <br>server = “localhost”; <br>database = “cSharpTeste”; <br>uid = “root”; <br>password = “”; <br> <br>But If I try those values to an online connection (the configuration I need) <br> <br>// ONLINE (My VPS Droplet) <br>server = “198.211.112.xxx:3306”; <br>database = “cSharpTeste”; <br>uid = “testUser”; <br>password = “testPassword”; <br> <br>I got an error: <br>“Unable to connect to nay of the specified MySQL hosts. (Error Number: 1042)” <br> <br>If I change ‘server = “198.211.112.xxx:3306”;’ to ‘server = “198.211.112.xxx”;’ (withou port number) It takes longer, but got the same error. <br> <br>I really need to put this to work, I need that to continue my job, any help will be appreciated. :D

Hi, all

We have an existing tutorial on how to allow remote access to MySQL which you can check here:

https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql

Hope that this helps! Regards, Alex