Re: mysql ended error

[Pushpinder Singh Garcha]

Thanks Victor,

What can I do now ?... I do not care about the data because this is  
just on the testing server and the development server is unaffected.  
However I need to have the MySQL Server up and running.

Thanks in advance
--Pushpinder



kindly suggest what shoud be my next course of action.
On Monday, June 23, 2003, at 10:47 AM, Victor Pendleton wrote:

> 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
>>
>