$mysqli1 = new mysqli('127.0.0.1', $user, $password, $database1, $port); $mysqli2 = new mysqli('127.0.0.1', $user, $password, $database2, $port); $mysqli3 = new mysqli('127.0.0.1', $user, $password, $database3, $port);
# 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 8
# MySQL 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;Dans la console MySQL on peut également modifier directement la table user :
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; FLUSH PRIVILEGES;--- Versions MySQL APRÈS 5.7.0 mais avant 8.0.0
UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPass'), password_expired = 'N' WHERE User = 'root'; FLUSH PRIVILEGES;--- Versions MySQL après 8.0.0
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'; FLUSH PRIVILEGES;