CODEWITHSUNDEEP
mysqldatabaseremote-access
user3199791
user3199791

Reputation: 133

Cant connect to remote server: Tunnel error - could not open port forwarding to SSH channel

I have a VPS on which I am running MySql, I have created a user and provided all access by using:

mysql> CREATE USER 'root1'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root1'@'%'
    ->     WITH GRANT OPTION;

I then went onto a remote PC and attempted to connect to the database using: http://gyazo.com/4bfc541668170d4cdbac01037f3a0c51 When I run this from workbench, I get the following error: http://gyazo.com/6e76caf3134366b4fabbca58df016916

I am stuck on how I should fix this, initially I thought it was a port forwarding problem for port 3306 however, I have been informed that this does not matter for VPS's.

Upvotes: 0

Views: 2144

Answers (1)

Kevin Klinemeier
Kevin Klinemeier

Reputation: 21

In case others come along, I'm getting the same problem, and it is related to the server not accepting local tcp connections.

Test it out by opening a shell on the target server, and trying something like mysql --protocol=tcp -u user -p

It could be that you've got a firewall that is blocking them, or more likely that your server.cnv has a bind statement that isn't localhost, and hence, doesn't accept tcp connections from localhost.

Upvotes: 1

Related Questions