Extension mysqli manquante

eva211190 · Le 03/02/2021, à 16:00

Bonjour,

J'ai fait un mise à jour d'Ubuntu la semaine dernière et suite à un soucis, j'ai fait appel à quelqu'un qui s'y connait pour résoudre le problème (ce qui a été fait).

Bien avant cela, j'avais installé tout le nécessaire pour pouvoir développer des sites wordpress en local et tout fonctionnait très bien, jusqu'à cette mise à jour.

Aujourd'hui quand je souhaite me connecter à localhost/phpmyadmin pour créer de nouvelles BDD, on m'indique qu'il manque l'extension mysqli.

Après quelques recherches sur le forum, j'ai fini par lancer cette commande :

sudo apt install php7.4-mysql

qui a provoqué ceci :

Lecture des listes de paquets... Fait
Construction de l'arbre des dépendances       
Lecture des informations d'état... Fait
php7.4-mysql est déjà la version la plus récente (7.4.3-4ubuntu2.4).
php7.4-mysql passé en « installé manuellement ».
Les paquets suivants ont été installés automatiquement et ne sont plus nécessaires :
  gir1.2-harfbuzz-0.0 libblkid-dev libglib2.0-dev libglib2.0-dev-bin libgraphite2-dev libharfbuzz-dev libharfbuzz-gobject0 libicu-le-hb-dev
  libicu-le-hb0 libiculx60 libmount-dev libpcre16-3 libpcre2-dev libpcre2-posix2 libpcre3-dev libpcre32-3 libpcrecpp0v5 libselinux1-dev
  libsepol1-dev libtinfo-dev python-cairo python-gobject-2 python-gtk2 python-notify uuid-dev xserver-xorg-legacy-hwe-18.04
  xserver-xorg-video-radeon-hwe-18.04
Veuillez utiliser « sudo apt autoremove » pour les supprimer.
0 mis à jour, 0 nouvellement installés, 0 à enlever et 90 non mis à jour.

J'ai ensuite fait

sudo apt autoremove

, relancé le serveur avec la commande sudo systemctl restart mysql mais rien n'a changé...

N'arrivant pas à savoir si je suis en version 7.2 ou 7.4 j'ai avant lancé la commande

sudo apt install php7.2-mysql

qui me retourne ceci :

Lecture des listes de paquets... Fait
Construction de l'arbre des dépendances       
Lecture des informations d'état... Fait
Aucune version du paquet php7.2-mysql n'est disponible, mais il existe dans la base
de données. Cela signifie en général que le paquet est manquant, qu'il est devenu obsolète
ou qu'il n'est disponible que sur une autre source

E: Le paquet « php7.2-mysql » n'a pas de version susceptible d'être installée

Voilà, si quelqu'un a une idée d'où vient le problème ce serait top ! Merci !

Dernière modification par eva211190 (Le 03/02/2021, à 16:56)

krodelabestiole · Le 03/02/2021, à 16:07

pour savoir où tu en es, donne le retour de cette commande stp :

apt list \*php\* --installed

xubu1957 · Le 03/02/2021, à 16:18

Bonjour,

Comme indiqué dans le premier message du tutoriel Retour utilisable de commande.

Pour ajouter toi-même les balises code à ton précédent message #1 : Merci

Cliquer sur le lien « Modifier » en bas à droite du message
Sélectionner le texte
Cliquer sur le <> de l'éditeur de message

_ _ _

Voir règles du forum, pour info > balises BB code

Balise CODE :
C'est la balise à utiliser pour donner de longs messages d'erreurs, des contenus de fichiers de configuration, des commandes à taper, etc … Elle permet des messages plus "compacts", et est moins ambiguë que d'autres polices sur certains caractères.

Dernière modification par xubu1957 (Le 03/02/2021, à 17:21)

mazarini · Le 03/02/2021, à 16:59

A moins d'avoir des besoins particuliers et vouloir une version précise, il est préférable d'installer des paquets comme php ou libapache2-mod-php qui fournissent la version en cours et ne posent pas de problèmes lors des mises à jours de version tous les 6 mois.
Pour connaitre la version de PHP : php -v
La commande apt list \*php\* --installed proposée par krodelabestiole reste indispensable pour savoir ou tu en est de ton installation.

eva211190 · Le 03/02/2021, à 17:01

Voici le retour de la commande

 apt list \*php\* --installed

