Mysql-server-5.5 impossible à configurer, dans l'impasse

Bonjour à tous,

Donc voilà depuis hier j’ai un gros soucis avec mon serveur Mysql depuis que j’ai supprimer le dossier /tmp qui contenais un fichier impossible à supprimer (je ne sais même pas comment il a été possible de le créer) le fichier était au format xx:xx:xx.csv. enfin bref le seul moyen de le supprimer étais de supprimer le répertoire donc supprimer et recréer. Je reboot mon serveur et impossible de me connecter à mon serveur mysql :

j’ai essayer tout se qui était possible et imaginable pour réparer l’erreur

apt-get purge 'tout les paquets concernant mysql' rm /etc/mysql rm /var/lib/dpkg/info/mysql-*

apparemment c’est la dépendance mysql-server-5.5 qui pose problème le paquet est défectueux et garder en l’état

J’ai tenter une reconfiguration dpkg --configure mysql-server-5.5
Et erreur il ne veut pas de mon mot de passe : "erreur de connexion avec la base de donnée"
J’ai essayer avec un mdp vide il n’en veut pas non plus le service refuse de démarrer
J’ai aussi essayer de modifier /var/lib/dpkg/info/mysql-server-5.5.postrm et de mettre “exit 0” à la fin rien n’y fait…

Je suis dans l’impasse totale et j’ai absolument besoin d’un serveur mysql opérationnel pour demain matin !!!

je suis sous debian 7.4 pour info. J’ai essayer de monter une machine avec un OS clean impossible aussi je ne comprend rien le problème vient de moi ou des packages ?!

Merci d’avance j’ai grand besoin de votre aide !

eh ben je pense que tu as fait toutes les âneries possibles.

Que te donne

Si il y a un /usr/sbin/mysqld, tu le et fais un apt-get -f install

Sinon que donne mysqld lancé seul en ligne de commande?

Bonjour,

Merci pour ta réponse rapide. Par ânerie tu veux dire bêtise ?^^.

ps xa | grep mysql 7049 tty2 S+ 0:00 grep mysql

Donc rien concernant mysql.

/usr/bin/mysql etait présent

J’ai re-re-re-resupprimer le paquet mysql.

Demande de mot de passe je rentre root puis

[code]impossible de changer le mot de passe de l’utilisateur “root” de MySQL

Une erreur c’est produite lors du changement de mot de passe du compte
d’administration. Un mot de passe existait peut-etre déjà ou il n’a pas
été possible de communiquer avec le serveur MySQL.

vous devriez vérifier le mot de passe de ce compte après l’installation
du paquet.

Veuillez consulter le fichier
/usr/share/doc/mysql-server-5.5/README.Debian pour plus d’informations.[/code]

Dans cet état de configuration la commande : service mysql start donne :

Voilà voilà … c’est la m**** ^^.

Supprime et reinstalle mysql :

apt-get remove --purge mysql-server; apt-get install mysql-server

Puis redémarre mysql puis dis-nous les erreurs du syslog :

# /etc/init.d/mysql restart

Puis :

# /etc/dovecot# tail -n 30 /var/log/syslog

Bonjour fluo,

J’avais déjà fais ça.
Je viens de faire :

après réinstallation pareil que se que j’ai posté précédemment : demande de mot de passe puis échec de changement de mot de passe.

Contenu de la fin du fichier /var/log/syslog

[code]tail -n 30 /var/log/syslog

