Access denied sql error 1045
| User, date | Message |
|---|---|
|
Written by klaus66
2 years ago Category: Creating a connection 6 posts since Mon, 15 Aug 11 |
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 |
|
Written by ansgar
2 years ago 3952 posts since Fri, 07 Apr 06 |
> Local port: blank or 0 Sounds wrong - please try 3307 for the SSH local port, and 3306 on the first tab. |
|
Written by klaus66
2 years ago 6 posts since Mon, 15 Aug 11 |
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. |
|
Written by zverushka
2 years ago 2 posts since Wed, 17 Aug 11 |
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 |
|
Written by klaus66
2 years ago 6 posts since Mon, 15 Aug 11 |
yes but i have no error when I connect to my mysql monitor: #root mysql -uUSERNAME -p DATABASE I work with debian. |
|
Written by zverushka
2 years ago 2 posts since Wed, 17 Aug 11 |
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! |
|
Written by klaus66
2 years ago 6 posts since Mon, 15 Aug 11 |
Excellent, that was it. Thanks |
|
Written by klaus66
2 years ago 6 posts since Mon, 15 Aug 11 |
One question: In the settings for Local Port I set now 3307 I hope that is right because 3306 works, too. |
|
Written by klaus66
2 years ago 6 posts since Mon, 15 Aug 11 |
Ah ok I think wrong. I must set it to a free port or to 3306 and then I can start both sessions. |
|
Please login to leave a reply, or register at first. |