landon kelsey wrote:
I run safe_mysqld out of /usr with ./bin/safe_mysqld &
/var/log/mysqld.log
868 031219 20:52:52 mysqld started
869 Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
870 If you do not want to use transactional InnoDB tables, add a line
871 skip-innodb
872 to the [mysqld] section of init parameters in your my.cnf
873 or my.ini. If you want to use InnoDB tables, add to the [mysqld]
874 section, for example,
875 innodb_data_file_path = ibdata1:10M:autoextend
876 But to get good performance you should adjust for your hardware
877 the InnoDB startup options listed in section 2 at
878 http://www.innodb.com/ibman.html
879 031219 20:52:52 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
^^^^^^^^^ You can use perror to translate the number to text:
perror 13 Error code 13: Permission denied
<snip>
(4) here is what mysql.sock looks like landon (root) /usr/bin [303]>lsa /var/lib/mysql total 20 drwxr-xr-x 4 mysql mysql 4096 Dec 18 23:42 ./ drwxr-xr-x 29 root root 4096 Jul 8 18:31 ../ drwx------ 2 root root 4096 Dec 18 21:21 mysql/ srwxrwxrwx 1 mysql mysql 0 Dec 18 23:42 mysql.sock= drwx------ 2 root root 4096 Dec 18 21:21 test/ -rw-rw---- 1 mysql mysql 156 Dec 18 22:52 xxx.log
Here's why. Your mysql directory, where host.frm lives, is owned by root and only readable by root, but mysqld runs as user mysql. Try (as root)
cd /var/lib/mysql chown -R mysql:mysql .
As you say you've tried messing with host.frm, you might also want to rerun mysql_install_db just in case.
(5) also tried ./bin/safe_mysqld --user=mysql & same result
(6) tried safe_mysqld --debug & couldn't find the mysqld.trace file
(7) mysql doesn't work
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Hope that helps.
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
