Damn mysql connect error, again !

I have a weird problem with mysql

I have a server running in my house that hosts the net and has apache, php and mysql running on it. I have been having some problems with mysql of late.

This problem I have only happens when I restart the server, has happened twice.

I type in the ip and I get

Code:

 Warning: mysql_connect(): Can't connect to MySQL server
 on 'localhost' (10061) in c:\apache\htdocs\links\functions.php
 on line 14
Could Not Connect To Database 

I try to connect to mysql via command prompt and when I start the service it says its fine. I stop the service and it says it wasn’t started to begin with.

I try from \mysql\bin\ to connect:

Code:

mysql –u root

I get error 2003 Can't connect to MySQL server on 'localhost' (10061)

Can anyone shed some light on this ?!

I have restarted the server twice in 4 weeks, and have since forgotten if I did something to fix it ??? I dunno

No Idea. Maybe try doing a clean install and follow filburt's tutorial.

I did a search on Google and found a similar post somwhere else. The reply that fixed his problem (this was a windows installation though, don't know if you can access the files like this on linux if that's your OS).

If that doesn't work, there were some additional info here

Of course he is. :dead:

None of that worked.

I can install the service, and start it, it then stops on its own after about 5 secs...

I get the error Cannot connect to mysql server on localhost port 10061 when i try mysql -u root in the \mysql\bin directory.

This is fully annoying me no end. i have uninstalled and installed mysql over and over.

I feel the only remedy is to format my server....
any ideas