MySQL starts and ends immediately

[dogbody2000]

It starts up and shuts back down straight away
I'm trying to start it using safe_mysqld

The log says:
mysqld started
/usr/libexec/mysqld: Can't find file: './mysqld/host.frm' (errno: 13)
mysqld ended

The file it's looking for (host.frm) is in the /var/lib/mysql/mysql directory.

And the my.cnf file looks like this
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib/mysql

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Does anyone know how to fix this?

[tijger]

hi dogbody,

i had something similiar with mysql.sock.
you could make a symbolic link to the right file in mysqld.
something like:
ln -s /var/lib/mysql/mysql/host.frm host.frm

hope it helps you

greetings, tijger

[[deleted]]

"you could make a symbolic link to the right file in mysqld. "

or edit the config to point to the correct files ofcourse 🙂

Is this an existing installation that exploded, or is it a fresh installation that refuses to start?

[tijger]

yeah, editing the config could help, but it was not the solution for me with the mysql.sock problem...

greetings, tijger

[[deleted]]

It could have been, because the location of the mysql.sock file is also in the config files, both of mysql and PHP... 🙂

[dogbody2000]

It's a brand new install. Thanks guys, I'll let you know how it goes.