Home  Home  Home  Kontakt  Kontakt  Kontakt  Inhalt  Inhalt  Inhalt  Blog  Blog  Blog  FAQ  FAQ  FAQ

Benutzer, Rechte

-- Zeige alle Rechte (des aktuellen Users), resp eines bestimmten
SHOW GRANTS;
SHOW GRANTS FOR user;
SELECT
        user
      , host
      , password
  FROM mysql.user
  ORDER BY user, password, host
;
SELECT
        host
      , db
      , user
  FROM mysql.db
  ORDER BY db, host, user
;
SELECT *
  FROM mysql.tables_priv
  ORDER BY db, host
;