Unable to install MySQL on Tiger
Hello,
I am getting the following error when I try to start MySQL on Tiger (10.4). I installed MySQL 4.0.11 from dev.mysql.com and ran the instalattion script. However, trying to use MySQL I get the following error:
jhb:~ jhb$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
jhb:~ jhb$ sudo mysqld_safe
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/jhb.local.pid
050513 15:49:30 mysqld ended
Looking at the logfiles:
050513 15:52:51 mysqld started
050513 15:52:51 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
050513 15:52:51 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...
050513 15:52:51 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050513 15:52:52 InnoDB: Flushing modified pages from the buffer pool...
050513 15:52:52 InnoDB: Started; log sequence number 0 43634
050513 15:52:52 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
050513 15:52:52 mysqld ended
Anyone ran into this problme before ?
I am getting the following error when I try to start MySQL on Tiger (10.4). I installed MySQL 4.0.11 from dev.mysql.com and ran the instalattion script. However, trying to use MySQL I get the following error:
Code:
jhb:~ jhb$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Code:
jhb:~ jhb$ sudo mysqld_safe
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/jhb.local.pid
050513 15:49:30 mysqld ended
Looking at the logfiles:
Code:
050513 15:52:51 mysqld started
050513 15:52:51 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
050513 15:52:51 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...
050513 15:52:51 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050513 15:52:52 InnoDB: Flushing modified pages from the buffer pool...
050513 15:52:52 InnoDB: Started; log sequence number 0 43634
050513 15:52:52 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
050513 15:52:52 mysqld ended
Anyone ran into this problme before ?
Comments
cd /usr/local/mysql/bin
./mysql -u root -p
You could try rebooting (sorry - I'm forced to use windows a lot and so it's my 1st answer to EVERYTHING).
The distribution of MySQL I used has a MySQL preference pane (see http://www.serverlogisitics.com ) that has an 'Initialise' button, try installing that and 'initialising' oh, and do another reboot.
At some point I will make notes of what order to do things in to get MySQL running but in the meantime I'll probably do the things above in a random order until something works.
good luck.