[Résolu] Failed to start MariaDB 10.3 database server.

Pphilo71 · 5 juil. 2019

bonjour,
Je vient de supprimer MySQL 8.0.16 sur mon serveur.
j'ai installé mariaDB 10.3.

j'ai une erreur suite a la commande en mode root

# systemctl start mariadb.service

Erreur :

systemctl status mariadb.service
● mariadb.service - MariaDB 10.3 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Fri 2019-07-05 14:39:36 CEST; 4min 32s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 5474 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
  Process: 5496 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS)
  Process: 5532 ExecStart=/usr/libexec/mysqld --basedir=/usr $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE)
 Main PID: 5532 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

juil. 05 14:39:35 dct-heliot systemd[1]: Starting MariaDB 10.3 database server...
juil. 05 14:39:35 dct-heliot mysql-prepare-db-dir[5496]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
juil. 05 14:39:35 dct-heliot mysql-prepare-db-dir[5496]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql>
juil. 05 14:39:35 dct-heliot mysqld[5532]: 2019-07-05 14:39:35 0 [Note] /usr/libexec/mysqld (mysqld 10.3.12-MariaDB) starting as process 553>
juil. 05 14:39:36 dct-heliot systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
juil. 05 14:39:36 dct-heliot systemd[1]: mariadb.service: Failed with result 'exit-code'.
juil. 05 14:39:36 dct-heliot systemd[1]: Failed to start MariaDB 10.3 database server.

Je pense qu'il y a des objets (tables...) de MySQL résidant sur mon système.
Ce matin j'ai installé mariaDB sur un autre ordinateur, mariaDB marche très bien.

Comment faire pour contourner ce problème ?

winmandrake · 5 juil. 2019

supprimer tout dossier utlisé par mysql ?

Nicosss · 5 juil. 2019

Tout est indiqué dans le message d'erreur. Tu as les fichiers de MySQL qui n'ont pas été effacés avant d'utiliser MariaDB. Il te faut vider /var/lib/mysql/.

Pphilo71 · 5 juil. 2019

avec minhight commander j'ai supprimé /var/lib/mysql/

j'ai toujours le mème message d'erreur avec la commande >>

systemctl status mariadb.service

après avoir redémarer mon serveur, mon repertoire /var/lib/mysql est toujours visible par mariaDB.

Est ce qu'il existe un fichier qui a indexé /var/lib/mysql sur le serveur mariaDB ?

Nicosss · 5 juil. 2019

Que retourne

# ls -al /var/lib/mysql/
# tail -n 100 /var/log/mariadb/mariadb.log

Edit : Ajout commande

Pphilo71 · 5 juil. 2019

[root@dct-heliot lib]# ls -al /var/lib/mysql/
ls: impossible d'accéder à '/var/lib/mysql/': Aucun fichier ou dossier de ce type
[root@dct-heliot lib]#

[root@dct-heliot lib]# tail -n 100 /var/log/mariadb/mariadb.log
2019-07-05 13:56:45 0 [Note] InnoDB: Using Linux native AIO
2019-07-05 13:56:45 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-05 13:56:45 0 [Note] InnoDB: Uses event mutexes
2019-07-05 13:56:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 13:56:45 0 [Note] InnoDB: Number of pools: 1
2019-07-05 13:56:45 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 13:56:45 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 13:56:45 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 13:56:45 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 13:56:45 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 13:56:45 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 13:56:46 0 [Note] InnoDB: Starting shutdown...
2019-07-05 13:56:46 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 13:56:46 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 13:56:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 13:56:46 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 13:56:46 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 13:56:46 0 [ERROR] Aborting

2019-07-05 14:28:46 0 [Note] InnoDB: Using Linux native AIO
2019-07-05 14:28:46 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-05 14:28:46 0 [Note] InnoDB: Uses event mutexes
2019-07-05 14:28:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 14:28:46 0 [Note] InnoDB: Number of pools: 1
2019-07-05 14:28:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 14:28:46 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 14:28:46 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 14:28:46 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 14:28:46 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:28:46 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:28:46 0 [Note] InnoDB: Starting shutdown...
2019-07-05 14:28:46 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:28:46 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:28:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 14:28:46 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 14:28:46 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:28:46 0 [ERROR] Aborting

