Setting up a User account and privileges
The root account has all privileges and should be used for administration purposes only. For security reasons, we are going to create a different user account with restricted access. On the home page click Privileges and then click Add a new User.
The password field is optional. You can chose a password yourself or have one generated for you. We are giving the user basic access, therefore we're only ticking the checkboxes that will give them basic rights. For instance, they will not be able to delete a database. Click Go to set the privileges. You can apply privileges to databases and tables and columns within a database.
Do you need help with MySQL? 



Leave a comment