How do I add/edit MySQL users?   (published: 6/18/2003 3:46:27 PM)
Article # 187
Title How do I add/edit MySQL users?

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 near 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.

More Information
Related information
Related download(s)
Did you find this useful?  [rate this article]
This article has been viewed 1134 times
Average reader rating 0 out of 10

©2003 NetFronts Inc.