2019-07-05 14:30:19 0 [Note] InnoDB: Using Linux native AIO
2019-07-05 14:30:19 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-05 14:30:19 0 [Note] InnoDB: Uses event mutexes
2019-07-05 14:30:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 14:30:19 0 [Note] InnoDB: Number of pools: 1
2019-07-05 14:30:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 14:30:19 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 14:30:19 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 14:30:19 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 14:30:19 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:30:19 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:30:19 0 [Note] InnoDB: Starting shutdown...
2019-07-05 14:30:19 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:30:19 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:30:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 14:30:19 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 14:30:19 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:30:19 0 [ERROR] Aborting

2019-07-05 14:39:35 0 [Note] InnoDB: Using Linux native AIO
2019-07-05 14:39:35 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-05 14:39:35 0 [Note] InnoDB: Uses event mutexes
2019-07-05 14:39:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 14:39:35 0 [Note] InnoDB: Number of pools: 1
2019-07-05 14:39:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 14:39:35 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 14:39:35 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 14:39:35 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 14:39:35 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:39:35 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:39:36 0 [Note] InnoDB: Starting shutdown...
2019-07-05 14:39:36 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:39:36 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:39:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 14:39:36 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 14:39:36 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:39:36 0 [ERROR] Aborting

2019-07-05 14:44:04 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:44:04 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:44:04 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:44:04 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:44:04 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:44:04 0 [ERROR] Aborting

[root@dct-heliot lib]#

Nicosss · 5 juil. 2019

Tu as supprimé le répertoire et non son contenu.

As-tu désinstallé mysql ? Si oui installe à nouveau mariadb-server.

madko · 5 juil. 2019

C'est peut être un peu violent d'avoir supprimé /var/lib/mysql. Recrée le, met lui les bons propriétaires pour que le démon puisse écrire dedans et ça devrait rouler. Au pire reinstalle le paquet qui fournit le rep /var/lib/mysql si tu as un doute sur les droits/propriétaire etc (cf la doc du site sur dnf)

Pphilo71 · 7 juil. 2019

j"ai recréé le repertoire "mysql" mais toujours le même message d'erreur !

Nicosss · 8 juil. 2019

philo71 wrote:j"ai recréé le repertoire "mysql" mais toujours le même message d'erreur !

On doit deviner quoi ? Un retour de commande serait plus parlant pour avoir tous les détails.

Si tu installes à nouveau MariaDB, il se chargera de tout créer correctement.

Edit : changera is not chargera

Pphilo71 · 8 juil. 2019

bonjour,
j'ai désinstallé mariaDB et installé de nouveau, mariaDB marche.
Cependant j'ai un problème d'authentification suite à la commande mysql_secure_installation.

[phipo@dct-heliot mysql]$ mysql_secure_installation
shell-init : erreur de détermination du répertoire actuel : getcwd : ne peut accéder aux répertoires parents : Aucun fichier ou dossier de ce type
touch: impossible de faire un touch '.my.cnf.10441': Aucun fichier ou dossier de ce type
touch: impossible de faire un touch '.mysql.10441': Aucun fichier ou dossier de ce type
chmod: impossible d'accéder à '.my.cnf.10441': Aucun fichier ou dossier de ce type
chmod: impossible d'accéder à '.mysql.10441': Aucun fichier ou dossier de ce type

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): 
/usr/bin/mysql_secure_installation: ligne 248: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 249: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 250: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 252: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 217: .mysql.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 219: .mysql.10441: Aucun fichier ou dossier de ce type
Enter current password for root (enter for none): 
/usr/bin/mysql_secure_installation: ligne 248: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 249: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 250: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 252: .my.cnf.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 217: .mysql.10441: Aucun fichier ou dossier de ce type
/usr/bin/mysql_secure_installation: ligne 219: .mysql.10441: Aucun fichier ou dossier de ce type
Enter current password for root (enter for none):

Nicosss · 8 juil. 2019

Tu as dû mettre un peu de bazar on dirait.

Mariadb tourne ?

# systemctl status mariadb.service

Que retourne

# updatedb
# locate my.cnf
# tail -n 100 /var/log/mariadb/mariadb.log

Pphilo71 · 8 juil. 2019

