I try to connect with my mysql server via ssh tunnel, but I get always the sql error 1045.
My phpmyadmin connection works.
My putty mysql monitor connection works. (mysql -h localhost -u username -p database)
I set the same parameter in my heidisql:
Settings mysql
Network Typ: SSH Tunnel
Hostname/IP: localhost
Username: my_mysql_username
Password: my_mysql_password
Port: 3307
Compressed client/server protocol: false
Databases: blank
Startup script: blank
Settings ssh tunnel
plink exe locations: C:\Programme\PuTTY\plink.exe
SSH Host + Port: myhost port:22
Username: my_ssh_username
Password: my_ssh_password
Private key file: no
Local port: blank or 0
Access denied sql error 1045
Yes I have do this before but then I get the following error:
SQL Error 2003 Can't connect to MYSQL Server on localhost (10061)
I think there must be something wrong with heidisql because when I set so crazy thinks like:
SSH Host + Port: fksdfjksdfklsdkl
then he said not that I can't connect but show me the sql error 1045 Access denied..
I think that cannot be right.
SQL Error 2003 Can't connect to MYSQL Server on localhost (10061)
I think there must be something wrong with heidisql because when I set so crazy thinks like:
SSH Host + Port: fksdfjksdfklsdkl
then he said not that I can't connect but show me the sql error 1045 Access denied..
I think that cannot be right.
Have the same issue.
I'm using plink version 0.61.9264.0
I successfully connect to host using putty but get the error 1045 in both settings
Settings ssh tunnel
plink exe locations: C:\Programme\PuTTY\plink.exe
SSH Host + Port: myhost port:22
Username: my_ssh_username
Password: my_ssh_password
Private key file: no
Local port: 3306
and
Settings ssh tunnel
plink exe locations: C:\Programme\PuTTY\plink.exe
SSH Host + Port: myhost port:22
Username: my_ssh_username
Password: blank
Private key file: no
Local port: 3306
settings for mysql is next
Settings mysql
Network Typ: SSH Tunnel
Hostname/IP: localhost
Username: my_mysql_username
Password: my_mysql_password
Port: 3307
Compressed client/server protocol: false
Databases: blank
Startup script: blank
I'm using plink version 0.61.9264.0
I successfully connect to host using putty but get the error 1045 in both settings
Settings ssh tunnel
plink exe locations: C:\Programme\PuTTY\plink.exe
SSH Host + Port: myhost port:22
Username: my_ssh_username
Password: my_ssh_password
Private key file: no
Local port: 3306
and
Settings ssh tunnel
plink exe locations: C:\Programme\PuTTY\plink.exe
SSH Host + Port: myhost port:22
Username: my_ssh_username
Password: blank
Private key file: no
Local port: 3306
settings for mysql is next
Settings mysql
Network Typ: SSH Tunnel
Hostname/IP: localhost
Username: my_mysql_username
Password: my_mysql_password
Port: 3307
Compressed client/server protocol: false
Databases: blank
Startup script: blank
I fixed this issue. I find out that I'm running MySQL server on my local machine that use the 3306 port. And the romote MySQL server used this port too. So I restarted my local MySQL server with setting of port is 3307. And it works perfectly! Probably you have the same issue!
Please login to leave a reply, or register at first.