Re: mysql ended error

[Pushpinder Singh Garcha]

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
>