I am able to connect to a remote MySQL database that is hosted on a Ubuntu VM through SSH and can add the database in MySQL Workbench at my home desktop. However, when I am travelling and using my laptop, I can still connect using SSH, however I cannot use the database in MySQL Workbench. I am having trouble figuring out a solution for this problem. Any help is appreciated.
2
-
Is your userid allowed from any IP address?Jayvee– Jayvee2016-10-08 22:58:14 +00:00Commented Oct 8, 2016 at 22:58
-
Yes, and I'm sure of this because I can login just fine using the terminal however it won't work with MySQL Workbench.Vocany– Vocany2016-10-08 23:05:13 +00:00Commented Oct 8, 2016 at 23:05
Add a comment
|
2 Answers
If you can't connect the DataBase using your Workbench, the workbench will give you an error. What is the error code? Is there any decription or information? MySQL's default server port is 3306, the connect user must have the privileges to connect the server from another PC.
Use use mysql; select Host,User from user; Confirm that the Host's value is '%', not 'localhost' or something else.
Then check port 3306 is open on your server. Type netstat -an | grep 3306 or netstat -tln on your SSH console. Make sure you can find 3306 LISTEN
Then check your workbench configuation, make sure these are all correct.
Without the error code and decription, that is all the reasons and solutions I can give you. Wish this would help you.
1 Comment
Vocany
I appreciate your time. I checked and the host value is in fact '%' and port 3306 on the server is listening. The error I receive is failed to connect to MySQL at xxx.xxx.xxx.xxx:3306 with 'username'. I'm pretty sure the IP address I entered for the host is correct and the username I used has '%' for the host value. Thanks for taking the time to answer my post.
The reason I was unable to add the database through MySQL Workbench was simply because I forgot to open the port for the connection. Simple user error.