Distribution EOLE

Malgré cette correction, ça ne démarre toujours pas...

En supprimant le fichier/template /etc/mysql/mysql.conf.d/mysqld.cnf, ça passe, il faudra mettre à niveau ce fichier !

Sinon, la syntaxe pour le changement de mot de passe a encore évolué...
Cf. https://stackoverflow.com/questions/50691977/how-to-reset-the-root-password-in-mysql-8-0-11#51186648

# mysql --defaults-file=/etc/mysql/debian.cnf mysql
mysql> UPDATE user SET authentication_string=PASSWORD('burp545') WHERE user='root';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('burp545') WHERE user='root'' at line 1

• dans /usr/share/eole/sbin/mysql_pwd.py, modifier (NB : vérifier l'hôte ?) :
  

  SQL_CODE="""ALTER USER IF EXISTS '{1}'@'localhost' IDENTIFIED BY '{0}';
  flush  privileges;""" 
  

• dans /usr/share/eole/applications/gen/eoleaaf.py (exemple) :
  

      db_handler.simple_query("CREATE DATABASE eoleaaf CHARACTER SET utf8;")
      db_handler.simple_query("CREATE USER IF NOT EXISTS 'eoleaaf'@'localhost';")
      db_handler.simple_query("GRANT ALL PRIVILEGES ON eoleaaf.* to 'eoleaaf'@'localhost';")
      db_handler.simple_query("USE eoleaaf ;")
  

Visiblement le mot clé MEMBER n'est plus autorisé...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'member TEXT,

Mais ça devrait (re)changer avec la version 8.0.19 : https://dev.mysql.com/doc/refman/8.0/en/keywords.html

C'est pas encore ça sur Horus :

2020-02-05T14:06:21.201738Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19-0ubuntu2) starting as process 5821
2020-02-05T14:06:21.996282Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('1') and data dictionary ('0').
2020-02-05T14:06:21.996897Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-02-05T14:06:21.997341Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-02-05T14:06:22.519504Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.19-0ubuntu2)  (Ubuntu).
2020-02-05T14:06:23.241337Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.

Visiblement, on ne peut plus passer "lower_case_table_names" à 1 sans tout réinitialiser : https://stackoverflow.com/questions/53103588/lower-case-table-names-1-on-ubuntu-18-04-doesnt-let-mysql-to-start