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 "serverside/MySQL" (sorry page was temporary unavailable when I wrote this). Best regards Nils Valentin Tokyo/Japan 2003年 6月 25日 水曜日 23:20、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 -- --- 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]
