Shu Xiao <[EMAIL PROTECTED]> writes:
> Hi,
>
> I have problem starting MySQL on Redhat7.1. After installed Redhat7.1 which
> include MySQL rpm installation, I saw the file named mysqld under /etc/init.d .
> I set up symlink to it under /etc/rc3.d and etc/rc5.d. I intended to start
> MySQL while Linux booting. But I failed to start it. Checking
> /var/log/mysql.log
> I saw the follling:
>
> 010813 21:03:15 mysqld started
> 010813 21:03:15 /usr/libexec/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 010813 21:03:15 mysqld ended
>
> And here is the configuration file
>
> /etc/my.cnf
>
> [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
>
> [mysql.server]
> user=mysql
> basedir=/var/lib
>
> [safe_mysqld]
> err-log=/var/log/mysqld.log
> pid-file=/var/run/mysqld/mysqld.pid
>
> I even manual run /etc/init.d/mysqld start and still got the same
> error. Anybody can point out what wrong here? I do see the host.frm
> under /var/lib/mysql/mysql. But why it always failed to find it?
For some reason (probably a manual "mysql_install_db", which is bad
and unnecesarry), the database user don't have write access.
"chown -R mysql.mysql /var/lib/mysql" should solve the problem.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
