Hi,
I googled but I don't succeed on using mysql.
The machine: Mac OS X Tiger (10.4.11) on intel, MacPorts 1.600,
mysql5 @5.0.51a_0+server (active)
I've read somewhere that I have to run the following command:
~$ sudo -u mysql mysql_install_db5
But this fails:
Installing MySQL system tables...
080513 22:10:43 [Warning] Setting lower_case_table_names=2 because
file system for /opt/local/var/db/mysql5/ is case insensitive
ERROR: 1347 'mysql.db' is not BASE TABLE
080513 22:10:44 [ERROR] Aborting
080513 22:10:44 [Note] /opt/local/libexec/mysqld: Shutdown complete
Installation of system tables failed!
Examine the logs in /opt/local/var/db/mysql5 for more information.
You can try to start the mysqld daemon with:
/opt/local/libexec/mysqld --skip-grant &
and use the command line tool
/opt/local/lib/mysql5/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /opt/local/lib/mysql5/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /opt/local/var/db/mysql5 that may be helpful.
Looks like permission problems, and the server logs say the same:
080511 19:44:56 mysqld started
080511 19:44:56 [Warning] Setting lower_case_table_names=2 because
file system for /opt/local/var/db/mysql5/ is case
insensitiveInnoDB: Log scan progressed past the checkpoint lsn 0 368
08080511 19:44:56 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the
doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
080511 19:44:57 InnoDB: Starting an apply batch of log records to
the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83
84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
080511 19:44:57 InnoDB: Started; log sequence number 0 43655
080511 19:44:58 [ERROR] /opt/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
080511 19:44:58 [ERROR] /opt/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
080511 19:44:58 [ERROR] Fatal error: Can't open and lock privilege
tables: Can't find file: './mysql/host.frm' (errno: 13)
080511 19:44:58 mysqld ended
the files in /opt/local/var/db/mysql5 are mysql:admin, those in the
subdirectory mysql are root:admin (as well as the host.frm from the
log). How did these get to root:admin?
I started the server with launchctl load -w ...
$ ps -ax | grep mysq
9072 ?? Ss 0:00.01 /opt/local/bin/daemondo --label=mysql5 --
start-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/
mysql5.wrapper start
9159 ?? Ss 0:00.02 /opt/local/bin/daemondo --label=mysql5 --
start-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/
mysql5.wrapper start
So my question is: what have I done wrong installing the mysql5 db?
Which actions can I take to get it running?
Thanks,
Patrick
_______________________________________________
macports-users mailing list
macports-users@lists.macosforge.org
http://lists.macosforge.org/mailman/listinfo/macports-users
