[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Problème avec MySQL.



Shams-Eddine Fantar (Scurz) a écrit :
Guillaume a écrit :
Salut

Il n'y a pas de message d'erreur quand tu fais le "/etc/init.d/mysql start" ???

Si,

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!


Sinon tu le fais et juste après, tu regardes dans le fichier: /var/log/syslog


Donc, le syslog :

Sep 27 14:56:58 localhost mysqld[9894]: 060927 14:56:58 InnoDB: Flushing modified pages from the buffer pool... Sep 27 14:56:58 localhost mysqld[9894]: 060927 14:56:58 InnoDB: Started; log sequence number 0 45174 Sep 27 14:56:58 localhost mysqld[9894]: 060927 14:56:58 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/user.frm' Sep 27 14:56:58 localhost mysqld[9894]: 060927 14:56:58 [ERROR] Fatal error: Can't open privilege tables: Incorrect information in file: './mysql/user.frm'Sep 27 14:56:58 localhost mysqld_safe[9904]: ended Sep 27 14:57:05 localhost /etc/init.d/mysql[9967]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Sep 27 14:57:05 localhost /etc/init.d/mysql[9967]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Sep 27 14:57:05 localhost /etc/init.d/mysql[9967]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Sep 27 14:57:05 localhost /etc/init.d/mysql[9967]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sep 27 14:57:05 localhost /etc/init.d/mysql[9967]:


MySQL doit être des choses dans les logs...

A plus
Guillaume




A++


Ok...
Est-ce que tu as fait des modifications à la config de ton MySQL récement ???

Style changer le type de base depuis "je ne sais pas quoi" en innoDB ???

dans le répertoire "/var/lib/mysql", il y a quoi ???

Guillaume

--
Guillaume
E-mail: silencer_<at>_free-4ever_<dot>_net
Blog: http://guillaume.free-4ever.net
----
Site: http://www.free-4ever.net



Reply to: