Answer the question
In order to leave comments, you need to log in
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')
[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
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 questionAsk a Question
731 491 924 answers to any question