MySQL中的权限系统是通过一系列的表来实现的,这些表存储在mysql数据库中。以下是与权限相关的几个主要表及其作用:
SELECT User, Host FROM mysql.user;SELECT User, Host, Db FROM mysql.db WHERE Db = 'your_database_name';SELECT User, Host, Db, Table_name, Table_priv FROM mysql.tables_priv WHERE Db = 'your_database_name';SELECT User, Host, Db, Table_name, Column_name, Column_priv FROM mysql.columns_priv WHERE Db = 'your_database_name';SELECT User, Host, Db, Routine_name, Routine_type, Proc_priv FROM mysql.procs_priv;GRANT语句为用户授予相应的权限。GRANT语句为用户授予相应的权限。FLUSH PRIVILEGES;命令刷新权限。