Glossary    Contact Us
Search  
   
Browse by Category
Web Hosting help - HelpingHost.com .: Your Database .: MySQL .: Adding MySQL users and granting them privileges

Adding MySQL users and granting them privileges

To follow the steps below, you need to login to your hosting control panel first!

Please click here for a link to your hosting control Panel

 

Here you will learn how to add new users to an existing MySQL database.

  1. Select MySQL DBs in the Databases menu.
  2. Click the MySQL Database or the Edit icon on its right:
  3. On the form that shows, click the Add icon against the Database users field.
  4. Fill the following form:

    Each user role involves a fixed set of privileges on this specific database:

    Role: Set of privileges:
    read select
    read/write select, insert, delete, update
    dba select, insert, update, drop, create, alter, index

     
  5. Click the Add or Grant button and agree to additional charges.
  6. To edit privileges, click the Edit icon next to the user. You will be brought to the Privilege Maintenance page.

  7. Check or uncheck the desired privileges and press the Submit button.

Note:For more information on MySQL access privileges, please refer to www.mysql.com.

IMPORTANT: any changes in user privileges will be applied to the whole selected database.


How helpful was this article to you?

Related Articles

article Creating a MySQL Database and Its Users
(No rating)  March 6, 2004    Views: 1763   
article Adding a Domain to your Account
(No rating)  March 8, 2004    Views: 2859   
article Editing PgSQL Databases and User Privileges
(No rating)  March 6, 2004    Views: 1744   

User Comments

Add Comment
No comments have been posted.


.: Powered by Lore 1.5.1
(c) HelpingHost.com 2002-2005