Sql

De Linuxmemo.

• ajouter un utilisateur:

GRANT ALL PRIVILEGES ON base.* TO 'user'@'localhost' IDENTIFIED BY 'un_mot_de_passe' WITH GRANT OPTION;

• recharger les droits:

GRANT RELOAD,PROCESS ON *.* TO 'user'@'localhost';
GRANT USAGE ON *.* TO 'user'@'localhost';