May 15 13:58:21 server-rpi mysqld:
May 15 13:58:21 server-rpi mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
May 15 13:58:35 server-rpi /etc/init.d/mysql[25310]: 0 processes alive and ‘/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping’ resulted in
May 15 13:58:35 server-rpi /etc/init.d/mysql[25310]: #007/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
May 15 13:58:35 server-rpi /etc/init.d/mysql[25310]: error: 'Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)'
May 15 13:58:35 server-rpi /etc/init.d/mysql[25310]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
May 15 13:58:35 server-rpi /etc/init.d/mysql[25310]:
May 15 13:59:07 server-rpi mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [Note] Plugin ‘FEDERATED’ is disabled.
May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 InnoDB: The InnoDB memory heap is disabled
May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 InnoDB: Compressed tables use zlib 1.2.7
May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 InnoDB: Using Linux native AIO
May 15 13:59:08 server-rpi mysqld: #007/usr/sbin/mysqld: Can’t create/write to file ‘/tmp/ibmGSzIe’ (Errcode: 13)
May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 InnoDB: Error: unable to create temporary file; errno: 13
May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [ERROR] Plugin ‘InnoDB’ init function returned error.
May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [ERROR] Unknown/unsupported storage engine: InnoDB
May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [ERROR] Aborting
May 15 13:59:08 server-rpi mysqld:
May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [Note] /usr/sbin/mysqld: Shutdown complete
May 15 13:59:08 server-rpi mysqld:
May 15 13:59:08 server-rpi mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
May 15 13:59:22 server-rpi /etc/init.d/mysql[25873]: 0 processes alive and ‘/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping’ resulted in
May 15 13:59:22 server-rpi /etc/init.d/mysql[25873]: #007/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
May 15 13:59:22 server-rpi /etc/init.d/mysql[25873]: error: 'Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)'
May 15 13:59:22 server-rpi /etc/init.d/mysql[25873]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
May 15 13:59:22 server-rpi /etc/init.d/mysql[25873]:

[/code]

Le fichier : var/run/mysql/mysql.sock existe ?

Il manque des informations dans syslog.

Arrête apache2

/etc/init.d/apache2 stop

Puis arrête mysql. Puis 5 secondes après, démarre mysql (n’utilise pas restart) :

/etc/init.d/mysql stop
/etc/init.d/mysql start

Puis post les logs

tail -n 100 /var/log/syslog

Dis nous aussi si le fichier var/run/mysql/mysql.sock existe.

Voila les nouveaux logs :