[root@dct-heliot mysql]# systemctl status mariadb.service
● mariadb.service - MariaDB 10.3 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: active (running) since Mon 2019-07-08 14:05:08 CEST; 1h 12min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 10125 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 30 (limit: 4686)
   Memory: 76.9M
   CGroup: /system.slice/mariadb.service
           └─10125 /usr/libexec/mysqld --basedir=/usr

juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: See the MariaDB Knowledgebase at http://mariadb.com/kb or the
juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: MySQL manual for more instructions.
juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: Please report any problems at http://mariadb.org/jira
juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: The latest information about MariaDB is available at http://mariadb.org/.
juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: You can find additional information about the MySQL part at:
juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: http://dev.mysql.com
juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: Consider joining MariaDB's strong and vibrant community:
juil. 08 14:05:07 dct-heliot mysql-prepare-db-dir[9992]: https://mariadb.org/get-involved/
juil. 08 14:05:07 dct-heliot mysqld[10125]: 2019-07-08 14:05:07 0 [Note] /usr/libexec/mysqld (mysqld 10.3.12-MariaDB) starting as process 10>
juil. 08 14:05:08 dct-heliot systemd[1]: Started MariaDB 10.3 database server.
lines 1-22

[root@dct-heliot mysql]# updatedb
[root@dct-heliot mysql]# locate my.cnf
/etc/my.cnf
/etc/my.cnf.d
/etc/my.cnf.rpmsave
/etc/my.cnf.d/auth_gssapi.cnf
/etc/my.cnf.d/client.cnf
/etc/my.cnf.d/cracklib_password_check.cnf
/etc/my.cnf.d/enable_encryption.preset
/etc/my.cnf.d/mariadb-server.cnf
/etc/my.cnf.d/mysql-clients.cnf



[root@dct-heliot mysql]# tail -n 100 /var/log/mariadb/mariadb.log
2019-07-05 13:56:45 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 13:56:45 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 13:56:45 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 13:56:45 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 13:56:45 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 13:56:46 0 [Note] InnoDB: Starting shutdown...
2019-07-05 13:56:46 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 13:56:46 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 13:56:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 13:56:46 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 13:56:46 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 13:56:46 0 [ERROR] Aborting

2019-07-05 14:28:46 0 [Note] InnoDB: Using Linux native AIO
2019-07-05 14:28:46 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-05 14:28:46 0 [Note] InnoDB: Uses event mutexes
2019-07-05 14:28:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 14:28:46 0 [Note] InnoDB: Number of pools: 1
2019-07-05 14:28:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 14:28:46 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 14:28:46 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 14:28:46 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 14:28:46 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:28:46 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:28:46 0 [Note] InnoDB: Starting shutdown...
2019-07-05 14:28:46 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:28:46 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:28:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 14:28:46 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 14:28:46 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:28:46 0 [ERROR] Aborting

2019-07-05 14:30:19 0 [Note] InnoDB: Using Linux native AIO
2019-07-05 14:30:19 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-05 14:30:19 0 [Note] InnoDB: Uses event mutexes
2019-07-05 14:30:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 14:30:19 0 [Note] InnoDB: Number of pools: 1
2019-07-05 14:30:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 14:30:19 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 14:30:19 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 14:30:19 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 14:30:19 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:30:19 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:30:19 0 [Note] InnoDB: Starting shutdown...
2019-07-05 14:30:19 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:30:19 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:30:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 14:30:19 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 14:30:19 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:30:19 0 [ERROR] Aborting

2019-07-05 14:39:35 0 [Note] InnoDB: Using Linux native AIO
2019-07-05 14:39:35 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-05 14:39:35 0 [Note] InnoDB: Uses event mutexes
2019-07-05 14:39:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 14:39:35 0 [Note] InnoDB: Number of pools: 1
2019-07-05 14:39:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 14:39:35 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-05 14:39:35 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 14:39:35 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-05 14:39:35 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:39:35 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:39:36 0 [Note] InnoDB: Starting shutdown...
2019-07-05 14:39:36 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:39:36 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:39:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 14:39:36 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-07-05 14:39:36 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:39:36 0 [ERROR] Aborting

2019-07-05 14:44:04 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2019-07-05 14:44:04 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2019-07-05 14:44:04 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-05 14:44:04 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-05 14:44:04 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-05 14:44:04 0 [ERROR] Aborting

