Did you run myisamchk on user.MYI as I suggested last week?
Pushpinder Singh Garcha wrote:
> 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]
