[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 &
