Re: mysql ended error

[Pushpinder Singh Garcha]

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/local/mysql/data Dir so that I can get 
rid of the Privilege Tables.

Have a great day!

regards
--Pushpinder






On Monday, June 23, 2003, at 10:55 PM, Nils Valentin wrote:

> 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 account VERY carefully before you install 
> anything.
>
> f.e (rpm) /var/lib/mysql
> f.e. (binary) /usr/local/mysql/data
>
> must be owned by the Linux account which mysqld will be using (in most 
> cases
> the name of the account is also mysql)
>
> do this:
>
> chown -R mysql /var/lib/mysql (for rpm)
> chown -R mysql /usr/local/mysql/data (for binary)
> shell> ls -al
>
> drwx------    2 mysql    mysqlgrp     4096 Jun  9 08:41 mysql
> lrwxrwxrwx    1 mysql    mysqlgrp       15 Mar 19 16:51 mysql.sock ->
> /tmp/mysql.sock
>
> To be 200% sure you can delete the folder
>
> /var/lib/mysql/mysql
> /usr/local/mysql/data/mysql
>
> This will completely remove the folder containing the privilege 
> database
> files.
>
> Next lets see if we have a user account setup for the mysql demon.
>
> do this:
>
> shell> cat /etc/group |grep mysql
>
> mysql:x:500:
>
> shell > cat /etc/passwd |grep mysql
>
> mysql:x:60:2:MySQL database admin:/var/lib/mysql:/bin/false
>
> If this account doesnt exist create it !!
>
> Then try to install it again.
>
> Summary: We checked and setup the useraccount which will be used for 
> mysql.
> We also removed the privilege database once more (just in case) to 
> make a
> clean install.
>
> The privilege database will not be removed even when removing mysql - 
> so
> doesnt matter how often you reinstall it, unless you delete it it wont 
> help
> !!
>
> That should keep your  mysql demon running. There is nothing left 
> anymore -
> except on OS side (user quotes, linux account limitations etc.)
>
> I would be surprised if you dont get this beast into the air ;-)
>
> Let me know the outcome please.
>
> Best regards
>
> Nils Valentin
>
>
>
>
>
> 2003年 6月 24日 火曜日 02:43、Pushpinder Singh Garcha さんは書きました:
>> Is there an mysql directory in /usr/local/mysql/data?
>> [psg:/usr/local/mysql] psgarcha% sudo ls data
>> 127.0.0.1.err                        ib_logfile1
>>    psg.local..err
>> ShwetaParekh-Computer.local..err     ibdata1
>>    psg.local..err.save
>> ShwetaParekh-Computer.local..pid     masterstream
>>    test
>> ib_arch_log_0000000000               mydb
>> ib_logfile0                          mysql
>>
>> Does mysql own /usr/local/mysql/data?
>> Yes
>> [psg:/usr/local/mysql] psgarcha% ls -la
>> total 11288
>> drwxr-xr-x  22 root   wheel      748 Jun 23 11:50 .
>> drwxr-xr-x   6 root   wheel      204 Jun 23 11:50 ..
>> -rw-r--r--   1 root   wheel    19106 May 14 16:50 COPYING
>> -rw-r--r--   1 root   wheel    28003 May 14 16:50 COPYING.LIB
>> -rw-r--r--   1 root   wheel   181571 May 14 16:24 ChangeLog
>> -rw-r--r--   1 root   wheel     6802 May 14 16:50 INSTALL-BINARY
>> -rw-r--r--   1 root   wheel     1937 May 14 16:24 README
>> drwxr-xr-x  46 root   wheel     1564 Jun 23 09:22 bin
>> -rwxr-xr-x   1 root   wheel      773 May 14 17:01 configure
>> drwxr-x---  15 mysql  wheel      510 Jun 23 13:29 data
>> drwxr-xr-x  51 root   wheel     1734 Jun 23 09:22 include
>> drwxr-xr-x   8 root   wheel      272 Jun 23 09:22 lib
>> drwxr-xr-x   3 root   wheel      102 Jun 23 09:22 man
>> -rw-r--r--   1 root   wheel  2893112 May 14 16:48 manual.html
>> -rw-r--r--   1 root   wheel  2514300 May 14 16:48 manual.txt
>> -rw-r--r--   1 root   wheel   115727 May 14 16:48 manual_toc.html
>> drwxr-xr-x   9 root   wheel      306 Jun 23 09:22 mysql-test
>> drwxr-xr-x   3 root   wheel      102 Jun 23 09:22 scripts
>> drwxr-xr-x   3 root   wheel      102 Jun 23 09:22 share
>> drwxr-xr-x  31 root   wheel     1054 Jun 23 09:22 sql-bench
>> drwxr-xr-x  12 root   wheel      408 Jun 23 09:22 support-files
>> drwxr-xr-x  21 root   wheel      714 Jun 23 09:22 tests
>>
>>
>> Does mysql have r/w privileges on /usr/local/mysql/data?
>> Yes
>>
>> [psg:local/mysql/bin] psgarcha% cd /usr/local/mysql/
>> [psg:/usr/local/mysql] psgarcha%
>> [psg:/usr/local/mysql] psgarcha% ./scripts/mysql_install_db --force
>> mkdir: ./data/mysql: Permission denied
>> chmod: ./data/mysql: Permission denied
>> mkdir: ./data/test: Permission denied
>> chmod: ./data/test: Permission denied
>> Preparing db table
>> Preparing host table
>> Preparing user table
>> Preparing func table
>> Preparing tables_priv table
>> Preparing columns_priv table
>> Installing all prepared tables
>> ./bin/mysqld: Can't change dir to '/usr/local/mysql/./data/' (Errcode:
>> 13)
>> 030623 13:27:37  Aborting
>>
>> 030623 13:27:37  ./bin/mysqld: Shutdown Complete
>>
>> Installation of grant tables failed!
>>
>> Examine the logs in ./data for more information.
>> You can also try to start the mysqld daemon with:
>> ./bin/mysqld --skip-grant &
>> You can use the command line tool
>> ./bin/mysql to connect to the mysql
>> database and look at the grant tables:
>>
>> shell> ./bin/mysql -u root mysql
>> mysql> show tables
>>
>> Try 'mysqld --help' if you have problems with paths. Using --log
>> gives you a log in ./data that may be helpful.
>>
>> The latest information about MySQL is available on the web at
>> http://www.mysql.com
>> Please consult the MySQL manual section: 'Problems running
>> mysql_install_db',
>> and the manual section that describes problems on your OS.
>> Another information source is the MySQL email archive.
>> Please check all of the above before mailing us!
>> And if you do mail us, you MUST use the ./bin/mysqlbug script!
>>
>> [psg:/usr/local/mysql] psgarcha% chown -R mysql.mysql data
>> chown: data: Permission denied
>> chown: data: Operation not permitted
>> [psg:/usr/local/mysql] psgarcha% chmod -r 577 data
>> chmod: 577: No such file or directory
>> chmod: data: Operation not permitted
>>
>> [2]    Exit 1                        sudo ./bin/mysqldsafe
>> [psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases
>> from /usr/local/mysql/data
>> 030623 13:29:40  mysqld ended
>>
>>
>> [3]    Done                          sudo ./bin/mysqld_safe
>>
>>
>>
>>
>> Thanks again
>> --Pushpinder
>>
>> On Monday, June 23, 2003, at 01:22 PM, Santino wrote:
>>> ./bin/safemysql &
>
> -- 
> ---
> Valentin Nils
> Internet Technology
>
>  E-Mail: [EMAIL PROTECTED]
>  URL: http://www.knowd.co.jp
>  Personal URL: http://www.knowd.co.jp/staff/nils
>