mysql.sock Gone?

Keyser Sose · 12-05-2004, 07:22 PM

It seems in /var/run/mysql/mysql.sock is gone, simply after a reboot??

I have tried commands like

su mysql
mysql_install_db
mysqld_safe &

To try and start it to get my mysql.sock back, and also rebooting....

I currently run Slackware 10, will a reinstall be necessary?

Thanks.

Tinkster · 12-05-2004, 07:26 PM

For all I know that file gets created each time mysql
starts? Not that I really use MySQL, mind you. Is your
/etc/rc.d.rc.mysql executable?

Cheers,
Tink

P.S.: "The usual suspect?" :)

Keyser Sose · 12-05-2004, 07:33 PM

Quote:

P.S.: "The usual suspect?"

Yeah

Good movie...

Well I did

Code:

bash-2.05b$ /etc/rc.d/rc.mysqld start
bash-2.05b$ Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/mysql.pid
041205 20:32:28  mysqld ended

But that happened?

What else?

My verison :

mysql Ver 12.22 Distrib 4.0.22, for slackware-linux (i486)

rotvogel · 12-05-2004, 07:49 PM

Is there a logfile in the /var dir somewhere ? Probably /var/lib/mysql/<hostname>.err ? Maybe it will give a clue what is going wrong...

Keyser Sose · 12-05-2004, 07:57 PM

Code:

041205 20:56:55  mysqld started
041205 20:56:55  InnoDB: Started
041205 20:56:55 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
041205 20:56:55 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
041205 20:56:55 Aborting

041205 20:56:55  InnoDB: Starting shutdown...
041205 20:56:57  InnoDB: Shutdown completed
041205 20:56:57 /usr/libexec/mysqld: Shutdown Complete

041205 20:56:57  mysqld ended

rotvogel · 12-05-2004, 08:22 PM

The creation of databases went wrong somehow. They are probably created in a wrong directory since you typed su mysql . Try recreating them using su - mysql .

Keyser Sose · 12-05-2004, 08:26 PM

Quote:

Originally posted by rotvogel
The creation of databases went wrong somehow. They are probably created in a wrong directory since you typed su mysql . Try recreating them using su - mysql .

Thanks mate!
mzzls