ACCESS CONTROL

Use this function only if you have clear understanding how the access system of Mysql works. For detailed information refer to the  online Mysql manual on http://www.mysql.com

This function is used to create and modify user accounts. It is assumed you have appropriate privileges to grant and revoke privileges, select from Mysql scope tables and modify them.

Pic. 1

To grant or revoke privileges on existing accounts select the accounts to be modified from the account list. This list is shown only if you have "SELECT" privilege on mysql database. Then hit GRANT or REVOKE button.

Pic. 2

Select Global, Database, Table or Column privilege or any combination of them. The picture below shows all these privileges  selected. Clicking on the corresponding button you will select - deselect the given privilege group. User account list is shown on the bottom of the page.

Pic. 3

If you need to apply, for example, Database and Table privileges to the same group of accounts, you can do it, but it is recommended to Grant/Revoke them one by one beginning from the most meaningful (Database) and finishing with less meaningful (Table) in order to avoid confusing

• Global Privileges provide the access to ALL the databases on the given Mysql server, including the same Mysql  database containing scope tables. In order to grant (or revoke) Global privileges select the desired privilege types.
   
• Database privileges provide the access to all the tables of the selected database(s). To grant these privileges select one or more databases from the database list or type database names, separated by comma in the `otherDB' form. Here you can use wildcards `_' that means `Any character’ and `%' that means 'Any string' in the name of a database. Backslash character `\' can be used to escape the 'underscore' in the database name (in this case the underscore will be treated as a part of database name rather than wildcard).
  
  VARIABLE `?’ - question mark gives you the ability to grant (revoke) privileges to databases whose name contains the name of the user. So that, if you type a string: ?abc, ?_db , the variable `?’ will be substituted with user name for each user from the account list:
  For example:
  user john@localhost (the user `john' on `localhost') will be granted privileges on databases `johnabc'  and `john_db',
  user james@localhost will be granted the selected privileges on the databases `jamesabc' and `james_db'.
   
• Table privileges provide the access to all the columns of the selected table. To grant or revoke privileges select a database from the database list and click the arrow beside if the page will not be reloaded by itself. Then select one or more table from the table list and select the privilege types
   
• Column privileges provide the access to the selected columns. Select a database, then (the page should be reloaded,  otherwise hit the arrow) select a table (the page should be reloaded again). The list of the existing columns will be  displayed. Select columns (one or more) and privilege types.

The “REQUIRE clause” and “Resource options” are supported by MySQL 4.0.0 or higher. The correcponding form fields appear on any privilege group: GLOBAL, DATABASE, TABLE or COLUMN. If two or more privilege groups are active, the most meaningful group will contain “REQUIRE clause” and “Resource options” form field.

You may check `Preview queries' (recommended) in order to preview all generated queries, and click `GRANT' button (or REVOKE if you selected to revoke on the previous page).

On the next page you may preview or edit any query and hit `Confirm' button. You may return back (clicking `Back') in order to correct your selections.

CREATE NEW ACCOUNTS:

Type the number of accounts you wish to create (see Pic. 1) . If all new accounts will be granted privileges on the same host you may want to type the name of this host in `Use this host name for all accounts', so that this host name will be applied to all accounts. Then click `NEXT >>' and complete the form with user names and passwords, correct the host names if necessary.

After that hit `NEXT >>' button again, and you will be transferred to the page as shown on the Picture 2. Further procedure is the same as described for `GRANT' privileges above.

CHANGE PASSWORD

• For selected user:
  Select the user from the account list and type a new password in `NEW PASSWORD' form. Check `For selected user'.   Click `CHANGE PASSWORD' to apply.
• Your own password:
  Type new password, check `For myself' and click `NEW PASSWORD'.

NOTES:

If you do not have root access the account list will be empty. You will be prompted to enter user@host name in the form that must appear in such a case:

Previous TOC Next

 

 [Home] [Products] [Screenshots] [Demo] [Manual] [Account] [Order] [Contact us]

Copyright © 2003 cgiscriptshop.com