Jump to: Index | MySQL | Creating Databases You can adjust the permissions of database users you have setup. This is useful if you are running PHP scripts that only need to read the database - you can reduce the risk of someone using the scripts to delete or change your data. To adjust privileges, login to the Management Interface:
Click on the 'Databases' link, then the 'Edit Users' link. You should see a page similar to this:
Choose the user you would like to adjust privileges for, then click the 'Adjust Privileges' link. The privileges available to grant to a user are displayed. Check a box to grant a privilege, and clear a box to revoke a privilege. When you are finished click 'Save changes'. A description of what each privilege does can be found in the MySQL reference manual. |
|||||
|
|||||
