Auflisten von Schemas, Tabellen, Grants etc:

1
2
3
SHOW schemas;
SHOW TABLES;
SHOW grants FOR user@localhost;

Rechte hinzufuegen

1
GRANT ALL privileges ON schema.* TO username@localhost IDENTIFIED BY 'passwort';

Rechte entfernen

1
2
3
4
-- einzeln
REVOKE ALL privileges ON schema.* FROM user@localhost;
-- alle rechte
DROP user user@localhost;