Auflisten von Schemas, Tabellen, Grants etc:
[cc lang="sql"]show schemas;
show tables;
show grants for user@localhost;[/cc]
Rechte hinzufuegen
[cc lang="sql"]grant all privileges on schema.* to username@localhost identified by ‘passwort’;[/cc]
Rechte entfernen
[cc lang="sql"]– einzeln
revoke all privileges on schema.* from user@localhost;
– alle rechte
drop user user@localhost;[/cc]