En train de lister... Fait
libapache2-mod-php7.2/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
libapache2-mod-php/now 1:7.2+60ubuntu1 all [installé, pouvant être mis à jour vers : 2:7.4+75]
php-bz2/focal,focal,now 2:7.4+75 all  [installé, automatique]
php-common/focal,focal,now 2:75 all  [installé, automatique]
php-curl/focal,focal,now 2:7.4+75 all  [installé]
php-gd/focal,focal,now 2:7.4+75 all  [installé]
php-google-recaptcha/focal,focal,now 1.2.3-1 all  [installé, automatique]
php-intl/focal,focal,now 2:7.4+75 all  [installé]
php-json/focal,focal,now 2:7.4+75 all  [installé]
php-mbstring/focal,focal,now 2:7.4+75 all  [installé]
php-mysql/focal,focal,now 2:7.4+75 all  [installé]
php-pear/focal-updates,focal-updates,focal-security,focal-security,now 1:1.10.9+submodules+notgz-1ubuntu0.20.04.1 all  [installé, automatique]
php-phpmyadmin-motranslator/focal,focal,now 5.0.0-1 all  [installé, automatique]
php-phpmyadmin-shapefile/focal,focal,now 2.1-3 all  [installé, automatique]
php-phpmyadmin-sql-parser/focal,focal,now 4.6.1-2 all  [installé, automatique]
php-phpseclib/focal,focal,now 2.0.23-2 all  [installé, automatique]
php-psr-cache/focal,focal,now 1.0.1-2 all  [installé, automatique]
php-psr-container/focal,focal,now 1.0.0-2 all  [installé, automatique]
php-psr-log/focal,focal,now 1.1.2-1 all  [installé, automatique]
php-symfony-cache-contracts/focal,focal,now 1.1.8-1 all  [installé, automatique]
php-symfony-cache/focal,focal,now 4.3.8+dfsg-1ubuntu1 all  [installé, automatique]
php-symfony-expression-language/focal,focal,now 4.3.8+dfsg-1ubuntu1 all  [installé, automatique]
php-symfony-service-contracts/focal,focal,now 1.1.8-1 all  [installé, automatique]
php-symfony-var-exporter/focal,focal,now 4.3.8+dfsg-1ubuntu1 all  [installé, automatique]
php-tcpdf/focal,focal,now 6.3.5+dfsg1-1 all  [installé, automatique]
php-twig-extensions/focal,focal,now 1.5.4-1 all  [installé, automatique]
php-twig/focal,focal,now 2.12.5-1 all  [installé, automatique]
php-xml/focal,focal,now 2:7.4+75 all  [installé]
php-zip/focal,focal,now 2:7.4+75 all  [installé]
php7.2-bz2/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-cli/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-common/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-curl/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-fpm/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-json/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-mbstring/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-opcache/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-readline/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2/now 7.2.24-0ubuntu0.18.04.7 all  [installé, local]
php7.4-bz2/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-common/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-curl/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-gd/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-intl/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-json/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-mbstring/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-mysql/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé]
php7.4-xml/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-zip/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php/now 1:7.2+60ubuntu1 all [installé, pouvant être mis à jour vers : 2:7.4+75]
phpmyadmin/focal,focal,now 4:4.9.5+dfsg1-2 all  [installé]

php-v

me retrourne ceci :

PHP 7.2.24-0ubuntu0.18.04.7 (cli) (built: Oct  7 2020 15:24:25) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
    with Zend OPcache v7.2.24-0ubuntu0.18.04.7, Copyright (c) 1999-2018, by Zend Technologies

Et merci pour l'info de la mise en page avec les <>, je ne savais pas !

mazarini · Le 03/02/2021, à 17:33

Si j'en crois les résultats, tu as installé "focal" comme version d'Ubuntu. et la version standard de php de focal est 7.4.
Sauf raison particulière il n'est pas nécessaire de conserver tout ce qui correspond à la version 7.2.

Le ligne

php/now 1:7.2+60ubuntu1 all [installé, pouvant être mis à jour vers : 2:7.4+75]

