# MySQL avant version 8 - MariaDB # Privilèges pour `root`@`127.0.0.1` GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'mot_de_passe' WITH GRANT OPTION; # Privilèges pour `root`@`::1` GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' IDENTIFIED BY 'mot_de_passe' WITH GRANT OPTION; # Privilèges pour `root`@`localhost` GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'mot_de_passe' WITH GRANT OPTION; GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION; # MySQL version 8 - Privileges for `root` ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mot_de_passe' PASSWORD EXPIRE NEVER; ALTER USER 'root'@'localhost' DEFAULT ROLE ALL; GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION; GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION; CREATE USER IF NOT EXISTS 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'mot_de_passe' PASSWORD EXPIRE NEVER; ALTER USER IF EXISTS 'root'@'127.0.0.1' DEFAULT ROLE ALL; GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' WITH GRANT OPTION; CREATE USER IF NOT EXISTS 'root'@'::1' IDENTIFIED WITH mysql_native_password BY 'mot_de_passe' PASSWORD EXPIRE NEVER; ALTER USER IF EXISTS 'root'@'::1' DEFAULT ROLE ALL; GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' WITH GRANT OPTION;
# MySQL 8 - Changer mot de passe ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password'; ALTER USER IF EXISTS 'root'@'127.0.0.1' IDENTIFIED BY 'new_password'; ALTER USER IF EXISTS 'root'@'::1' IDENTIFIED BY 'new_password'; FLUSH PRIVILEGES;