Mysql.sock Problem - Printable Version +- ispCP - Board - Support (http://www.isp-control.net/forum) +-- Forum: ispCP Omega Support Area (/forum-30.html) +--- Forum: Update/Upgrade (/forum-44.html) +--- Thread: Mysql.sock Problem (/thread-11023.html) |
Mysql.sock Problem - theprincy - 06-21-2010 04:49 PM I have this problem. Connection failed: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock (2) torino:~# /etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! torino:~# mysqld 100621 8:19:10 InnoDB: Started; log sequence number 0 421736 100621 8:19:10 [Note] mysqld: ready for connections. Version: '5.0.51a-24+lenny3-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian) syslog Code: Jun 21 08:30:34 torino /etc/init.d/mysql[2575]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in torino:/var/run/mysqld# ls -asl total 12 4 drwxrwxrwx 2 mysql mysql 4096 Jun 21 08:31 . 4 drwxr-xr-x 12 root root 4096 Jun 21 08:27 .. 4 -rw-rw---- 1 mysql mysql 5 Jun 21 08:31 mysqld.pid 0 srwxrwxrwx 1 mysql mysql 0 Jun 21 08:31 mysqld.sock torino:/var/run/# ...... 4 drwxrwxrwx 2 mysql mysql 4096 Jun 21 08:31 mysqld .......... how can I solve? RE: Mysql.sock Problem - BeNe - 06-21-2010 05:00 PM You did an Debian Upgrade or what exactly ? And this is YOUR config ? Code: /etc/mysql/debian.cnf Greez BeNe RE: Mysql.sock Problem - theprincy - 06-21-2010 05:08 PM (06-21-2010 05:00 PM)BeNe Wrote: You did an Debian Upgrade or what exactly ? is there was an upgrade of debian [quote]And this is YOUR config ? Code: /etc/mysql/debian.cnf host = localhost user = debian-sys-maint password = socket = /var/run/mysqld/mysqld.sock [mysql_upgrade] user = debian-sys-maint password = socket = /var/run/mysqld/mysqld.sock basedir = /usr if reinstall mysql? RE: Mysql.sock Problem - BeNe - 06-21-2010 05:22 PM This is your complete MySQL-Server config ? A litte bit short or ? The "datadir" and the "port" is missing for example. Please check if there exist a Backup file in the /etc/mysql/ directory. Greez BeNe RE: Mysql.sock Problem - theprincy - 06-21-2010 05:32 PM (06-21-2010 05:22 PM)BeNe Wrote: This is your complete MySQL-Server config ?/etc/mysql/ directory Code: torino:/etc/mysql# ls -asl my.cnf Code: # RE: Mysql.sock Problem - BeNe - 06-21-2010 05:45 PM Fine! This file(my.conf) looks much better than the other (debian.cnf). Try to start the MySQL-Server with the my.conf Greez BeNe RE: Mysql.sock Problem - theprincy - 06-21-2010 05:58 PM (06-21-2010 05:45 PM)BeNe Wrote: Fine! how? I copy the data in my.cnf debian.cnf? /usr/bin/mysql --defaults-file=/etc/mysql/my.cnf ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) |