2019-07-08 14:05:07 0 [Note] InnoDB: Using Linux native AIO
2019-07-08 14:05:07 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-08 14:05:07 0 [Note] InnoDB: Uses event mutexes
2019-07-08 14:05:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-08 14:05:07 0 [Note] InnoDB: Number of pools: 1
2019-07-08 14:05:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-08 14:05:07 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-08 14:05:07 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-08 14:05:07 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-08 14:05:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-07-08 14:05:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-08 14:05:07 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-08 14:05:07 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-07-08 14:05:07 0 [Note] InnoDB: Waiting for purge to start
2019-07-08 14:05:07 0 [Note] InnoDB: 10.3.12 started; log sequence number 1630815; transaction id 21
2019-07-08 14:05:07 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2019-07-08 14:05:07 0 [Note] InnoDB: Buffer pool(s) load completed at 190708 14:05:07
2019-07-08 14:05:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-08 14:05:07 0 [Note] Server socket created on IP: '::'.
2019-07-08 14:05:08 0 [Note] Reading of all Master_info entries succeded
2019-07-08 14:05:08 0 [Note] Added new Master_info '' to hash table
2019-07-08 14:05:08 0 [Note] /usr/libexec/mysqld: ready for connections.
Version: '10.3.12-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
[root@dct-heliot mysql]#

Nicosss · 8 juil. 2019

Tu as un retour de la commande

$ mysql --user root --execute "select version()"

Que retourne

# ls -al /var/lib/mysql/

Pphilo71 · 8 juil. 2019

[phipo@dct-heliot mysql]$ mysql --user root --execute "select version()"
+-----------------+
| version()       |
+-----------------+
| 10.3.12-MariaDB |
+-----------------+
[phipo@dct-heliot mysql]$

[phipo@dct-heliot mysql]$ ls -al /var/lib/mysql/
total 122948
drwxr-xr-x.  4 mysql mysql     4096  8 juil. 14:05 .
drwxr-xr-x. 61 root  root      4096  8 juil. 14:02 ..
-rw-rw----.  1 mysql mysql    16384  8 juil. 14:05 aria_log.00000001
-rw-rw----.  1 mysql mysql       52  8 juil. 14:05 aria_log_control
-rw-rw----.  1 mysql mysql      972  8 juil. 14:05 ib_buffer_pool
-rw-rw----.  1 mysql mysql 12582912  8 juil. 14:05 ibdata1
-rw-rw----.  1 mysql mysql 50331648  8 juil. 14:05 ib_logfile0
-rw-rw----.  1 mysql mysql 50331648  8 juil. 14:05 ib_logfile1
-rw-rw----.  1 mysql mysql 12582912  8 juil. 14:05 ibtmp1
-rw-rw----.  1 mysql mysql        0  8 juil. 14:05 multi-master.info
drwx------.  2 mysql mysql     4096  8 juil. 14:05 mysql
srwxrwxrwx.  1 mysql mysql        0  8 juil. 14:05 mysql.sock
-rw-rw----.  1 mysql mysql       16  8 juil. 14:05 mysql_upgrade_info
drwx------.  2 mysql mysql     4096  8 juil. 14:05 performance_schema
-rw-rw----.  1 mysql mysql    24576  8 juil. 14:05 tc.log
[phipo@dct-heliot mysql]$

Nicosss · 8 juil. 2019

Essaye la manipulation suivante

$ cd ~
$ mysql_secure_installation

Sinon il faudrait repartir de zéro en désinstallant mariadb, en supprimant le répertoire /var/lib/mysql/ ainsi que le répertoire /etc/my.cnf.d/ et les 2 fichiers /etc/my.cnf et /etc/my.cnf.rpmsave.
Ensuite tu appliques la procédure https://doc.fedora-fr.org/wiki/Installation_et_configuration_de_MariaDB.

Pphilo71 · 8 juil. 2019

merci,
les deux commandes :

$ cd ~
$ mysql_secure_installation

ont fonctionnées.

Juste un dernier détail: Quel est le dernier GUI pour mariaDB ? (mysql=mysqlworkbench)

Nicosss · 8 juil. 2019

Bon tant mieux.

Tu peux utiliser phpMyAdmin comme indiqué dans la documentation. Sinon tu peux consulter https://mariadb.com/kb/en/library/guiworkbench-for-mariadb-aria/.