May 15 13:58:20 server-rpi mysqld_safe[24744]: May 15 13:58:20 server-rpi mysqld_safe[24744]: 140515 13:58:20 [Note] /usr/sbin/mysqld: Shutdown complete May 15 13:58:20 server-rpi mysqld_safe[24744]: May 15 13:58:21 server-rpi mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql May 15 13:58:21 server-rpi mysqld: 140515 13:58:21 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. May 15 13:58:21 server-rpi mysqld: 140515 13:58:21 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. May 15 13:58:21 server-rpi mysqld: 140515 13:58:21 [Note] Plugin 'FEDERATED' is disabled. May 15 13:58:21 server-rpi mysqld: 140515 13:58:21 InnoDB: The InnoDB memory heap is disabled May 15 13:58:21 server-rpi mysqld: 140515 13:58:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins May 15 13:58:21 server-rpi mysqld: 140515 13:58:21 InnoDB: Compressed tables use zlib 1.2.7 May 15 13:58:21 server-rpi mysqld: 140515 13:58:21 InnoDB: Using Linux native AIO May 15 13:58:21 server-rpi mysqld: #007/usr/sbin/mysqld: Can't create/write to file '/tmp/ibbRK23g' (Errcode: 13) May 15 13:58:21 server-rpi mysqld: 140515 13:58:21 InnoDB: Error: unable to create temporary file; errno: 13 May 15 13:58:21 server-rpi mysqld: 140515 13:58:21 [ERROR] Plugin 'InnoDB' init function returned error. May 15 13:58:21 server-rpi mysqld: 140515 13:58:21 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. May 15 13:58:21 server-rpi mysqld: 140515 13:58:21 [ERROR] Unknown/unsupported storage engine: InnoDB May 15 13:58:21 server-rpi mysqld: 140515 13:58:21 [ERROR] Aborting May 15 13:58:21 server-rpi mysqld: May 15 13:58:21 server-rpi mysqld: 140515 13:58:21 [Note] /usr/sbin/mysqld: Shutdown complete May 15 13:58:21 server-rpi mysqld: May 15 13:58:21 server-rpi mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended May 15 13:58:35 server-rpi /etc/init.d/mysql[25310]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in May 15 13:58:35 server-rpi /etc/init.d/mysql[25310]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed May 15 13:58:35 server-rpi /etc/init.d/mysql[25310]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' May 15 13:58:35 server-rpi /etc/init.d/mysql[25310]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! May 15 13:58:35 server-rpi /etc/init.d/mysql[25310]: May 15 13:59:07 server-rpi mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [Note] Plugin 'FEDERATED' is disabled. May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 InnoDB: The InnoDB memory heap is disabled May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 InnoDB: Compressed tables use zlib 1.2.7 May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 InnoDB: Using Linux native AIO May 15 13:59:08 server-rpi mysqld: #007/usr/sbin/mysqld: Can't create/write to file '/tmp/ibmGSzIe' (Errcode: 13) May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 InnoDB: Error: unable to create temporary file; errno: 13 May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [ERROR] Plugin 'InnoDB' init function returned error. May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [ERROR] Unknown/unsupported storage engine: InnoDB May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [ERROR] Aborting May 15 13:59:08 server-rpi mysqld: May 15 13:59:08 server-rpi mysqld: 140515 13:59:08 [Note] /usr/sbin/mysqld: Shutdown complete May 15 13:59:08 server-rpi mysqld: May 15 13:59:08 server-rpi mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended May 15 13:59:22 server-rpi /etc/init.d/mysql[25873]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in May 15 13:59:22 server-rpi /etc/init.d/mysql[25873]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed May 15 13:59:22 server-rpi /etc/init.d/mysql[25873]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' May 15 13:59:22 server-rpi /etc/init.d/mysql[25873]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! May 15 13:59:22 server-rpi /etc/init.d/mysql[25873]: May 15 13:59:39 server-rpi kernel: [ 5893.263324] usb 1-1: USB disconnect, device number 3 May 15 14:01:51 server-rpi mpt-statusd: detected non-optimal RAID status May 15 14:09:01 server-rpi kernel: [ 6455.268269] type=1400 audit(1400155741.248:52): avc: denied { write } for pid=25966 comm="cron" name="tmp" dev=sda1 ino=262145 scontext=system_u:system_r:crond_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=dir May 15 14:09:01 server-rpi kernel: [ 6455.268372] type=1400 audit(1400155741.248:53): avc: denied { add_name } for pid=25966 comm="cron" name="tmpfXV0KFq" scontext=system_u:system_r:crond_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=dir May 15 14:09:01 server-rpi kernel: [ 6455.268559] type=1400 audit(1400155741.248:54): avc: denied { create } for pid=25966 comm="cron" name="tmpfXV0KFq" scontext=system_u:system_r:crond_t:s0-s0:c0.c1023 tcontext=system_u:object_r:root_t:s0 tclass=file May 15 14:09:01 server-rpi kernel: [ 6455.268791] type=1400 audit(1400155741.248:55): avc: denied { read write open } for pid=25966 comm="cron" name="tmpfXV0KFq" dev=sda1 ino=262148 scontext=system_u:system_r:crond_t:s0-s0:c0.c1023 tcontext=system_u:object_r:root_t:s0 tclass=file May 15 14:09:01 server-rpi kernel: [ 6455.269093] type=1400 audit(1400155741.252:56): avc: denied { remove_name } for pid=25966 comm="cron" name="tmpfXV0KFq" dev=sda1 ino=262148 scontext=system_u:system_r:crond_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=dir May 15 14:09:01 server-rpi kernel: [ 6455.269200] type=1400 audit(1400155741.252:57): avc: denied { unlink } for pid=25966 comm="cron" name="tmpfXV0KFq" dev=sda1 ino=262148 scontext=system_u:system_r:crond_t:s0-s0:c0.c1023 tcontext=system_u:object_r:root_t:s0 tclass=file May 15 14:09:01 server-rpi kernel: [ 6455.269423] type=1400 audit(1400155741.252:58): avc: denied { getattr } for pid=25966 comm="cron" path=2F746D702F746D70665856304B4671202864656C6574656429 dev=sda1 ino=262148 scontext=system_u:system_r:crond_t:s0-s0:c0.c1023 tcontext=system_u:object_r:root_t:s0 tclass=file May 15 14:09:01 server-rpi /USR/SBIN/CRON[25967]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -depth -mindepth 1 -maxdepth 1 -type f -ignore_readdir_race -cmin +$(/usr/lib/php5/maxlifetime) ! -execdir fuser -s {} 2>/dev/null \; -delete) May 15 14:09:39 server-rpi kernel: [ 6493.029121] usb 1-1: new high-speed USB device number 4 using ehci_hcd May 15 14:09:39 server-rpi kernel: [ 6493.576995] usb 1-1: New USB device found, idVendor=0781, idProduct=556b May 15 14:09:39 server-rpi kernel: [ 6493.577000] usb 1-1: New USB device strings: Mfr=1, Product=2, SerialNumber=3 May 15 14:09:39 server-rpi kernel: [ 6493.577003] usb 1-1: Product: Cruzer Edge May 15 14:09:39 server-rpi kernel: [ 6493.577005] usb 1-1: Manufacturer: SanDisk May 15 14:09:39 server-rpi kernel: [ 6493.577006] usb 1-1: SerialNumber: 20053551931644C01351 May 15 14:09:39 server-rpi kernel: [ 6493.580171] scsi5 : usb-storage 1-1:1.0 May 15 14:09:40 server-rpi kernel: [ 6494.590194] scsi 5:0:0:0: Direct-Access SanDisk Cruzer Edge 1.26 PQ: 0 ANSI: 5 May 15 14:09:40 server-rpi kernel: [ 6494.592473] sd 5:0:0:0: Attached scsi generic sg2 type 0 May 15 14:09:40 server-rpi kernel: [ 6494.609698] sd 5:0:0:0: [sdb] 15633408 512-byte logical blocks: (8.00 GB/7.45 GiB) May 15 14:09:40 server-rpi kernel: [ 6494.620339] sd 5:0:0:0: [sdb] Write Protect is off May 15 14:09:40 server-rpi kernel: [ 6494.620344] sd 5:0:0:0: [sdb] Mode Sense: 43 00 00 00 May 15 14:09:40 server-rpi kernel: [ 6494.630414] sd 5:0:0:0: [sdb] Write cache: disabled, read cache: enabled, doesn't support DPO or FUA May 15 14:09:40 server-rpi kernel: [ 6494.698489] sdb: sdb1 May 15 14:09:40 server-rpi kernel: [ 6494.741442] sd 5:0:0:0: [sdb] Attached SCSI removable disk May 15 14:09:49 server-rpi kernel: [ 6503.121862] FAT-fs (sdb1): utf8 is not a recommended IO charset for FAT filesystems, filesystem will be case sensitive! May 15 14:09:49 server-rpi kernel: [ 6503.159055] SELinux: initialized (dev sdb1, type vfat), uses genfs_contexts May 15 14:10:29 server-rpi kernel: [ 6543.452202] type=1400 audit(1400155829.432:59): avc: denied { write } for pid=26130 comm="mysqld_safe" name="/" dev=sda1 ino=2 scontext=unconfined_u:system_r:mysqld_safe_t:s0-s0:c0.c1023 tcontext=system_u:object_r:root_t:s0 tclass=dir May 15 14:10:29 server-rpi mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql May 15 14:10:29 server-rpi mysqld: 140515 14:10:29 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. May 15 14:10:29 server-rpi mysqld: 140515 14:10:29 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. May 15 14:10:29 server-rpi mysqld: 140515 14:10:29 [Note] Plugin 'FEDERATED' is disabled. May 15 14:10:29 server-rpi mysqld: 140515 14:10:29 InnoDB: The InnoDB memory heap is disabled May 15 14:10:29 server-rpi mysqld: 140515 14:10:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins May 15 14:10:29 server-rpi mysqld: 140515 14:10:29 InnoDB: Compressed tables use zlib 1.2.7 May 15 14:10:29 server-rpi mysqld: 140515 14:10:29 InnoDB: Using Linux native AIO May 15 14:10:29 server-rpi mysqld: #007/usr/sbin/mysqld: Can't create/write to file '/tmp/ibITBpBM' (Errcode: 13) May 15 14:10:29 server-rpi mysqld: 140515 14:10:29 InnoDB: Error: unable to create temporary file; errno: 13 May 15 14:10:29 server-rpi mysqld: 140515 14:10:29 [ERROR] Plugin 'InnoDB' init function returned error. May 15 14:10:29 server-rpi mysqld: 140515 14:10:29 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. May 15 14:10:29 server-rpi mysqld: 140515 14:10:29 [ERROR] Unknown/unsupported storage engine: InnoDB May 15 14:10:29 server-rpi mysqld: 140515 14:10:29 [ERROR] Aborting May 15 14:10:29 server-rpi mysqld: May 15 14:10:29 server-rpi mysqld: 140515 14:10:29 [Note] /usr/sbin/mysqld: Shutdown complete May 15 14:10:29 server-rpi mysqld: May 15 14:10:29 server-rpi mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended May 15 14:10:43 server-rpi /etc/init.d/mysql[26641]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in May 15 14:10:43 server-rpi /etc/init.d/mysql[26641]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed May 15 14:10:43 server-rpi /etc/init.d/mysql[26641]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' May 15 14:10:43 server-rpi /etc/init.d/mysql[26641]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! May 15 14:10:43 server-rpi /etc/init.d/mysql[26641]:

