Skip to main content
N
Newsgroup_User
Inspiring
June 27, 2006
Question

Mysql connection problem

  • June 27, 2006
  • 5 replies
  • 347 views
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
This topic has been closed for replies.

5 replies

N
Newsgroup_UserAuthor
Inspiring
June 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/
N
Newsgroup_UserAuthor
Inspiring
June 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
N
Newsgroup_UserAuthor
Inspiring
June 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/
N
Newsgroup_UserAuthor
Inspiring
June 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
N
Newsgroup_UserAuthor
Inspiring
June 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
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices