Salut,
je n'arrive plus a faire tourner mysql , je bloque depuis hier et j'ai parcoucu pas mal de forums sans trouver la bonne reponse qui m'aiderait
/etc/init.d/mysql force-reload
Reloading MySQL database server: mysqld/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!
/etc/init.d/mysql status
MySQL is stopped..
ps aux | grep mysql n'affiche rien en cours
c'est bien le user mysql qui a le dossier /var/run/mysqld/
et il n'y a pas de mysqld.sock
le ping localhost marche bien
PING localhost.sivit.org (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.052 ms
et mon my.cnf
si qqun a une piste a explorer... car la je sais plus ou chercher,
merci !
je n'arrive plus a faire tourner mysql , je bloque depuis hier et j'ai parcoucu pas mal de forums sans trouver la bonne reponse qui m'aiderait
/etc/init.d/mysql force-reload
Reloading MySQL database server: mysqld/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!
/etc/init.d/mysql status
MySQL is stopped..
ps aux | grep mysql n'affiche rien en cours
c'est bien le user mysql qui a le dossier /var/run/mysqld/
et il n'y a pas de mysqld.sock
le ping localhost marche bien
PING localhost.sivit.org (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.052 ms
et mon my.cnf
Code:
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /home/mysql-data
tmpdir = /tmp
language = /usr/share/mysql/french
skip-external-locking
old-password
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
query_cache_limit = 1M
query_cache_size = 16M
long_query_time = 4
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
skip-bdb
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 16M
!includedir /etc/mysql/conf.d/
si qqun a une piste a explorer... car la je sais plus ou chercher,
merci !