About the issue of BBS moderator authorization
To the heroes asked a basic question, BBS Forum Registration User table (MySQL database) contains each user name and user password, when authorizing a user as moderator, is it necessary to the Mysql.user table (this table is not a registered user table) to save the user's user name and password?
------Solution--------------------
Master=1 or 2 or 3 or 4 ...
This depends on how your membership management system is designed. For example I above this 1 can be Administrator 2 can be a deputy administrator ... To be the members of the rank of the different
If you also need to extend other permissions, then you can separate a table to put the detailed permissions function
------Solution--------------------
References:
MySQL default installation will have a root user, saved in the Mysql.user table. If you create a new user, it will also be saved in the Mysql.user table.
BBS has a registered user table, if the registered user to grant permission to a user list, is it necessary to create a new user information to the Mysql.user table? For example, grant Delete, update on a database table to the user name @: Identifie ...
Didn't pay attention to see the original you asked is the MySQL user ...
Don't need
------Solution--------------------
Your own table design can be (isadmin field), where permissions are required, program control.
------Solution--------------------
No need!
Mysql.user is designed to save the user who connects to the database.