Problems logging into local MySQL…

[c64audio]

I have SQLYog set up to connect to two servers: one on the local machine, and one on a remote IP address (through SSH tunnelling).

I've found that when I log into either server on its own, things tend to be fine.

However, if I log into the remote server first, and then try to connect to the local server, access is denied with exactly the same details as worked before. The problem doesn't happen the other way round though.

Once this has happened, MySQL denies access to all local users until the machine is rebooted: if the service is “restarted” from “Services” (Win Xp SP2 control panel), then it complains that there may be another Mysqld service running on the same port.

However, if the Mysql service is restarted after Enterprise has been closed, and Plink has also been closed, then the local server lets you in again without a reboot.

Something weird is going on.

[peterlaursen]

“However, if the Mysql service is restarted after Enterprise has been closed, and Plink has also been closed, then the local server lets you in again without a reboot.”

Sorry, but I don't know what Enterprise and Plink is !?

Undoubtedly thereis something wrong with your local MySQL-installation or maybe another MySQL-client running locally. Has your current MySQL been upgraded from a previous version ? And what version(s) are we talking about ?

[c64audio]

Enterprise = SQLYog Enterprise

PLink.exe = small process started by SQLYog Enterprise

<<< Undoubtedly thereis something wrong with your local MySQL-installation or maybe another MySQL-client running locally. Has your current MySQL been upgraded from a previous version ? And what version(s) are we talking about ? >>>

Doubtedly. There is nothing wrong with the local MySQL installation, and there is no other MySQL Client running locally. Anyway, it's not complaining about another client, it's complaining about another server already open on port 3306 when the service tries to restart. The current version is 4.1.6. Gamma NT, but the same problem was exhibited when I installed 4.0, and then completely uninstalled that version (even Registry entries). Logging into the local server works all the time EXCEPT when SQLYog is logged into another server through SSH tunnelling. Does SQLYog open anything servery on Port 3306? That could conceivably cause a problem if the local server was listening on port 3306. Hey, that gives me an idea…

Chris

[Ritesh]

plink.exe is a small app executed by SQLyog for SSH tunneling.

@c64audio: Are you giving “local port” for SSH connection to be 3306. If yes, then please change it to something else. Your MySQL server and the SSH tunneler are listening to the same port and it will cause errors.

[Author]

Posts