Re: Starting Mysql service.. Problem

["Hansel A. Ortiz" <hansel.ortiz@gmail.com>]

the output log i have is this
with 
linux-debian:~# cat /var/log/syslog | grep mysqld


linux-debian:~# cat /var/log/syslog | grep mysqld
Jul  5 10:24:24 linux-debian mysqld_safe[6113]: started
Jul  5 10:24:24 linux-debian mysqld[6117]: 060705 10:24:24 Can't start server : Bind on unix socket: Permission denied
Jul  5 10:24:24 linux-debian mysqld[6117]: 060705 10:24:24 Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
Jul  5 10:24:24 linux-debian mysqld[6117]: 060705 10:24:24 Aborting
Jul  5 10:24:24 linux-debian mysqld[6117]:
Jul  5 10:24:24 linux-debian mysqld[6117]: 060705 10:24:24 /usr/sbin/mysqld: Shutdown Complete
Jul  5 10:24:24 linux-debian mysqld[6117]:
Jul  5 10:24:24 linux-debian mysqld_safe[6119]: ended
Jul  5 10:24:30 linux-debian /etc/init.d/mysql[6184]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul  5 10:24:30 linux-debian /etc/init.d/mysql[6184]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul  5 11:02:32 linux-debian mysqld_safe[7640]: started
Jul  5 11:02:32 linux-debian mysqld[7644]: 060705 11:02:32 /usr/sbin/mysqld: unknown variable 'old_passwords=1'
Jul  5 11:02:32 linux-debian mysqld[7644]:
Jul  5 11:02:32 linux-debian mysqld_safe[7646]: ended
Jul  5 11:02:38 linux-debian /etc/init.d/mysql[7710]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul  5 11:02:38 linux-debian /etc/init.d/mysql[7710]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul  5 11:08:18 linux-debian mysqld_safe[7968]: started
Jul  5 11:08:18 linux-debian mysqld[7972]: 060705 11:08:18 Can't start server : Bind on unix socket: Permission denied
Jul  5 11:08:18 linux-debian mysqld[7972]: 060705 11:08:18 Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
Jul  5 11:08:18 linux-debian mysqld[7972]: 060705 11:08:18 Aborting
Jul  5 11:08:18 linux-debian mysqld[7972]:
Jul  5 11:08:18 linux-debian mysqld[7972]: 060705 11:08:18 /usr/sbin/mysqld: Shutdown Complete
Jul  5 11:08:18 linux-debian mysqld[7972]:
Jul  5 11:08:18 linux-debian mysqld_safe[7974]: ended
Jul  5 11:08:24 linux-debian /etc/init.d/mysql[8049]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul  5 11:08:24 linux-debian /etc/init.d/mysql[8049]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul  5 11:08:48 linux-debian mysqld_safe[8160]: started
Jul  5 11:08:48 linux-debian mysqld[8165]: 060705 11:08:48 Can't start server : Bind on unix socket: Permission denied
Jul  5 11:08:48 linux-debian mysqld[8165]: 060705 11:08:48 Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
Jul  5 11:08:48 linux-debian mysqld[8165]: 060705 11:08:48 Aborting
Jul  5 11:08:48 linux-debian mysqld[8165]:
Jul  5 11:08:48 linux-debian mysqld[8165]: 060705 11:08:48 /usr/sbin/mysqld: Shutdown Complete
Jul  5 11:08:48 linux-debian mysqld[8165]:
Jul  5 11:08:48 linux-debian mysqld_safe[8167]: ended
Jul  5 11:08:54 linux-debian /etc/init.d/mysql[8250]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul  5 11:08:54 linux-debian /etc/init.d/mysql[8250]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul  5 11:09:10 linux-debian mysqld_safe[8345]: started
Jul  5 11:09:10 linux-debian mysqld[8349]: 060705 11:09:10 /usr/sbin/mysqld: unknown variable 'old_passwords=1'
Jul  5 11:09:10 linux-debian mysqld[8349]:
Jul  5 11:09:10 linux-debian mysqld_safe[8351]: ended
Jul  5 11:09:16 linux-debian /etc/init.d/mysql[8416]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul  5 11:09:16 linux-debian /etc/init.d/mysql[8416]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul  5 11:37:40 linux-debian mysqld_safe[9461]: started
Jul  5 11:37:40 linux-debian mysqld[9465]: 060705 11:37:40 /usr/sbin/mysqld: unknown variable 'old_passwords=1'
Jul  5 11:37:40 linux-debian mysqld[9465]:
Jul  5 11:37:40 linux-debian mysqld_safe[9467]: ended
Jul  5 11:37:46 linux-debian /etc/init.d/mysql[9534]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul  5 11:37:46 linux-debian /etc/init.d/mysql[9534]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

On 7/5/06, Conrad Williams <conrad_williams@iprimus.com.au> wrote:

HI,

 

I had a similar problem. Check the logs. In my case, a log file for innodb didn't exist, and was showing up in the syslog.

What's the full syslog records?

try

# cat /var/log/syslog | grep mysqld

and for past errors

# zcat /var/log/syslog.*.gz | grep mysqld

 

 

 

 hi im having problems starting up the service of mysql
im using DEBIAN SARGE
and im installed mysql via apt-get install mysql-server


Starting MySQL database server: mysqld...failed.
        Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

-- 
Hansel A. Ortiz Peralta
Analista de Sistemas
AAA. Dominicana
Proyecto ASDE Zona Oriental

Phone. 809-593-0707 Ext 116
Mobile. 809-977-5169
Flota:   809-702-1599
Dominican Republic

Email hansel.ortiz@gmail.com