C
C
chelkaz2017-06-20 19:39:15
linux
chelkaz, 2017-06-20 19:39:15

I can't access Mysql via SSH, maybe a firewall?

I remotely connect to the server without problems, then I
connect without problems:
mysql -h 127.0.0.1 -P 3306 -u root -p
and so
mysql -h localhost -P 3306 -u root -p
But when I try to access MySql remotely via SSH from the WorkBench or SequelPRO program, then:

Your connection attempt failed for user 'dataroot' from your host to server at 127.0.0.1:3306:
  Tunnel error: Could not open port forwarding SSH channel: (1, 'Administratively prohibited')

Here is the config... What's the matter?
[client]
port = 3306
socket=/var/lib/mysql/mysql.sock

[mysqld]
user=mysql

port = 3306
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

symbolic-links=0
bind-address=0.0.0.0
server-id=1

local-infile=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anton Artyomov, 2017-06-20
@ArtyomovAnton

Perhaps your database does not have the user [email protected]% or [email protected] or [email protected] on behalf of which you are connecting.
Still as a variant, you incorrectly configure the tunnel in workbanck. Does the tunnel work for example in HeidiSQL?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question