Managing User Permissions
Within phpMyAdmin, user management is controlled via the Privileges link from the main page. Users can be created, edited, and removed.
Creating a new user
To create a new user, click the Add a new user link near the bottom of the Privileges page (you must be a "superuser", e.g., user "root"). Use the textboxes and drop-downs to configure the user to your particular needs. You can then select whether to create a database for that user and grant specific global privileges. Once you've created the user (by clicking Go), you can define that user's permissions on a specific database (don't grant global privileges in that case). In general, users do not need any global privileges (other than USAGE), only permissions for their specific database.
Editing an existing user
To edit an existing user, simply click the pencil icon (
) to the right of that user in the Privileges page. You can then edit their global- and database-specific privileges, change their password, or even copy those privileges to a new user.
) to the right of that user in the Privileges page. You can then edit their global- and database-specific privileges, change their password, or even copy those privileges to a new user.
Deleting a user
From the Privileges page, check the checkbox for the user you wish to remove, select whether or not to also remove any databases of the same name (if they exist), and click Go.
Assigning privileges to user for a specific database
Users are assigned to databases by editing the user record (from the Privileges link on the home page) not from within the Privileges link under the table. If you are creating a user specifically for a given table you will have to create the user first (with no global privileges) and then go back and edit that user to add the table and privileges for the individual table.
No comments:
Post a Comment
Thank you