Adding a User to a Database

RSS

Adding a User to a Database

Last updated September 13th, 2010

This article describes how to add users to a MySQL database.

Step by Step

  1. Click "All MySQL servers", then click the server that has the database and the user that you want to add to the database.

  2. Click on the name of the database you want to add the the user to.

  3. Click the "Add" button above the list of users, or the "Add user to database" option under the database name.

  4. Select the name of the user you wish to add to the database from the drop-down list. At this stage you can create a new user by clicking the "+ Create" button.

  5. For 'Host', type in the location of the MySQL database server. If you're unsure of what to type, leave it as 'localhost'.

  6. Select the privileges you wish to grant to the user on the given database. An explanation of the privileges available and their effects is available on the MySQL website.

Figure 1

Add user to database

Figure 2

Add user to database

Next: Removing a User from a Database →

Can we improve this article? Suggest an improvement to this article.

Suggest an Improvement

Thank you for helping us to improve this Knowledge Base article. Please type your suggestions below:

Still need help? Get in touch with us.

If you aren't able to find the help you need then please send us a question and we can help you further.