strange problem with connecting to localhost

[expired user #2772]'s profile image [expired user #2772] posted 17 years ago in Creating a connection Permalink
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
ansgar's profile image ansgar posted 17 years ago Permalink
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
net start mysql
[expired user #2772]'s profile image [expired user #2772] posted 17 years ago Permalink
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?
ansgar's profile image ansgar posted 17 years ago Permalink
Definitely not.

What about checking if your server runs?
[expired user #2772]'s profile image [expired user #2772] posted 17 years ago Permalink
i am not connected to a server in fact, just want to work with localhost atm
ansgar's profile image ansgar posted 17 years ago Permalink
Huh? With "server" I didn't mean "another computer". I meant the mysql server software, which should be installed and running on your PC if you want to connect to a "localhost".

So did you check if the mysql server is running on your PC (localhost)?
[expired user #2772]'s profile image [expired user #2772] posted 17 years ago Permalink
How can i check that, including with instantrails i got a program which starts the mysql server, but it doesnt change anything when i got i started
ansgar's profile image ansgar posted 17 years ago Permalink
Hmm I guess it does change something: You should get another error message in HeidiSQL than the one you wrote above, do you?

Please login to leave a reply, or register at first.