Your grant tables are either corrupted or damaged. Error 145 indicates this.
-----Original Message-----
From: Pushpinder Singh Garcha [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 9:43 AM
To: Nils Valentin
Cc: [EMAIL PROTECTED]
Subject: Re: mysql ended error
Thanks Nils,
I had been having an terrible experience starting up MySQL. I used to
get this error Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
I have tried the following:
1. Manually start the server using sudo ./bin/mysqld_safe &
the result was :
[psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases
from /usr/local/mysql/data
030623 10:12:40 mysqld ended
[1] Done sudo ./bin/mysqld_safe
[psg:/usr/local/mysql] psgarcha%
------------------------------------------------------------------------
-----------------
2. Next I tried to reinitialize the MySQL using the intructions given
on www.entropy.ch , but even that did not help.
My error log file has this in it :
030623 10:10:48 mysqld started
030623 10:10:50 InnoDB: Started
030623 10:10:50 Fatal error: Can't open privilege tables: Can't open
file: 'user.MYI'. (errno: 145)
030623 10:10:50 Aborting
030623 10:10:50 InnoDB: Starting shutdown...
030623 10:10:52 InnoDB: Shutdown completed 030623 10:10:52
/usr/local/mysql-standard-4.0.13-apple-darwin6.4-powerpc/bin/mysqld:
Shutdown Complete
030623 10:10:52 mysqld ended
------------------------------------------------------------------------
-----------------
3. At last I tried to REINSTALL MySQL from the scratch. I used the
"update" instructions. But there is still NO CHANGE. I get the same
error.
03[psg:/usr/local/mysql] psgarcha% 030623 10:12:40 mysqld ended
------------------------------------------------------------------------
-----------------
Please help me.. I am going crazy !!
Thank you again.
--Pushpinder
On Friday, June 20, 2003, at 08:55 PM, Nils Valentin wrote:
> 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]
