MySQL server dies immediately upon startup...

CrazyPilot · 03-21-2005, 02:01 AM

I'm trying to run a MySQL 4.1.10a server in slackware linux... it installed fine and started but when i attempted to restart it, it said this:

Quote:

STOPPING server from pid file /var/lib/mysql/desktop.pid
050321 01:44:32 mysqld ended

I am clueless about what to do, the pid file only exists when the server is running every time i try to start it it instantly kills itself....

I've tried redoing the install once that did nothing.

any help would be useful! thx

im in slackware 10.1 btw

MFC · 03-21-2005, 03:13 AM

I would bet a couple of horses on that your datadir hasn't the correct permissions set..

check permissions for /var/lib/mysql/mysql
I had that problem but then the permissions for the mysql dir in the mysql dir was set to root.
Change it to user mysql (chown -R mysql mysql, do this when you are in /var/lib/mysql)

Check also the error-log in /var/lib/mysql/<host>.err (change <host> to YOUR host)

ginda · 03-22-2005, 07:14 PM

I have come accross this error it i believe it happened once when the system did not shutdown properley, did that happen to your system? and did it do a fsck afterwards?