# Privilèges pour `root`@`127.0.0.1` GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'MOTDEPASSE' WITH GRANT OPTION; # Privilèges pour `root`@`::1` GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' IDENTIFIED BY 'MOTDEPASSE' WITH GRANT OPTION; # Privilèges pour `root`@`localhost` GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'MOTDEPASSE' WITH GRANT OPTION; GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION;-- Créer un utilisateur
# Privilèges pour `username`@`127.0.0.1` GRANT USAGE ON *.* TO 'username'@'127.0.0.1' IDENTIFIED BY 'MOTDEPASSE'; # Privilèges pour `username`@`localhost` GRANT USAGE ON *.* TO 'username'@'localhost' IDENTIFIED BY 'MOTDEPASSE'; # Privilèges pour `username`@`::1` GRANT USAGE ON *.* TO 'username'@'::1' IDENTIFIED BY 'MOTDEPASSE';