DBMS/MySQL/Brief

Ajout d'un utilisateur

Utilisateur standard

Ajout d'un utilisateur et d'une base ou celui-ci aura tous les droits

CREATE DATABASE IF NOT EXISTS testdb ;

CREATE USER 'test'@'localhost' IDENTIFIED BY '***';
GRANT USAGE ON *.* TO 'test'@'localhost' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 
MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
GRANT ALL PRIVILEGES ON testdb.* TO 'test'@'localhost';

Utilisateur pour Réplication

GRANT REPLICATION SLAVE, SUPER, RELOAD, SELECT ON *.* TO myslave@'%' IDENTIFIED BY 'bre2005bis';
GRANT REPLICATION SLAVE, SUPER, RELOAD, SELECT ON *.* TO myslave@'localhost' IDENTIFIED BY 'bre2005bis';