MySQL error message, 2003, on win xp home edition

[sanjdhiman]

dear all,

I am currently trying to use mySQL for a project but cannot get it installed, well working at all. Im using it in conjunction with php and apache. those two programs have been ok to install. the following is a description of wat im tryin to install mySQL on

Im installing it on windows xp home edition on my laptop. I am having trouble with starting it up, i install it then run the command, mysqld at dos prompt i even try the alternative mysqld -opt but no luck (my processor is an athlon xp 1400+ mobile)

i get the following error message when i run the mysql show to find the status of mySQL

ERROR 2003: Cant connect to mySQL server on 'localhost' (10061)

I dont know how to fix this at all??? i have no idea as to where to look when fixing such a problem with localhost, its pretty daunting task but i hope someone can help me.

Thank you in advance for your help

Kind regards

Sanj

PS. I have apache running in standard default fashion as a service
and php is not currently connected yet!

thanks again

sanj

 

[sleipnir214]

When you start MySQL from the command line, do you get another ready prompt? Then you issue the mysql command? Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[sanjdhiman]

Apologies first for cross posting, was not sure which forum at first to give this question to. Sorry.

Regarding your question,
when for example I type mysqld
I get a long pause
then a C:\ prompt again
no mysql prompt

below is an example of wat i get

c:\mysql\bin\mysqld
BIG PAUSE
c:\mysql\bin
That is all

Does that help

 

[sleipnir214]

After the big pause, when you run task manager, does MySQL appear? Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[sanjdhiman]

no it dont come up under task manager. Could i tell uthat when i try via dos prompt telnet localhost it gives me the following error message too

"Could not open connection to the host, on port 23. No connection could be made because the target mahine actively refused it"

thanks in advance

 

[piti]

first mysql runs on the port 3306 (unless you specified other port)

and second what's in the logs?

 

[sanjdhiman]

Hi there,

Well i havent changed anything i installed the source, i know this is a stupid question but do i have to now install the binary...cos it doesnt say which one to install in the documents for mySQL... cos that could be the problem???

I have not specified any other ports... just defaults nothing has changed

no error logs no file for errors???

regards

sanj

 

[pashadowops]

I have a question for you.

Are you running WinMyAdmin as the MySQL server service manager on your laptop?

I read that you have Apache up and running. That's the web server part but you also need to have a MySQL server service manager up and running in order for MySQL to function on a Windows box. I didn't read anywhere that you had WinMyAdmin running. Just a thought. Hope that helps.

 

[sanjdhiman]

just to let all know i got it working

didnt realsie that in windows xp that i had to use the mysqld-nt --datadir=c:\mysql\data

command
so now it works
thanks for ur help
ta
sanj