montre que tu n'es pas à jour et il faudrait faire un update/upgrade.
Ensuite tu pourras supprimer les paquets en 7.2. (si tu n'en as pas besoin !)

Est ce que tu veux php 7.2, php 7.4 spécifiquement ou la dernière version de php d'Ubuntu (7.4 pour focal) ?

eva211190 · Le 03/02/2021, à 18:48

Je n'ai pas vraiment de préférence pour la version de PHP, je veux juste que tout refonctionne comme avant
Tu penses que cela va résoudre le problème de sqli ?

Et du coup peux-tu m'indiquer les lignes de commande pour installer la nouvelle version de php et désinstaller la version 7.2 (histoire de ne pas faire de bêtises...).

bruno · Le 03/02/2021, à 18:59

Le problème vient du fait que des paquets PHP ont été installé manuellement avec leur numéro de version (cf @mazarini en #4). Or lors d'une mise à niveau les paquet marqués comme installés manuellement ne sont pas désinstallés, d'où la présence de nombreux paquet en 7.2

Je tenterai :

sudo apt-mark auto ~n^php7 ~n^libapache2-mod-php7

pour marquer tous les paquets PHP comportant un numéro de version comme installés manuellement.
puis :

sudo apt update
sudo apt full-upgrade
sudo apt autoremove

et enfin purge des résidus d'installation :

dpkg -l | grep ^rc | cut -d' ' -f3 | xargs sudo dpkg -P

Après il faudra revérifier avec :

 apt list \*php\* --installed

eva211190 · Le 04/02/2021, à 08:24

Merci pour la procédure !
Je viens de l'effectuer et il y a du mieux puisque à présent lorsque je vais sur localhost/phpmyadmin l'interface de connexion apparait bien.
En revanche lorsque j'essaye de me loger, le message "Impossible de se connecter au serveur MYSQL" apparait avec les message d'erreurs suivants en dessous :
- mysqli_real_connect(): (HY000/2002): No such file or directory
- La connexion au « controluser » telle que définie dans la configuration a échoué.
- mysqli_real_connect(): (HY000/2002): No such file or directory

Voici ce que m'a retourné la dernière commande

➜  / apt list \*php\* --installed
En train de lister... Fait
libapache2-mod-php7.4/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
libapache2-mod-php/focal,focal,now 2:7.4+75 all  [installé]
php-bz2/focal,focal,now 2:7.4+75 all  [installé, automatique]
php-common/focal,focal,now 2:75 all  [installé, automatique]
php-curl/focal,focal,now 2:7.4+75 all  [installé]
php-gd/focal,focal,now 2:7.4+75 all  [installé]
php-google-recaptcha/focal,focal,now 1.2.3-1 all  [installé, automatique]
php-intl/focal,focal,now 2:7.4+75 all  [installé]
php-json/focal,focal,now 2:7.4+75 all  [installé]
php-mbstring/focal,focal,now 2:7.4+75 all  [installé]
php-mysql/focal,focal,now 2:7.4+75 all  [installé]
php-pear/focal-updates,focal-updates,focal-security,focal-security,now 1:1.10.9+submodules+notgz-1ubuntu0.20.04.1 all  [installé, automatique]
php-phpmyadmin-motranslator/focal,focal,now 5.0.0-1 all  [installé, automatique]
php-phpmyadmin-shapefile/focal,focal,now 2.1-3 all  [installé, automatique]
php-phpmyadmin-sql-parser/focal,focal,now 4.6.1-2 all  [installé, automatique]
php-phpseclib/focal,focal,now 2.0.23-2 all  [installé, automatique]
php-psr-cache/focal,focal,now 1.0.1-2 all  [installé, automatique]
php-psr-container/focal,focal,now 1.0.0-2 all  [installé, automatique]
php-psr-log/focal,focal,now 1.1.2-1 all  [installé, automatique]
php-symfony-cache-contracts/focal,focal,now 1.1.8-1 all  [installé, automatique]
php-symfony-cache/focal,focal,now 4.3.8+dfsg-1ubuntu1 all  [installé, automatique]
php-symfony-expression-language/focal,focal,now 4.3.8+dfsg-1ubuntu1 all  [installé, automatique]
php-symfony-service-contracts/focal,focal,now 1.1.8-1 all  [installé, automatique]
php-symfony-var-exporter/focal,focal,now 4.3.8+dfsg-1ubuntu1 all  [installé, automatique]
php-tcpdf/focal,focal,now 6.3.5+dfsg1-1 all  [installé, automatique]
php-twig-extensions/focal,focal,now 1.5.4-1 all  [installé, automatique]
php-twig/focal,focal,now 2.12.5-1 all  [installé, automatique]
php-xml/focal,focal,now 2:7.4+75 all  [installé]
php-zip/focal,focal,now 2:7.4+75 all  [installé]
php7.2-bz2/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-cli/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-common/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-curl/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-fpm/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-json/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-mbstring/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-opcache/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-readline/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2/now 7.2.24-0ubuntu0.18.04.7 all  [installé, local]
php7.4-bz2/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-cli/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-common/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-curl/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-gd/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-intl/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-json/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-mbstring/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-mysql/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-opcache/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-readline/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-xml/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4-zip/focal-updates,focal-security,now 7.4.3-4ubuntu2.4 amd64  [installé, automatique]
php7.4/focal-updates,focal-updates,focal-security,focal-security,now 7.4.3-4ubuntu2.4 all  [installé, automatique]
php/focal,focal,now 2:7.4+75 all  [installé]
phpmyadmin/focal,focal,now 4:4.9.5+dfsg1-2 all  [installé]

mazarini · Le 04/02/2021, à 09:14

Un détail :

php7.2-bz2/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-cli/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-common/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-curl/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-fpm/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-json/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-mbstring/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-opcache/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2-readline/now 7.2.24-0ubuntu0.18.04.7 amd64  [installé, local]
php7.2/now 7.2.24-0ubuntu0.18.04.7 all  [installé, local]

Il reste des packages 7.2 à désinstaller (avec la version dans le nom du paquet) et php-fpm à installer (sans le nom de la version).

Pour ton problème avec mysql, il faut vérifier que ca marche avec la commande "sudo mysql" pour te connecter en root à mysql. Le message me fait penser à mysql (ou mariaDB) non installé. Voir après si la connexion mysql de phpmyadmin est bien paramétrée.
(les infos de Bruno ou Krodelabestiole sont plus fiable que les miennes).

eva211190 · Le 04/02/2021, à 09:23

Alors quand je fais

sudo mysql

voici ce qui ressort :

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

J'ai lu sur un forum que qu'il fallait modifier une ligne dans le fichier config.inc.php

$cfg['Servers'][$i]['host'] = 'localhost';
par
$cfg['Servers'][$i]['host'] = '127.0.0.1';

Mais moi cette ligne est commentée dans le fichier et j'ai celles-ci qui ne le sont pas (et qui contiennent localhost).

if (!empty($dbname)) {
    /* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    /* Server parameters */
    if (empty($dbserver)) $dbserver = 'localhost';
    $cfg['Servers'][$i]['host'] = $dbserver;

    if (!empty($dbport) || $dbserver != 'localhost') {
        $cfg['Servers'][$i]['connect_type'] = 'tcp';
        $cfg['Servers'][$i]['port'] = $dbport;

Est-ce que je dois changer localhost par 127.0.0.1 dans les lignes non commentées ?

mazarini · Le 04/02/2021, à 09:43

eva211190 a écrit :

Alors quand je fais

sudo mysql

voici ce qui ressort :

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

...

Donc mysql ne fonctionne pas.

Tu peux essayer la commande sudo /etc/init.d/mysql stop pour arreter mysql puis sudo /etc/init.d/mysql start pour le démarrer.

Si tout se passe bien retente sudo mysql.

eva211190 · Le 04/02/2021, à 09:51

Voici le résultat après restart (j'ai éssayé 3 fois et le résultat est toujours le même) :

sudo /etc/init.d/mysql start
Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
 failed!

J'ai lancé les 2 commandes indiquée dont voici le résultat :

systemctl status mysql.service
● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; disabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Thu 2021-02-04 09:44:37 CET; 36s ago
    Process: 84377 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
    Process: 84385 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
   Main PID: 84385 (code=exited, status=1/FAILURE)
     Status: "Server startup in progress"
      Error: 2 (Aucun fichier ou dossier de ce type)

Feb 04 09:44:37 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Feb 04 09:44:37 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:44:37 Guillen systemd[1]: mysql.service: Start request repeated too quickly.
Feb 04 09:44:37 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:44:37 Guillen systemd[1]: Failed to start MySQL Community Server.

➜  / journalctl -xe
-- Subject: A start job for unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- A start job for unit mysql.service has finished with a failure.
-- 
-- The job identifier is 13137 and the job result is failed.
Feb 04 09:46:00 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
-- Subject: Automatic restarting of a unit has been scheduled
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- Automatic restarting of the unit mysql.service has been scheduled, as the result for
-- the configured Restart= setting for the unit.
Feb 04 09:46:00 Guillen systemd[1]: Stopped MySQL Community Server.
-- Subject: A stop job for unit mysql.service has finished
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- A stop job for unit mysql.service has finished.
-- 
-- The job identifier is 13204 and the job result is done.
Feb 04 09:46:00 Guillen systemd[1]: mysql.service: Start request repeated too quickly.
Feb 04 09:46:00 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- The unit mysql.service has entered the 'failed' state with result 'exit-code'.
Feb 04 09:46:00 Guillen systemd[1]: Failed to start MySQL Community Server.
-- Subject: A start job for unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- A start job for unit mysql.service has finished with a failure.
-- 
-- The job identifier is 13204 and the job result is failed.
lines 2234-2270/2270 (END)

bruno · Le 04/02/2021, à 10:09

Je reprend au #9 concernant l'installation de PHP.
Il faut supprimer tout ce qui est php7.2 :

sudo apt autoremove --purge ~n^php7.2

Ensuite vérifier que le module php7.4 d'Apache est bien activé :

sudo a2enmod php7.4

doit renvoyer :

Module php7.4 already enabled

Si ce n'est pas le cas copie le retour complet de la commande.

Concernant MySQL on ne voit pas l'erreur.
Il faut d'abord tenter de relancer le service :

sudo systemctl restart mysql

et contrôler à nouveau avec :

systemctl status mysql

Si cela échoue, il faut regarder les logs dans /var/log/mysql/error.log et avec journalctl :

journalctl -l --no-pager -u mysql

eva211190 · Le 04/02/2021, à 10:28

Alors voici ce que me retourne la 1ère commande puis les logs d'erreur (je mets tous ceux de la journée si cela peut aider ?)

/ sudo systemctl restart mysql
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.

➜  / systemctl status mysql
● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; disabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Thu 2021-02-04 10:16:33 CET; 16s ago
    Process: 85605 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
    Process: 85613 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
   Main PID: 85613 (code=exited, status=1/FAILURE)
     Status: "Server startup in progress"
      Error: 2 (Aucun fichier ou dossier de ce type)

Feb 04 10:16:33 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Feb 04 10:16:33 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 10:16:33 Guillen systemd[1]: mysql.service: Start request repeated too quickly.
Feb 04 10:16:33 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 10:16:33 Guillen systemd[1]: Failed to start MySQL Community Server.

Feb 04 07:46:22 Guillen systemd[1]: Stopping MySQL Community Server...
Feb 04 07:46:24 Guillen systemd[1]: mysql.service: Succeeded.
Feb 04 07:46:24 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 08:10:20 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 08:10:28 Guillen systemd[1]: Started MySQL Community Server.
Feb 04 08:13:59 Guillen systemd[1]: Stopping MySQL Community Server...
Feb 04 08:14:00 Guillen systemd[1]: mysql.service: Succeeded.
Feb 04 08:14:00 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:44:34 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:44:35 Guillen mysqld[84331]: 2021-02-04T08:44:35.184200Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84331
Feb 04 09:44:35 Guillen mysqld[84331]: 2021-02-04T08:44:35.215933Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:44:35 Guillen mysqld[84331]: 2021-02-04T08:44:35.216114Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:44:35 Guillen mysqld[84331]: 2021-02-04T08:44:35.216485Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:44:35 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:44:35 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:44:35 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:44:35 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 1.
Feb 04 09:44:35 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:44:35 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:44:35 Guillen mysqld[84355]: 2021-02-04T08:44:35.859939Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84355
Feb 04 09:44:35 Guillen mysqld[84355]: 2021-02-04T08:44:35.863005Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:44:35 Guillen mysqld[84355]: 2021-02-04T08:44:35.863087Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:44:35 Guillen mysqld[84355]: 2021-02-04T08:44:35.863306Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:44:35 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:44:35 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:44:35 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:44:35 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 2.
Feb 04 09:44:35 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:44:35 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:44:36 Guillen mysqld[84366]: 2021-02-04T08:44:36.360786Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84366
Feb 04 09:44:36 Guillen mysqld[84366]: 2021-02-04T08:44:36.364131Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:44:36 Guillen mysqld[84366]: 2021-02-04T08:44:36.364237Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:44:36 Guillen mysqld[84366]: 2021-02-04T08:44:36.364464Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:44:36 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:44:36 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:44:36 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:44:36 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 3.
Feb 04 09:44:36 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:44:36 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:44:36 Guillen mysqld[84376]: 2021-02-04T08:44:36.860641Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84376
Feb 04 09:44:36 Guillen mysqld[84376]: 2021-02-04T08:44:36.863864Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:44:36 Guillen mysqld[84376]: 2021-02-04T08:44:36.863950Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:44:36 Guillen mysqld[84376]: 2021-02-04T08:44:36.864108Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:44:36 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:44:36 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:44:36 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:44:36 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 4.
Feb 04 09:44:36 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:44:36 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:44:37 Guillen mysqld[84385]: 2021-02-04T08:44:37.359433Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84385
Feb 04 09:44:37 Guillen mysqld[84385]: 2021-02-04T08:44:37.362462Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:44:37 Guillen mysqld[84385]: 2021-02-04T08:44:37.362538Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:44:37 Guillen mysqld[84385]: 2021-02-04T08:44:37.362688Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:44:37 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:44:37 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:44:37 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:44:37 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Feb 04 09:44:37 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:44:37 Guillen systemd[1]: mysql.service: Start request repeated too quickly.
Feb 04 09:44:37 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:44:37 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:45:56 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:45:57 Guillen mysqld[84458]: 2021-02-04T08:45:57.221383Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84458
Feb 04 09:45:57 Guillen mysqld[84458]: 2021-02-04T08:45:57.224421Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:45:57 Guillen mysqld[84458]: 2021-02-04T08:45:57.224496Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:45:57 Guillen mysqld[84458]: 2021-02-04T08:45:57.224655Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:45:57 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:45:57 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:45:57 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:45:57 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 1.
Feb 04 09:45:57 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:45:57 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:45:57 Guillen mysqld[84487]: 2021-02-04T08:45:57.966440Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84487
Feb 04 09:45:57 Guillen mysqld[84487]: 2021-02-04T08:45:57.969364Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:45:57 Guillen mysqld[84487]: 2021-02-04T08:45:57.969439Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:45:57 Guillen mysqld[84487]: 2021-02-04T08:45:57.969581Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:45:57 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:45:57 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:45:57 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:45:58 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 2.
Feb 04 09:45:58 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:45:58 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:45:58 Guillen mysqld[84496]: 2021-02-04T08:45:58.619503Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84496
Feb 04 09:45:58 Guillen mysqld[84496]: 2021-02-04T08:45:58.622498Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:45:58 Guillen mysqld[84496]: 2021-02-04T08:45:58.622571Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:45:58 Guillen mysqld[84496]: 2021-02-04T08:45:58.622716Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:45:58 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:45:58 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:45:58 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:45:58 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 3.
Feb 04 09:45:58 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:45:58 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:45:59 Guillen mysqld[84505]: 2021-02-04T08:45:59.368766Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84505
Feb 04 09:45:59 Guillen mysqld[84505]: 2021-02-04T08:45:59.371781Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:45:59 Guillen mysqld[84505]: 2021-02-04T08:45:59.371870Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:45:59 Guillen mysqld[84505]: 2021-02-04T08:45:59.372079Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:45:59 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:45:59 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:45:59 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:45:59 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 4.
Feb 04 09:45:59 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:45:59 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:46:00 Guillen mysqld[84514]: 2021-02-04T08:46:00.107927Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84514
Feb 04 09:46:00 Guillen mysqld[84514]: 2021-02-04T08:46:00.110888Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:46:00 Guillen mysqld[84514]: 2021-02-04T08:46:00.110969Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:46:00 Guillen mysqld[84514]: 2021-02-04T08:46:00.111166Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:46:00 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:46:00 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:46:00 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:46:00 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Feb 04 09:46:00 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:46:00 Guillen systemd[1]: mysql.service: Start request repeated too quickly.
Feb 04 09:46:00 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:46:00 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:50:22 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:50:22 Guillen mysqld[84765]: 2021-02-04T08:50:22.542468Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84765
Feb 04 09:50:22 Guillen mysqld[84765]: 2021-02-04T08:50:22.545416Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:50:22 Guillen mysqld[84765]: 2021-02-04T08:50:22.545518Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:50:22 Guillen mysqld[84765]: 2021-02-04T08:50:22.545733Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:50:22 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:50:22 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:50:22 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:50:22 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 1.
Feb 04 09:50:22 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:50:22 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:50:23 Guillen mysqld[84788]: 2021-02-04T08:50:23.186069Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84788
Feb 04 09:50:23 Guillen mysqld[84788]: 2021-02-04T08:50:23.189112Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:50:23 Guillen mysqld[84788]: 2021-02-04T08:50:23.189219Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:50:23 Guillen mysqld[84788]: 2021-02-04T08:50:23.189457Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:50:23 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:50:23 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:50:23 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:50:23 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 2.
Feb 04 09:50:23 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:50:23 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:50:23 Guillen mysqld[84797]: 2021-02-04T08:50:23.866168Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84797
Feb 04 09:50:23 Guillen mysqld[84797]: 2021-02-04T08:50:23.869096Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:50:23 Guillen mysqld[84797]: 2021-02-04T08:50:23.869199Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:50:23 Guillen mysqld[84797]: 2021-02-04T08:50:23.869416Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:50:23 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:50:23 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:50:23 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:50:24 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 3.
Feb 04 09:50:24 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:50:24 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:50:24 Guillen mysqld[84808]: 2021-02-04T08:50:24.608084Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84808
Feb 04 09:50:24 Guillen mysqld[84808]: 2021-02-04T08:50:24.611084Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:50:24 Guillen mysqld[84808]: 2021-02-04T08:50:24.611175Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:50:24 Guillen mysqld[84808]: 2021-02-04T08:50:24.611391Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:50:24 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:50:24 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:50:24 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:50:24 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 4.
Feb 04 09:50:24 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:50:24 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 09:50:25 Guillen mysqld[84818]: 2021-02-04T08:50:25.106550Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 84818
Feb 04 09:50:25 Guillen mysqld[84818]: 2021-02-04T08:50:25.109663Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 09:50:25 Guillen mysqld[84818]: 2021-02-04T08:50:25.109737Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 09:50:25 Guillen mysqld[84818]: 2021-02-04T08:50:25.109898Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 09:50:25 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 09:50:25 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:50:25 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 09:50:25 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Feb 04 09:50:25 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 09:50:25 Guillen systemd[1]: mysql.service: Start request repeated too quickly.
Feb 04 09:50:25 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 09:50:25 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 10:07:16 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 10:07:16 Guillen mysqld[85220]: 2021-02-04T09:07:16.668756Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 85220
Feb 04 10:07:16 Guillen mysqld[85220]: 2021-02-04T09:07:16.671932Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 10:07:16 Guillen mysqld[85220]: 2021-02-04T09:07:16.672034Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 10:07:16 Guillen mysqld[85220]: 2021-02-04T09:07:16.672244Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 10:07:16 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 10:07:16 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 10:07:16 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 10:07:16 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 1.
Feb 04 10:07:16 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 10:07:16 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 10:07:17 Guillen mysqld[85243]: 2021-02-04T09:07:17.487294Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 85243
Feb 04 10:07:17 Guillen mysqld[85243]: 2021-02-04T09:07:17.490533Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 10:07:17 Guillen mysqld[85243]: 2021-02-04T09:07:17.490647Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 10:07:17 Guillen mysqld[85243]: 2021-02-04T09:07:17.490882Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 10:07:17 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 10:07:17 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 10:07:17 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 10:07:17 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 2.
Feb 04 10:07:17 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 10:07:17 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 10:07:18 Guillen mysqld[85253]: 2021-02-04T09:07:18.119563Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 85253
Feb 04 10:07:18 Guillen mysqld[85253]: 2021-02-04T09:07:18.128813Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 10:07:18 Guillen mysqld[85253]: 2021-02-04T09:07:18.128912Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 10:07:18 Guillen mysqld[85253]: 2021-02-04T09:07:18.129121Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 10:07:18 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 10:07:18 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 10:07:18 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 10:07:18 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 3.
Feb 04 10:07:18 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 10:07:18 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 10:07:18 Guillen mysqld[85262]: 2021-02-04T09:07:18.866175Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 85262
Feb 04 10:07:18 Guillen mysqld[85262]: 2021-02-04T09:07:18.869187Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 10:07:18 Guillen mysqld[85262]: 2021-02-04T09:07:18.869278Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 10:07:18 Guillen mysqld[85262]: 2021-02-04T09:07:18.869493Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 10:07:18 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 10:07:18 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 10:07:18 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 10:07:19 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 4.
Feb 04 10:07:19 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 10:07:19 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 10:07:19 Guillen mysqld[85271]: 2021-02-04T09:07:19.607099Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 85271
Feb 04 10:07:19 Guillen mysqld[85271]: 2021-02-04T09:07:19.610624Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 10:07:19 Guillen mysqld[85271]: 2021-02-04T09:07:19.610696Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 10:07:19 Guillen mysqld[85271]: 2021-02-04T09:07:19.610846Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 10:07:19 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 10:07:19 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 10:07:19 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 10:07:19 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Feb 04 10:07:19 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 10:07:19 Guillen systemd[1]: mysql.service: Start request repeated too quickly.
Feb 04 10:07:19 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 10:07:19 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 10:16:30 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 10:16:31 Guillen mysqld[85557]: 2021-02-04T09:16:31.119854Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 85557
Feb 04 10:16:31 Guillen mysqld[85557]: 2021-02-04T09:16:31.122893Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 10:16:31 Guillen mysqld[85557]: 2021-02-04T09:16:31.122968Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 10:16:31 Guillen mysqld[85557]: 2021-02-04T09:16:31.123107Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 10:16:31 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 10:16:31 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 10:16:31 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 10:16:31 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 1.
Feb 04 10:16:31 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 10:16:31 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 10:16:31 Guillen mysqld[85576]: 2021-02-04T09:16:31.859815Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 85576
Feb 04 10:16:31 Guillen mysqld[85576]: 2021-02-04T09:16:31.862892Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 10:16:31 Guillen mysqld[85576]: 2021-02-04T09:16:31.862967Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 10:16:31 Guillen mysqld[85576]: 2021-02-04T09:16:31.863127Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 10:16:31 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 10:16:31 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 10:16:31 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 10:16:31 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 2.
Feb 04 10:16:31 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 10:16:31 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 10:16:32 Guillen mysqld[85593]: 2021-02-04T09:16:32.359594Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 85593
Feb 04 10:16:32 Guillen mysqld[85593]: 2021-02-04T09:16:32.362924Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 10:16:32 Guillen mysqld[85593]: 2021-02-04T09:16:32.363014Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 10:16:32 Guillen mysqld[85593]: 2021-02-04T09:16:32.363221Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 10:16:32 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 10:16:32 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 10:16:32 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 10:16:32 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 3.
Feb 04 10:16:32 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 10:16:32 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 10:16:32 Guillen mysqld[85604]: 2021-02-04T09:16:32.867373Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 85604
Feb 04 10:16:32 Guillen mysqld[85604]: 2021-02-04T09:16:32.870470Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 10:16:32 Guillen mysqld[85604]: 2021-02-04T09:16:32.870559Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 10:16:32 Guillen mysqld[85604]: 2021-02-04T09:16:32.870767Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 10:16:32 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 10:16:32 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 10:16:32 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 10:16:33 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 4.
Feb 04 10:16:33 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 10:16:33 Guillen systemd[1]: Starting MySQL Community Server...
Feb 04 10:16:33 Guillen mysqld[85613]: 2021-02-04T09:16:33.618829Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 85613
Feb 04 10:16:33 Guillen mysqld[85613]: 2021-02-04T09:16:33.621783Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
Feb 04 10:16:33 Guillen mysqld[85613]: 2021-02-04T09:16:33.621890Z 0 [ERROR] [MY-010119] [Server] Aborting
Feb 04 10:16:33 Guillen mysqld[85613]: 2021-02-04T09:16:33.622128Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1)  (Ubuntu).
Feb 04 10:16:33 Guillen systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 04 10:16:33 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 10:16:33 Guillen systemd[1]: Failed to start MySQL Community Server.
Feb 04 10:16:33 Guillen systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Feb 04 10:16:33 Guillen systemd[1]: Stopped MySQL Community Server.
Feb 04 10:16:33 Guillen systemd[1]: mysql.service: Start request repeated too quickly.
Feb 04 10:16:33 Guillen systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 04 10:16:33 Guillen systemd[1]: Failed to start MySQL Community Server.

Pour php, j'ai également lancé les commandes que tu m'as indiqué. Ça a l'air d'avoir fonctionné mais j'ai quand même eu les alertes ci-dessous :

dpkg: avertissement: lors de la suppression de php7.2-common, le répertoire « /etc/php/7.2/mods-available » n'était pas vide, donc il n'a pas 
été supprimé
Purge des fichiers de configuration de php7.2-opcache (7.2.24-0ubuntu0.18.04.7) ...
Purge des fichiers de configuration de php7.2-cli (7.2.24-0ubuntu0.18.04.7) ...
dpkg: avertissement: lors de la suppression de php7.2-cli, le répertoire « /etc/php/7.2/cli/conf.d » n'était pas vide, donc il n'a pas été sup
primé
Purge des fichiers de configuration de php7.2-fpm (7.2.24-0ubuntu0.18.04.7) ...
apache2_invoke php7.2-fpm postrm: No action required
dpkg: avertissement: lors de la suppression de php7.2-fpm, le répertoire « /etc/php/7.2/fpm/conf.d » n'était pas vide, donc il n'a pas été sup
primé

Le module est bien activé :

sudo a2enmod php7.4 
Considering dependency mpm_prefork for php7.4:
Considering conflict mpm_event for mpm_prefork:
Considering conflict mpm_worker for mpm_prefork:
Module mpm_prefork already enabled
Considering conflict php5 for php7.4:
Module php7.4 already enabled

bruno · Le 04/02/2021, à 10:42

Cela semble OK pour l'installation de PHP. Si tu veux faire le ménage tu peux supprimer manuellement :

sudo rm -rf /etc/php/7.2

Pour MySQL l'erreur qui empêche le démarrage est :

Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory

As-tu supprimé des fichiers o dossiers manuellement ? Quel est le retour de :

ls -al /var/log/mysql

eva211190 · Le 04/02/2021, à 10:52

Non je n'ai rien supprimé manuellement... mais ce matin quand j'ai fait le full upgrade, le process s'est arrêté un moment à 89% justement quand il s'agissait des logs, à cette ligne :

mysqld will log errors to /var/log/mysql/error.log

J'ai cru qu'il y avait un bug mais au bout de 10 minutes environ, le precossus a repris...

Voici le retour de

ls -al /var/log/mysql

ls: impossible d'accéder à '/var/log/mysql': Aucun fichier ou dossier de ce type

bruno · Le 04/02/2021, à 11:07

Ce n'est pas normal.
Essaie ceci :

sudo dpkg-reconfigure mysql-server-8.0

et revérifie l'existence du dossier des logs :

ls -al /var/log/mysql

Si il est bien créé alors :

sudo systemctl restart mysql

Mais il faudra aussi vérifier que le processus de mise à niveau est complet :

sudo dpkg --configure -a
sudo apt full-upgrade

eva211190 · Le 04/02/2021, à 11:29

Alors, Mysql a bien redémarré, et voici ce qui ressort de la commande apt full-upgrade :

Lecture des listes de paquets... Fait
Construction de l'arbre des dépendances       
Lecture des informations d'état... Fait
Calcul de la mise à jour... Fait
0 mis à jour, 0 nouvellement installés, 0 à enlever et 0 non mis à jour.

Et j'accède de nouveau à localhost/phpmyadmin !!!! J'espère ne pas avoir de mauvaise suprise pour la suite !

Mille mercis à tous pour votre aide précieuse !

Ubuntu-fr

Navigation

Liens de recherche

Annonce

#1 Le 03/02/2021, à 16:00

Extension mysqli manquante

#2 Le 03/02/2021, à 16:07

Re : Extension mysqli manquante

#3 Le 03/02/2021, à 16:18

Re : Extension mysqli manquante

#4 Le 03/02/2021, à 16:59

Re : Extension mysqli manquante

#5 Le 03/02/2021, à 17:01

Re : Extension mysqli manquante

#6 Le 03/02/2021, à 17:33

Re : Extension mysqli manquante

#7 Le 03/02/2021, à 18:48

Re : Extension mysqli manquante

#8 Le 03/02/2021, à 18:59

Re : Extension mysqli manquante

#9 Le 04/02/2021, à 08:24

Re : Extension mysqli manquante

#10 Le 04/02/2021, à 09:14

Re : Extension mysqli manquante

#11 Le 04/02/2021, à 09:23

Re : Extension mysqli manquante

#12 Le 04/02/2021, à 09:43

Re : Extension mysqli manquante

#13 Le 04/02/2021, à 09:51

Re : Extension mysqli manquante

#14 Le 04/02/2021, à 10:09

Re : Extension mysqli manquante

#15 Le 04/02/2021, à 10:28

Re : Extension mysqli manquante

#16 Le 04/02/2021, à 10:42

Re : Extension mysqli manquante

#17 Le 04/02/2021, à 10:52

Re : Extension mysqli manquante

#18 Le 04/02/2021, à 11:07

Re : Extension mysqli manquante

#19 Le 04/02/2021, à 11:29

Re : Extension mysqli manquante

Pied de page des forums