Somehow the Index of the mysql.user table is crashed. mysql is a database within the MYSQL RDBMS that stores the user accounts, passwords, user rights (privileges).
And somehow you managed to mess up the most important table. There are 6 tables within the privilege system (mysql database) user host db tables_priv columns_priv func The table user contains the username, hostname and the password etc... If any of these tables ( but especially the user table) are messed up than MySQL doesnt startup and even if it would you could not login as the user table is unreadable at present. The quick way is to reinstall MySQL. You could try to copy the whole folder were the privilege database "mysql" is stored from another machine (if you have one). Best regards Nils Valentin Tokyo/Japan 2003年 6月 21日 土曜日 04:25、Pushpinder Singh Garcha さんは書きました: > hello all, > > i hve been getting the 'mysql ended' error for over a wek now.when i > look into the log file this is what I get > > This is from the error logs > > 030619 17:09:04 mysqld ended > > 030620 13:14:06 mysqld started > 030620 13:14:09 InnoDB: Started > 030620 13:14:09 Fatal error: Can't open privilege tables: Can't open > file: 'user.MYI'. (errno: 145) > 030620 13:14:09 Aborting > > 030620 13:14:09 InnoDB: Starting shutdown... > 030620 13:14:11 InnoDB: Shutdown completed > 030620 13:14:11 > /usr/local/mysql-standard-4.0.12-apple-darwin6.4-powerpc/bin/mysqld: > Shutdown Complete > > 030620 13:14:11 mysqld ended > > > Please offer some insight into what migh tbe going on. I have tried to > re-initialize the DB , but Nothing chnaged! > > Thanks > -Pushpinder -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
