# Privilèges pour `root`@`127.0.0.1` GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'mot_de_passe_en _clair' WITH GRANT OPTION; # Privilèges pour `root`@`::1` GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' IDENTIFIED BY 'mot_de_passe_en _clair' WITH GRANT OPTION; # Privilèges pour `root`@`localhost` GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'mot_de_passe_en _clair' WITH GRANT OPTION; GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION; # Exemple pour un utilisateur 'domi' avec droits standards à une base # Privilèges pour `domi`@`127.0.0.1` GRANT USAGE ON *.* TO 'domi'@'127.0.0.1' IDENTIFIED BY 'mot_de_passe_en _clair'; # Privilèges pour `domi`@`localhost` GRANT USAGE ON *.* TO 'domi'@'localhost' IDENTIFIED BY 'mot_de_passe_en _clair'; # Privilèges pour `domi`@`::1` GRANT USAGE ON *.* TO 'domi'@'::1' IDENTIFIED BY 'mot_de_passe_en _clair'; GRANT SELECT, INSERT, UPDATE, DELETE ON `nom_base`.* TO 'domi'@'127.0.0.1'; GRANT SELECT, INSERT, UPDATE, DELETE ON `nom_base`.* TO 'domi'@'localhost'; GRANT SELECT, INSERT, UPDATE, DELETE ON `nom_base`.* TO 'domi'@'::1';