GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' WITH GRANT OPTION; FLUSH PRIVILEGES; GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' WITH GRANT OPTION; FLUSH PRIVILEGES; quit;5 - Pour finir toujours dans la console entre la commande suivante : mysqladmin flush-privileges
skip-grant-tablesPour MySQL après 8.0.0
skip-grant-tables shared-memory=on
INSERT INTO mysql.user (User, Host, ssl_cipher, x509_issuer, x509_subject) VALUES('root','localhost','','',''), ('root','127.0.0.1','','',''), ('root','::1','','','');Si vous recréez l'utilisateur root, les points 7a. et 7b. sont à faire impérativement.
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; FLUSH PRIVILEGES;--- Versions MySQL APRÈS 5.7.0
UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPass'), password_expired = 'N' WHERE User = 'root'; FLUSH PRIVILEGES;--- Versions MySQL après 8.0.0
FLUSH PRIVILEGES; ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
UPDATE mysql.user SET Select_priv='Y', Insert_priv='Y', Update_priv='Y', Delete_priv='Y', Create_priv='Y', Drop_priv='Y', Reload_priv='Y', Shutdown_priv='Y', Process_priv='Y', File_priv='Y', Grant_priv='Y', References_priv='Y', Index_priv='Y', Alter_priv='Y', Show_db_priv='Y', Super_priv='Y', Create_tmp_table_priv='Y', Lock_tables_priv='Y', Execute_priv='Y', Repl_slave_priv='Y', Repl_client_priv='Y', Create_view_priv='Y', Show_view_priv='Y', Create_routine_priv='Y', Alter_routine_priv='Y', Create_user_priv='Y', Event_priv='Y', Trigger_priv='Y', Create_tablespace_priv='Y' WHERE User='root'; FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';Enregistrez le fichier. Cet exemple suppose que vous nommez le fichier C:\mysql-init.txt.
mysqld --init-file=C:\\mysql-init.txtAttention aux deux \\