problems sarting MySQL server

[10127439]

hi,

i'm new to mysql and i've installed it on a Win XP environment. when i run winmysqladmin i get the green traffic light symbol. shortly after that (about 2 seconds later) the light turns red. when i try to reconnent the same thing happens: green then red.
can anybody give me any hints on what i should do to keep the connection alive?

 

[QatQat]

Did you succesfully install mysqld as a service?

after installing you have to go to the c:\mysql\bin dir and
run

mysqld-nt --install


when you restart your machine mysql should be already started.

Id you have performed that, there are a few othre things that could prevent mysql from starting correctly.

Have you got a firewall installed on your windoz box?
If so create appropriate rule for mysql and port 3306.

Winmysqladmin is just an interface and by no mean part of mysql server so you don't have to use it. On top of it does not give you detaild errors.You can get the same information about mysql server variables at DOS prompt and much more.
A common mistake is to set user and password for mysql server in WinMySQLAdmin 'my.ini' page. Those values refer only to a windoz user that will start the service at start up. They are not credentials for mysql.

Start mysql at DOS prompt and read the error message mysqld gives you

at DOS prompt

net start mysql
This will only work after you have installed mysqld as a service.
If you have't installed as a service just run
c:\mysql\bin\mysqld-nt.exe

If it fails please post the error message.



Bye


Qatqat

Life is what happens when you are making other plans.

 

[rjbalicki]

I've gotten this same error and here it is:

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.

What happens is, it runs or appears to, then it comes back to a prompt. Mysqld is not running in the process list in task manager.

I'm running an NT workstation behind a firewall on another machine.

Any suggestions?

 

[rjbalicki]

Ya know, I started mysqld-nt with the --enable-named-pipe parameter and everything appears to be normal now.

 

[Chackt]

I am having precisely the same problem. As an error i can just comment that i didn't enter any username / password after the installation of mysql, because of i heard that if you dont put anything, it just creates root as username and a blank password.

Hmmm... which win user/group does mysql use to start the service? hm... what can be failing in my side? i have xp firewall but totally disabled at the moment. I don't know what more to try. thanks.

 

[Chackt]

Btw, it only differs in that my traffic lights on systry didnt get green never. Neither after installation.