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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