nope, le dossier existe belle et bien mais il est vide.

D’après les logs :

...
May 15 13:58:21 server-rpi mysqld: #007/usr/sbin/mysqld: Can't create/write to file '/tmp/ibbRK23g' (Errcode: 13)
May 15 13:58:21 server-rpi mysqld: 140515 13:58:21  InnoDB: Error: unable to create temporary file; errno: 13
...

je me demande si ton système de fichier est plein ou si tu as modifié les droits de /tmp.

Que donne ces commandes ? :

# df
# ls -l /

[code]df

Sys. fich. 1K-blocks Util. Disponible Uti% Monté sur
rootfs 39559592 1458060 36091984 4% /
udev 10240 0 10240 0% /dev
tmpfs 103412 276 103136 1% /run
/dev/disk/by-uuid/e48541a9-a3b3-4a06-98e4-ee3b577c38ef 39559592 1458060 36091984 4% /
tmpfs 5120 0 5120 0% /run/lock
tmpfs 556620 0 556620 0% /run/shm
/dev/sdb1 7808480 3179088 4629392 41% /media/usb
[/code]

ls -l / total 76 drwxr-xr-x. 2 root root 4096 avril 17 16:02 bin drwxr-xr-x. 3 root root 4096 mai 14 19:51 boot drwxr-xr-x. 14 root root 3260 mai 15 14:35 dev drwxr-xr-x. 84 root root 4096 mai 15 14:34 etc drwxr-xr-x. 3 root root 4096 avril 17 16:05 home lrwxrwxrwx. 1 root root 32 avril 17 15:52 initrd.img -> /boot/initrd.img-3.2.0-4-686-pae drwxr-xr-x. 13 root root 4096 mai 14 10:05 lib drwx------. 2 root root 16384 avril 17 15:49 lost+found drwxr-xr-x. 6 root root 4096 mai 2 14:54 media drwxr-xr-x. 2 root root 4096 févr. 3 10:24 mnt drwxr-xr-x. 2 root root 4096 avril 17 15:50 opt dr-xr-xr-x. 114 root root 0 mai 15 12:21 proc drwx------. 3 root root 4096 mai 14 16:37 root drwxr-xr-x. 18 root root 780 mai 15 14:31 run drwxr-xr-x. 2 root root 4096 mai 14 19:49 sbin drwxr-xr-x. 2 root root 4096 juin 10 2012 selinux drwxr-xr-x. 2 root root 4096 avril 17 15:50 srv drwxr-xr-x. 13 root root 0 mai 15 12:21 sys drwxr-xr-x. 4 root root 4096 mai 15 14:21 tmp drwxr-xr-x. 10 root root 4096 avril 17 15:50 usr drwxr-xr-x. 12 root root 4096 avril 25 10:15 var lrwxrwxrwx. 1 root root 28 avril 17 15:52 vmlinuz -> boot/vmlinuz-3.2.0-4-686-pae

