Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
wt does it mean? i can't start mysql service
Posted by: chanhoktai (---.onebb.com)
Date: February 26, 2007 12:20AM

i'm using wamp server 5.1.7.0



070224 9:51:55 InnoDB: Starting shutdown...
070224 9:51:58 InnoDB: Shutdown completed; log sequence number 0 1863402
070224 9:51:58 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

070224 9:54:03 InnoDB: Started; log sequence number 0 1863402
070224 9:54:03 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)
070224 10:11:04 InnoDB: Started; log sequence number 0 1863402
070224 10:11:04 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)
070224 10:11:07 InnoDB: Started; log sequence number 0 1863402
070224 10:11:07 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)
070224 20:44:38 InnoDB: Started; log sequence number 0 1863402
070224 20:44:38 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)
070225 9:35:55 InnoDB: Started; log sequence number 0 1863402
070225 9:35:55 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)
070225 12:33:13 InnoDB: Started; log sequence number 0 1863402
070225 12:33:13 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)
070225 12:33:22 InnoDB: Started; log sequence number 0 1863402
070225 12:33:22 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)
070225 12:33:46 InnoDB: Started; log sequence number 0 1863402
070225 12:33:46 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)
070226 7:09:33 InnoDB: Started; log sequence number 0 1863402
070226 7:09:33 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)
070226 7:10:01 InnoDB: Started; log sequence number 0 1863402
070226 7:10:01 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)

Options: Reply•Quote
Re: wt does it mean? i can't start mysql service
Posted by: chanhoktai (---.onebb.com)
Date: February 26, 2007 12:34AM

ok... its weak...

after I created an empty file called "host.MYD" under
"C:\wamp\mysql\data\mysql", 1 problem gone, some other show up.
but i can start and use mysql service "normally" (i havent ckeck it)

see the log

070226 7:25:29 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)
070226 7:26:14 InnoDB: Started; log sequence number 0 1863402
070226 7:26:14 [Warning] Can't open and lock time zone table: File '.\mysql\time_zone_leap_second.MYD' not found (Errcode: 2) trying to live without them
070226 7:26:14 [ERROR] Can't open the mysql.func table. Please run the mysql_install_db script to create it.
070226 7:26:14 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)

i met this problem sometimes, but i never know "how" i solved it,
and when was the file - "host.MYD" deleted
could anyone tell me plz??



Post Edited (02-26-07 00:37)

Options: Reply•Quote
Re: wt does it mean? i can't start mysql service
Posted by: chanhoktai (---.onebb.com)
Date: February 26, 2007 12:48AM

after that, in phpmyadmin

#29 - File '.\mysql\tables_priv.MYD' not found (Errcode: 2)

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login