Mysql connection problem

Report · Jun 27, 2006

Surprise, surprise! As I started phpmyadmin I got the error message
(#2003): "Can't connect to MySQL server on 'localhost' (10061)". In the
administration panel (xp, sp2) I looked for the mysql service which
didn't run. So I tried to start the service manually and got an error
1067: "The service could not be started".

I have absolutely no idea why that happened. Phpmyadmin and mysql are
running for at least one year without any problem. What could I do?

(phpMyAdmin 2.6.0-pl3, mysql server 4.1, windows xp pro, sp2).

Regards
Carl

Report · Jun 28, 2006

Well, I've found the following errors in the windows administation panel:

1) path\MySQL\MySQL Server 4.1\bin\mysqld-nt: Can't find file:
'host.MYI' (errno: 2)

2) Fatal error: Can't open privilege tables: File '.\mysql\host.MYD' not
found (Errcode: 2)

What can I do?

Regards
Carl

Report · Jun 28, 2006

Would be nice if someone had an idea :)

I've tried to run Mysql server instance configuration, but in vain.
The result:

prepare configuration - ok
write configuration file - ok
restart service - no

The service could not be started. Error: 0

Desparately - remove and install new?

Carl

Report · Jun 28, 2006

carl wrote:
> Would be nice if someone had an idea :)

host.MYI is an index file in the main mysql database.
host.MYD is the relatated data file in the main mysql database.

It looks as though your main privileges table is corrupted. You can
attempt to repair it with myisamchk:

http://dev.mysql.com/doc/refman/4.1/en/myisamchk.html

If that fails, try using mysqldump to back up your data, and reinstall.

http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

Report · Jun 28, 2006

The myisamchk failed, so I reinstalled and followed the steps you've
described in "PHP for DW 8". That worked great, so everything is ok.
Thank you!

Carl

Report · Jun 28, 2006

carl wrote:
> The myisamchk failed, so I reinstalled and followed the steps you've
> described in "PHP for DW 8". That worked great, so everything is ok.
> Thank you!

Pity that you couldn't recover the original mysql table, but I'm glad
everything worked out in the end.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/