Comme j’ai dis dans mon premier message j’ai supprimer /tmp puis recréer je ne sais pas quels droits avait /tmp à l’origine mais étant recréer en root je ne vois pas ou pourrais être le soucis je précise que je fais tout en root.

Chez moi, c’est :

drwxrwxrwt  13 root root 36864 mai   15 14:50 tmp

Donc fait :

chmod 777 -R /tmp
chmod +t -R /tmp

Puis redémarre mysql et poste les logs

AH AH !! Génial !! J’ai même pu récupérer mon ancienne base de donnée.

je te colle les logs quand même au cas ou tu vois quelque chose de pas clean ^^.

May 15 14:56:00 server-rpi kernel: [ 9274.680148] sd 7:0:0:0: [sdb] Mode Sense: 43 00 00 00 May 15 14:56:00 server-rpi kernel: [ 9274.691194] sd 7:0:0:0: [sdb] Write cache: disabled, read cache: enabled, doesn't support DPO or FUA May 15 14:56:00 server-rpi kernel: [ 9274.761566] sdb: sdb1 May 15 14:56:00 server-rpi kernel: [ 9274.805129] sd 7:0:0:0: [sdb] Attached SCSI removable disk May 15 14:56:39 server-rpi kernel: [ 9313.905571] FAT-fs (sdb1): utf8 is not a recommended IO charset for FAT filesystems, filesystem will be case sensitive! May 15 14:56:39 server-rpi kernel: [ 9313.944505] SELinux: initialized (dev sdb1, type vfat), uses genfs_contexts May 15 14:56:48 server-rpi mysqld: 140515 14:56:48 [Note] /usr/sbin/mysqld: Normal shutdown May 15 14:56:48 server-rpi mysqld: May 15 14:56:48 server-rpi mysqld: 140515 14:56:48 [Note] Event Scheduler: Purging the queue. 0 events May 15 14:56:48 server-rpi mysqld: 140515 14:56:48 InnoDB: Starting shutdown... May 15 14:56:49 server-rpi mysqld: 140515 14:56:49 InnoDB: Shutdown completed; log sequence number 1595685 May 15 14:56:49 server-rpi mysqld: 140515 14:56:49 [Note] /usr/sbin/mysqld: Shutdown complete May 15 14:56:49 server-rpi mysqld: May 15 14:56:49 server-rpi mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended May 15 14:56:59 server-rpi mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 [Note] Plugin 'FEDERATED' is disabled. May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: The InnoDB memory heap is disabled May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: Compressed tables use zlib 1.2.7 May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: Using Linux native AIO May 15 14:56:59 server-rpi kernel: [ 9333.194265] type=1400 audit(1400158619.172:101): avc: denied { write } for pid=30753 comm="mysqld" name="tmp" dev=sda1 ino=262145 scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=dir May 15 14:56:59 server-rpi kernel: [ 9333.194303] type=1400 audit(1400158619.172:102): avc: denied { add_name } for pid=30753 comm="mysqld" name="ibA4WOJn" scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=dir May 15 14:56:59 server-rpi kernel: [ 9333.194383] type=1400 audit(1400158619.172:103): avc: denied { create } for pid=30753 comm="mysqld" name="ibA4WOJn" scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=file May 15 14:56:59 server-rpi kernel: [ 9333.194472] type=1400 audit(1400158619.172:104): avc: denied { read write open } for pid=30753 comm="mysqld" name="ibA4WOJn" dev=sda1 ino=262148 scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=file May 15 14:56:59 server-rpi kernel: [ 9333.194533] type=1400 audit(1400158619.172:105): avc: denied { remove_name } for pid=30753 comm="mysqld" name="ibA4WOJn" dev=sda1 ino=262148 scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=dir May 15 14:56:59 server-rpi kernel: [ 9333.194569] type=1400 audit(1400158619.172:106): avc: denied { unlink } for pid=30753 comm="mysqld" name="ibA4WOJn" dev=sda1 ino=262148 scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=file May 15 14:56:59 server-rpi kernel: [ 9333.194629] type=1400 audit(1400158619.172:107): avc: denied { getattr } for pid=30753 comm="mysqld" path=2F746D702F69624134574F4A6E202864656C6574656429 dev=sda1 ino=262148 scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=file May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: Initializing buffer pool, size = 128.0M May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: Completed initialization of buffer pool May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: highest supported file format is Barracuda. May 15 14:56:59 server-rpi mysqld: 140515 14:56:59 InnoDB: Waiting for the background threads to start May 15 14:57:00 server-rpi mysqld: 140515 14:57:00 InnoDB: 5.5.35 started; log sequence number 1595685 May 15 14:57:00 server-rpi mysqld: 140515 14:57:00 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 May 15 14:57:00 server-rpi mysqld: 140515 14:57:00 [Note] - '127.0.0.1' resolves to '127.0.0.1'; May 15 14:57:00 server-rpi mysqld: 140515 14:57:00 [Note] Server socket created on IP: '127.0.0.1'. May 15 14:57:00 server-rpi mysqld: 140515 14:57:00 [Note] Event Scheduler: Loaded 0 events May 15 14:57:00 server-rpi mysqld: 140515 14:57:00 [Note] /usr/sbin/mysqld: ready for connections. May 15 14:57:00 server-rpi mysqld: Version: '5.5.35-0+wheezy1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian) May 15 14:57:00 server-rpi /etc/mysql/debian-start[30828]: Upgrading MySQL tables if necessary. May 15 14:57:00 server-rpi kernel: [ 9334.864016] type=1400 audit(1400158620.844:108): avc: denied { ioctl } for pid=30845 comm="mysql" path="/tmp/sqlCLOIP6" dev=sda1 ino=262154 scontext=unconfined_u:system_r:mysqld_t:s0-s0:c0.c1023 tcontext=unconfined_u:object_r:root_t:s0 tclass=file May 15 14:57:00 server-rpi /etc/mysql/debian-start[30832]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored May 15 14:57:00 server-rpi /etc/mysql/debian-start[30832]: Looking for 'mysql' as: /usr/bin/mysql May 15 14:57:00 server-rpi /etc/mysql/debian-start[30832]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck May 15 14:57:00 server-rpi /etc/mysql/debian-start[30832]: This installation of MySQL is already upgraded to 5.5.35, use --force if you still need to run mysql_upgrade May 15 14:57:00 server-rpi /etc/mysql/debian-start[30847]: Checking for insecure root accounts. May 15 14:57:00 server-rpi /etc/mysql/debian-start[30852]: Triggering myisam-recover for all MyISAM tables May 15 14:57:51 server-rpi kernel: [ 9385.220134] usb 1-1: USB disconnect, device number 6 May 15 14:59:29 server-rpi mysqld: 140515 14:59:29 [Note] /usr/sbin/mysqld: Normal shutdown May 15 14:59:29 server-rpi mysqld: May 15 14:59:29 server-rpi mysqld: 140515 14:59:29 [Note] Event Scheduler: Purging the queue. 0 events May 15 14:59:29 server-rpi mysqld: 140515 14:59:29 InnoDB: Starting shutdown... May 15 14:59:30 server-rpi mysqld: 140515 14:59:30 InnoDB: Shutdown completed; log sequence number 1595685 May 15 14:59:30 server-rpi mysqld: 140515 14:59:30 [Note] /usr/sbin/mysqld: Shutdown complete May 15 14:59:30 server-rpi mysqld: May 15 14:59:30 server-rpi mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended May 15 15:01:27 server-rpi mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 [Note] Plugin 'FEDERATED' is disabled. May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 InnoDB: The InnoDB memory heap is disabled May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 InnoDB: Compressed tables use zlib 1.2.7 May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 InnoDB: Using Linux native AIO May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 InnoDB: Initializing buffer pool, size = 128.0M May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 InnoDB: Completed initialization of buffer pool May 15 15:01:27 server-rpi mysqld: 140515 15:01:27 InnoDB: highest supported file format is Barracuda. May 15 15:01:28 server-rpi mysqld: 140515 15:01:28 InnoDB: Waiting for the background threads to start May 15 15:01:29 server-rpi mysqld: 140515 15:01:29 InnoDB: 5.5.35 started; log sequence number 13083346 May 15 15:01:29 server-rpi mysqld: 140515 15:01:29 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 May 15 15:01:29 server-rpi mysqld: 140515 15:01:29 [Note] - '127.0.0.1' resolves to '127.0.0.1'; May 15 15:01:29 server-rpi mysqld: 140515 15:01:29 [Note] Server socket created on IP: '127.0.0.1'. May 15 15:01:29 server-rpi mysqld: 140515 15:01:29 [Note] Event Scheduler: Loaded 0 events May 15 15:01:29 server-rpi mysqld: 140515 15:01:29 [Note] /usr/sbin/mysqld: ready for connections. May 15 15:01:29 server-rpi mysqld: Version: '5.5.35-0+wheezy1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian) May 15 15:01:30 server-rpi /etc/mysql/debian-start[31548]: Upgrading MySQL tables if necessary. May 15 15:01:30 server-rpi /etc/mysql/debian-start[31552]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored May 15 15:01:30 server-rpi /etc/mysql/debian-start[31552]: Looking for 'mysql' as: /usr/bin/mysql May 15 15:01:30 server-rpi /etc/mysql/debian-start[31552]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck May 15 15:01:30 server-rpi /etc/mysql/debian-start[31552]: FATAL ERROR: Upgrade failed May 15 15:01:30 server-rpi /etc/mysql/debian-start[31570]: Checking for insecure root accounts. May 15 15:01:51 server-rpi mpt-statusd: detected non-optimal RAID status May 15 15:03:44 server-rpi kernel: [ 9737.993433] usb 1-1: new high-speed USB device number 7 using ehci_hcd May 15 15:03:44 server-rpi kernel: [ 9738.541516] usb 1-1: New USB device found, idVendor=0781, idProduct=556b May 15 15:03:44 server-rpi kernel: [ 9738.541528] usb 1-1: New USB device strings: Mfr=1, Product=2, SerialNumber=3 May 15 15:03:44 server-rpi kernel: [ 9738.541535] usb 1-1: Product: Cruzer Edge May 15 15:03:44 server-rpi kernel: [ 9738.541540] usb 1-1: Manufacturer: SanDisk May 15 15:03:44 server-rpi kernel: [ 9738.541545] usb 1-1: SerialNumber: 20053551931644C01351 May 15 15:03:44 server-rpi kernel: [ 9738.548311] scsi8 : usb-storage 1-1:1.0 May 15 15:03:45 server-rpi kernel: [ 9739.558754] scsi 8:0:0:0: Direct-Access SanDisk Cruzer Edge 1.26 PQ: 0 ANSI: 5 May 15 15:03:45 server-rpi kernel: [ 9739.563747] sd 8:0:0:0: Attached scsi generic sg2 type 0 May 15 15:03:45 server-rpi kernel: [ 9739.575441] sd 8:0:0:0: [sdb] 15633408 512-byte logical blocks: (8.00 GB/7.45 GiB) May 15 15:03:45 server-rpi kernel: [ 9739.621320] sd 8:0:0:0: [sdb] Write Protect is off May 15 15:03:45 server-rpi kernel: [ 9739.621332] sd 8:0:0:0: [sdb] Mode Sense: 43 00 00 00 May 15 15:03:45 server-rpi kernel: [ 9739.633881] sd 8:0:0:0: [sdb] Write cache: disabled, read cache: enabled, doesn't support DPO or FUA May 15 15:03:45 server-rpi kernel: [ 9739.704494] sdb: sdb1 May 15 15:03:45 server-rpi kernel: [ 9739.755526] sd 8:0:0:0: [sdb] Attached SCSI removable disk May 15 15:03:50 server-rpi kernel: [ 9744.827607] FAT-fs (sdb1): utf8 is not a recommended IO charset for FAT filesystems, filesystem will be case sensitive! May 15 15:03:50 server-rpi kernel: [ 9744.863651] SELinux: initialized (dev sdb1, type vfat), uses genfs_contexts

