mysqld.exe --initialize-insecureLe dossier data, comprenant les bases mysql va être recréé ainsi que l'utilisateur root sans mot de passe.
# Privilèges pour `root`@`127.0.0.1` GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'mot-de-passe-n°1' WITH GRANT OPTION; # Privilèges pour `root`@`::1` GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' IDENTIFIED BY 'mot-de-passe-n°1' WITH GRANT OPTION; # Privilèges pour `root`@`localhost` GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'mot-de-passe-n°1' WITH GRANT OPTION; GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION;Dans cet exemple, le mot de passe est en clair, mais on pourrait mettre le codage mysql dudit mot de passe en remplaçant :
IDENTIFIED BY 'mot-de-passe-n°1'par
IDENTIFIED BY PASSWORD 'codage-mysql-du-mot-de-passe-n°1'
# Privilèges pour `user1`@`127.0.0.1` GRANT USAGE ON *.* TO 'user1'@'127.0.0.1' IDENTIFIED BY 'mot-de-passe-n°2'; # Privilèges pour `user1`@`localhost` GRANT USAGE ON *.* TO 'user1'@'localhost' IDENTIFIED BY 'mot-de-passe-n°2'; # Privilèges pour `user1`@`::1` GRANT USAGE ON *.* TO 'user1'@'::1' IDENTIFIED BY 'mot-de-passe-n°2'; GRANT SELECT, INSERT, UPDATE, DELETE ON `database`.* TO 'user1'@'localhost';