Database users

From ISPWiki
Jump to: navigation, search

In the "Database users" module you can change permissions and passwords, add new users (MySQL). Depending on a database type, user management functions may vary.

MysQL database users

Module«Databases»
T-back.png Back to the previous page
T-bullet.gif View a list of users
T-new.png Create new user
T-edit.png Edit user parameters
T-delete.png Delete user

View a list of users

  • Name - database user name.
  • Privileges - user access permissions:
P-read.png - the user is able to read, edit and delete data from the database (select, delete, insert, update).
P-write.png - the user is able to edit database structure (create, drop, alter, index).
P-manage.png - the user is able to execute other SQL functions (grant, refer, lock, temp).

Create new user

To create a new user, click the "New" icon and fill out the form:

Module«Data bases»
  • User - select an existing database user or add a new user.
  • Username - enter a name for the database user.
  • Password - enter a password to access the database.
  • Retype password - retype the password to ensure that it has been entered correctly
  • Remote access - check the box to allow the user to access the database from a remote computer. If the box is not selected only local access will be allowed.
  • List of IP addresses - enter the IP address that will be allowed to access the database. You can enter a single IP-address, (123.45.67.89), a mask (123.45.67.89/24) or a range (123.45.67.89-123.45.67.90).
  • Database access - SQL commands to work with data that are available to the user (SELECT, INSERT, UPDATE, DELETE).
  • Structure access - SQL commands to work with data structure that are available to the user (CREATE, DROP, ALTER, INDEX).
  • Other - other SQL commands available to the user (GRANT, REFERENCES, LOCK).

Edit user parameters

To edit a database user, locate the user you wish to edit, click the "Edit" icon and modify the settings you want to change.

Delete user

To delete a database user, select it from the list and click the "Delete" icon. Confirm that you want to delete the selected database user by clicking "OK" in the following window.

PostreSQL database users

Module«Databases»
T-edit.png Edit user parameters

To create a new user, click the "New" icon and fill out the form:

Module«Databases users»
  • Username - enter a name for the database user.
  • Password - enter a password to access the database.
  • Retype password - retype the password to ensure that it has been entered correctly
  • Remote access - check the box to allow the user to access the database from a remote computer. If the box is not selected only local access will be allowed.
  • List of IP addresses - enter the IP address that will be allowed to access the database. You can enter a single IP-address, (123.45.67.89), a mask (123.45.67.89/24) or a range (123.45.67.89-123.45.67.90).