If this is on a development machine I would suggest completely removing what
you have installed so far, downloading the latest version for your OS, you
should probably stick with the rpm and or binary, and reinstall MySQL.
-----Original Message-----
From: Pushpinder Singh Garcha [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 9:49 AM
To: Victor Pendleton
Cc: Nils Valentin; [EMAIL PROTECTED]
Subject: Re: mysql ended error
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
