Re: [gentoo-user] Trouble with mysql

[Michael Sullivan]

On Wed, 2005-08-31 at 22:37 +0100, Tim Igoe wrote:
>
> Michael Sullivan wrote:
> > I am having trouble with /etc/init.d/mysql.  I rebooted my system, and
> > when it finished rebooting I tried to connect to the mysql daemon and
> > failed.  I looked in /var/log/mysql:  There was a file there called
> > mysql.err.  The contents were:
> >
> > 050831 15:47:29  mysqld started
> > 050831 15:47:30 Can't start server: Bind on TCP/IP port: Address already
> > in use
> > 050831 15:47:30 Do you already have another mysqld server running on
> > port: 3306 ?
> > 050831 15:47:30 Aborting
> >
> > 050831 15:47:30 /usr/sbin/mysqld: Shutdown Complete
> >
> > 050831 15:47:30  mysqld ended
> >
>
>
>
> check the output of ps aux
> look for mysqld processes in the list - if it is running then try
> killing the mysqld processes or restarting the machine
>
> >
> > I tried netstat | grep '3306':
> >
> > bullet mysql # netstat | grep '3306'
> > bullet mysql #
>
> netstat -n | grep 3306
>
> or
>
> netstat | grep mysql
>
> might be better
>
> >
> > The output was blank, so I assume that port 3306 is NOT in use.  Any
> > ideas?
> >
>
> Do you have something else that could be using the port - a rootkit or
> someone else running a service on the box?


I did ps aux | grep 'mysqld' and got a listing of several mysqld
processes.  I killed each one using kill -9 and then rebooted the
machine.  Once it was fully rebooted I issued another ps aux | grep
'mysqld'.  Here is the output:

bullet ~ # ps aux | grep 'mysqld'
root      8115  0.0  1.5   2216   948 ?        Ss   11:50
0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/mysql/my.cnf
mysql     8151  0.2  3.9  38728  2416 ?        S    11:50
0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306
--socket=/var/run/mysqld/mysqld.sock
mysql     8153  0.0  3.9  38728  2420 ?        S    11:50
0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306
--socket=/var/run/mysqld/mysqld.sock
mysql     8154  0.0  3.9  38728  2420 ?        S    11:50
0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306
--socket=/var/run/mysqld/mysqld.sock
mysql     8155  0.0  3.9  38728  2420 ?        S    11:50
0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306
--socket=/var/run/mysqld/mysqld.sock
root      8848  0.0  0.8   1448   492 pts/0    S+   11:51   0:00 grep
mysqld
bullet ~ #

I have no idea why so many of them are being started.  How do I stop my
system from starting more than one mysql daemon?

-- 
gentoo-user@g.o mailing list