mysql erros

[sak]

Why do i get this error when i try to start mysql and type this mysql -u admin -p
Then I enter password and hit enter and then this happens.

ERROR 2003: Can't connect to MySQL server on 'localhost' (10061

see attached file for screen shot. might have to zoom into it

[CompGeek01]

Have you installed mysql server and made sure it's running? What else have you done?

[sak]

I have it running on windows.
Apache 2
php 5
mysql 4.0.21

all installed php works because phpinfo() displays configuration page.
Just mysql giving problems.

I started mysql by running net start mysql, respone i get is positive i.e mysql service was started succesfully.

[Baddog]

Solution for WINXP !!!

The files are in the wrong place, at least with my example.
Had an old version of MYSQL.

Instruction below.(NZ)
================================================== =====================

I had this problem, and this what helped me.....

I have Winxp.....

I removed the previous service, because I had an earlier version....

/bin/mysqld-nt /remove

Then I installed the service


/bin/mysqld-nt /install

Then I edited the my.ini file, by opening winMysqladmin

/bin/winmysqladmin
That command having opened the program...then you should

then select 4th tab, which is the my.ini file

You then edit the file to reflect where you had the files of MYSQL...

as the MY.ini said I had it under c:\mysql ....and I had it under
another folder altogeather....

For simplicity sake, I just copied the files from my current folder to
the specified by my.ini

This got me the access I wanted....

Very happy...

Hope this helps....

Regards Justin(James)HORT
From New Zealand, Palmyhttp://www.faqts.com/knowledge_base/view.phtml/aid/20068

[sak]

Thanks for your feedback.

I stopped and started the service successfully but still i get same error when i want to access it.

also i looked at 4th tab, below i have pastet it , see if you think it's correct.


#This File was made using the WinMySQLAdmin 1.4 Tool
#9/25/2004 10:33:42 AM

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql/mysql-4.0.21-win
#bind-address=217.137.90.47
datadir=C:/mysql/mysql-4.0.21-win/Data
#language=C:/mysql/mysql-4.0.21-win/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/mysql-4.0.21-win/bin/mysqld-nt.exe
user=admin
password=sak1