我如何在基本的SQL、MySQL特定语言或PHP中找到我具有最低读取权限的数据库?
SHOW GRANTS;它将给出类似于以下输出:
root@(none)~> show grants; +---------------------------------------------------------------------+ | Grants for root@localhost | +---------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION | +---------------------------------------------------------------------+ 1 row in set (0.00 sec)这在手册中有记录。