Hi folks,
Been doing a lot of noodlin' and googlin' yesterday and today, and thought I found the problem... but alas!
To recap:
I just installed MySQL 5 on a freshly updated FC3 box. I initially was getting this error:
[EMAIL PROTECTED] ~] /usr/bin/mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/mysqld_safe: line 302: /var/lib/mysql/mybox.err: Permission denied /usr/bin/mysqld_safe: line 308: /var/lib/mysql/mybox.err: Permission denied STOPPING server from pid file /var/lib/mysql/mybox.pid tee: /var/lib/mysql/mybox.err: Permission denied 050202 09:21:36 mysqld ended tee: /var/lib/mysql/mybox.err: Permission denied
and this one:
[EMAIL PROTECTED] ~] mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[EMAIL PROTECTED] ~]
Then I found the notes about selinux interferring with mysql starting up at http://forums.mysql.com/read.php?11,7164,7164
I tried setenforce 0 but I'm still getting the same errors.
Permissions are:
[EMAIL PROTECTED] /var/lib/mysql] I AM ROOT: ls -al total 20572 drwxr-xr-x 4 mysql root 4096 Feb 2 08:30 . drwxr-xr-x 35 root root 4096 Feb 1 13:45 .. -rw-rw---- 1 mysql root 1844 Feb 2 08:30 mybox.err -rw-rw---- 1 mysql mysql 10485760 Feb 2 08:30 ibdata1 -rw-rw---- 1 mysql mysql 5242880 Feb 2 08:30 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Feb 2 08:30 ib_logfile1 drwx--x--x 2 mysql root 4096 Feb 1 13:45 mysql drwxr-xr-x 2 mysql root 4096 Feb 1 13:45 test [EMAIL PROTECTED] /var/lib/mysql]
And the contents of the err file:
[EMAIL PROTECTED] /var/lib/mysql] tail mybox.err
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
050202 8:30:51 InnoDB: Started; log sequence number 0 0
050202 8:30:51 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
050202 08:30:51 mysqld ended
I'm stuck. Suggestions?
Whil
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]