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 write/read/list data) Then: ./scripts/mysql_install_db --force check again data
I hope this solve your problem.
Santino
At 13:43 -0400 23-06-2003, Pushpinder Singh Garcha wrote:
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 &
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
