RE: mysql.sock

["Lawrence, Michael" <MLawrence () soroc com>]

I have tried starting mysql using safe_mysqld. It fails to start. I checked
the error log in /var/lib/mysql and found that there was an error 2
(permission problem) and it was unable to locate hosts.frm in
/var/lib/mysql/mysql/. Checked  the permissions and ownership, and
everything for mysql is owned by the user mysql and that user has the
read/write access. I have even gone as far as setting the permissions to
read/write/exicute through the whole tree to see if that solved the issue.
(Box is not connected to a network currently, so security is a non issue for
the moment.) This has not solved the issue. I am still getting the same two
errors. I have even tried reinstalling the main databases using
mysql_install_db. This has not worked. Any ideas?
Mike

-----Original Message-----
From: Jeff Leveille [mailto:JLeveille () SunJournal com]
Sent: Wednesday, March 10, 2004 4:49 PM
To: security-basics () securityfocus com
Cc: Lawrence, Michael
Subject: RE: mysql.sock




> Am Di, den 09.03.2004 schrieb Lawrence, Michael um 21:31:
> > I have a fresh install of Slackware 9.1. Installed Mysql with the install
of
> > the OS. When attempting to start mysqld, I receive an error stating it
can
> > not connect to /var/lib/mysql/mysql.sock. When I searched for mysql.sock,
it
> > is not on the system. How do I go about creating mysql.sock?
> >
> > Mike
>
> the mysqld _service_ is not running. try to start that service.
> i don't exactly know how this is done w/ slackware but probably like this:
>
> % /etc/rc.d/init.d/mysqld start
>
> for starting mysqld at boot add a symlink into /etc/init.d/rc.d/rcX.d, that

> points to the mysqld-startscript mentioned above
>
> % cd /etc/init.d/rc.d/rcX.d
> % ln -s ../init.d/mysqld SYYmysqld
>
> where X is the runlevel you want mysql to be started automatically and YY
is a 
> number that indicates between wich other startscripts in the current
runlevel-
> configuration the mysqld should be started, e.g. S99mysqld...
>
> hth.

Slackware uses scripts in /etc/rc.d

To start mysql run /etc/rc.d/rc.mysqld start

If its set to start at boot it will have execute permissions, if not use: 
chmod +x /etc/rc.mysqld to enable it.

Also check if the databases exist in /var/lib/mysql/mysql if not run
/usr/bin/mysql_install_db then ensure mysql has ownership of all the files
in /var/lib/mysql
chown -R mysql /var/lib/mysql
chgrp -R mysql /var/lib/mysql

Start up mysql and you should be good to go.
This e-mail is a private communication addressed to the intended recipient
and no one else.  The private and privileged nature of this e-mail is not
waived by accidental delivery to the wrong person. If you are not the
intended recipient, please delete this message immediately and do not keep
any copies.  Thank you.

---------------------------------------------------------------------------
Ethical Hacking at the InfoSec Institute. Mention this ad and get $545 off 
any course! All of our class sizes are guaranteed to be 10 students or less 
to facilitate one-on-one interaction with one of our expert instructors. 
Attend a course taught by an expert instructor with years of in-the-field 
pen testing experience in our state of the art hacking lab. Master the skills 
of an Ethical Hacker to better assess the security of your organization. 
Visit us at: 
http://www.infosecinstitute.com/courses/ethical_hacking_training.html
----------------------------------------------------------------------------