OK
Now open the terminal and type:
cd /usr/local/mysql/
./scripts/mysql_install_db
and restart mysql.
Santino Cusimano
At 14:34 -0400 22-07-2005, Andy Hilton wrote:
This would appear to be the relevant stuff - the err file was in the
mysql/data directory....
050722 14:23:32 mysqld started
050722 14:23:32 [Warning] Setting lower_case_table_names=2 because file
system for /usr/local/mysql/data/ is case insensitive
050722 14:23:33 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...
050722 14:23:33 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
050722 14:23:33 InnoDB: Flushing modified pages from the buffer pool...
050722 14:23:33 InnoDB: Started; log sequence number 0 43634
050722 14:23:33 [ERROR] Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
050722 14:23:33 mysqld ended
Andy
On 7/22/05 2:09 PM, "Michael Stassen" <[EMAIL PROTECTED]> wrote:
Don't assume. Mysql keeps its data, including ibdata1, in the
data directory.
In your case, that's the default location, /usr/local/mysql/data/. The
server, mysqld, runs as user mysql (by default), so the mysql user must have
access to the data directory. You run the installer as root,
however, so your
data directory is probably owned by root, not mysql. You need to fix that.
Do this:
Open Terminal
In Terminal, enter
> cd /usr/local/mysql/
sudo chown -R mysql:mysql data
That will change ownership of the data directory and its contents
to the mysql
user, which should enable mysqld to start. You can start mysqld from the
command line in terminal like this:
cd /usr/local/mysql/
sudo -v
sudo bin/mysqld_safe &
or you can use the preferences pane if you installed it.
If mysqld still fails to start, post the contents of
/usr/local/mysql/hostname.err ("hostname" will be your Mac's name) in your
next message.
References:
<http://dev.mysql.com/doc/mysql/en/default-privileges.html>
<http://dev.mysql.com/doc/mysql/en/grant.html>
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]