Hi Singh,
I thought that it would be the privilege database. Nice to hear things are
sorted. ;-)
Perhaps you should use the time to explore how the privilege datbase is
working ;-). It certainly was a interesting experience for me. There are some
good articles at www.devshed.com / something "s
Thanks you Nils .
I truly appreciate how helpful you have been !! I have now got the
error sorted out now.
I re-installed MySQL on my Mac OS Jaguar 3 times. Finally the third
time I got it to run. Somehow I had corrupted my User.MYI file
I did have to delete the /usr/loca
If You install Mysql from .dmg file it doesn't install mysql
databases (grant tables, etc.)
I think You have a permission problem so open a terminal and type
su
this command allows You to be root then
chown -R mysql.mysql data(data owner must be mysql)
chmod -R 577 data (allows everyone to wr
Hi Sigh,
I just double and tripple read the threat once more.
>>Installing all prepared tables
>>./bin/mysqld: Can't change dir to '/usr/local/mysql/./data/' (Errcode:
>>13)
This tells me that your user account you are currently logged in with
(username) does not have rights to write to /usr/
Hi Singh,
I followed the threat carefully, and the more I read the more I believe we are
looking in the wrong place.
I believe that this is an OS Issue. Uninstall mysql once more. Take whichever
install method you are most comfortable with (but stick to it :-). check the
datadir and used linux
Is there an mysql directory in /usr/local/mysql/data?
[psg:/usr/local/mysql] psgarcha% sudo ls data
127.0.0.1.errib_logfile1
psg.local..err
ShwetaParekh-Computer.local..err ibdata1
psg.local..err.save
ShwetaParekh-C
Pushpinder Singh Garcha <[EMAIL PROTECTED]> wrote:
>
> 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.
>
Repair tables using myisamchk:
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)
Subject: Re: mysql ended error
I have tried to re-initialize MySQL on Mac OS X Jaguar using :
1. sudo rm -rf /usr/local/mysql/data/*
2. sudo hostname 127.0.0.1
3. cd /usr/local/mysql
4. sudo ./scripts/mysql_install_db
5. sudo chown -R
[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
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 erro
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 &
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
Pushpinder Singh Garcha wrote:
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 Fa
15 matches
Mail list logo