Un truc bizarre cependant… Il refuse d’arreter le service FAILED mais il fonctionne très bien quand même.

service mysql force-reload [....] Reloading MySQL database sever: mysqld/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

En tout cas sa remarche un grand merci a toi tu viens de me sauver la vie ^^. J’ai eu peur de devoir tout réadapter pour sqlite ^^.

Après avoir corrigé les droits du dossier /tmp, je pense qu’une réinstallation de mysql te permettra de modifier sans soucis ton mot de passe administrateur mysql :

apt-get remove --purge mysql-server
apt-get autoremove
apt-get install mysql-server

Heu… juste une question… le apt-get autoremove va supprimer tout les packages que j’ai déjà installer ? ou que les orphelins pour nettoyer ?

Fais sans apt-get autoremove

Voilà c’est fais tout refonctionne à merveille. Merci à la communauté. Bonne fin journée !

Salut,

J’aurais procédé autrement, à savoir que le mdp¹ de [mono]debian-sys-maint[/mono] se situe en [mono]/etc/mysql/debian.cnf[/mono]

Suffisait de remplacer tels que :

[mono]mysql -u root -p mysql

[/mono]

[mono]> GRANT ALL privileges ON . TO ‘debian-sys-maint’@‘localhost’ IDENTIFIED BY ‘mdp¹’ WITH GRANT OPTION;[/mono]

J’avais essayer ça déjà mais le problème persistait.