Hi all
yesterday i was using HeidiSQL the first time in connection with ruby on rails to create a database, everything was ok, i could connect to localhost with the username root and no password
today i wanted to continue my work on another PC, but when i wanted to connect to localhost with username "root" and empty password it says: "SQL Error: Can't connect to MySQL server on '127.0.0.1' (10061)" and now there is another strange thing, when i tried it on the PC i worked on yesterday (which is in the same room and connected to the same server) HeidiSQL also couldn't connect to localhost
well i read the sticky already, but it didn't helped me, hopefully you can
greets Dorian
strange problem with connecting to localhost
Well if you say you can connect to localhost, it's quite obvious that you can't do the same when you're on another PC, because "localhost" or 127.0.0.1 is the machine you're at. You have to use the IP address or the hostname of the remote computer in the connection screen.
If you're sure you should be able to connect than check if the mysql service is started by looking into your service panel in windows' control panel. Or simply try to restart the service by firing the commandline
If you're sure you should be able to connect than check if the mysql service is started by looking into your service panel in windows' control panel. Or simply try to restart the service by firing the commandline
net start mysql
Ok i think i got to the roots of the problem, everytime when i install heidisql on a PC the first time when i start it, everything is ok, but when i close it and want to start it a second time this strange error comes, is it possible that heidisql creates a username and connection during the first session?
Please login to leave a reply, or register at first.