Sql
De Linuxmemo.
(Différences entre les versions)
| Ligne 3 : | Ligne 3 : | ||
* ajouter un utilisateur: | * ajouter un utilisateur: | ||
GRANT ALL PRIVILEGES ON base.* TO 'user'@'localhost' IDENTIFIED BY 'un_mot_de_passe' WITH GRANT OPTION; | 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'; | ||
Version du 24 mars 2012 à 08:04
- 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';
