Installation MySQL

Installation MySQL - SQL/NoSQL - Programmation

Marsh Posté le 13-05-2020 à 13:07:57    

Bonjour,
 
J'ai tenté d'installer Mysql sur mon windows 10 pro IIS avec Mysqlinstaller community mais j'obtiens invariablement cette erreur :
 
Beginning configuration step: Initializing database (may take a long time)
 
Deleting the data directory from a previous (failed) configuration...
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 5.7.30...
Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...
2020-05-12T17:20:11.078006Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-05-12T17:20:11.079574Z 0 [Warning] '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.
2020-05-12T17:20:11.092328Z 0 [ERROR] InnoDB: Unable to create temporary file; errno: 0
2020-05-12T17:20:11.093114Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-05-12T17:20:11.093251Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-05-12T17:20:11.093368Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-05-12T17:20:11.093487Z 0 [ERROR] Failed to initialize builtin plugins.
2020-05-12T17:20:11.093589Z 0 [ERROR] Aborting
Process for mysqld, with ID 6844, was run successfully and exited with code 1.
Failed to start process for MySQL Server 5.7.30.
Database initialization failed.
Ended configuration step: Initializing database (may take a long time)
 
J'ai tenté MySql 8.0.20 et 5.7.30 les deux en 64bits
 
Une idée ? Car là je nage...


---------------
planuldep | Association pêche à la Sempé
Reply

Marsh Posté le 13-05-2020 à 13:07:57   

Reply

Marsh Posté le 14-05-2020 à 19:16:23    

Je pense qu'il faut rajouter la ligne suivante dans le fichier de configuration de MySQL (my.ini ou my_source.ini) :
innodb_flush_method=normal
 
Plus de détails sur https://stackoverflow.com/questions [...] he-service


---------------
Astres, outil de help-desk GPL : http://sourceforge.net/projects/astres, ICARE, gestion de conf : http://sourceforge.net/projects/icare, Outil Planeta Calandreta : https://framalibre.org/content/planeta-calandreta
Reply

Marsh Posté le 14-05-2020 à 19:39:54    

Merci je vais tester ça :)

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed