Adding users to a MySQL database

After you have created a user and a database you must then assign a user to that database in order to access it. You must also choose which privileges to grant the user for that database. This demonstration shows how to add a user to a MySQL database and define that user's privileges.

Simply follow the simple instructions below.

1. Select the MySQL Databases link.
   Top of page
2. Complete the following instructions.
   • Select the user you wish to assign to the database,
   • Select the database you wish to assign the user to,
   • Leaving the tick in the box on the left grants a user access to all privileges on the database OR tick the appropriate boxes on the right to choose specific privileges for a user,
   • Click the Add User To Database button.
   
   Top of page
3. Well Done! You have successfully added a user to a MySQL Database.
   Top of page