Database servers (ISPmanager)

From ISPWiki

Jump to: navigation, search

A database server is used to manage databases, and performs such operations as data analysis, storage, data manipulation, archiving, and other non-user specific tasks.

You can integrate your control panel with database servers on local or remote servers. You may register a new database sever and cancel its registration, if necessary.
Module «Database servers»

Image:T-bullet.gif View a list of database servers
Image:T-new.png Register new database server
Image:T-edit.png Edit database server parameters
Image:T-delete.png Cancel registration

View a list of database servers

  • Name - name of the database server.
  • Type - type of the database server, such as MySQL, Pastgres.
  • IP-address - IP-address of the remote server, where the database server is located. "localhost" is displayed if you choose "local connections'.

Register new database server

To register a new database server, click the "New" icon and fill out the form:

Module &laquoDatabase server»
  • Name - enter the name for the server you want to add.
  • Database type - enter a database type, such as MySQL, Postgres.
  • Connection type - choose a server's location ("Local" or "Remote"). Depending on this parameter the form fields will vary.
  • IP-address - if you choose a remote databases server, enter its IP-address.
  • Username - enter a database's username to access the database server.
  • Password - enter a password to access the database server.
  • Encoding - enter a default encoding for the tables on MySQL databases servers.
  • Path to the socket file - enter the path to the socket file of the local MySQL server, such as /tmp/mysql.sock. If Pstgres is used, enter the directory where the socket file is located. Leave the field blank if you want to use a default value in the path mysql.sock parameter of the control panel's configuration file.
  • Access privileges - choose a level of access to the databases server (you can list the users who will be allowed or not allowed to access the database server, or you can grant access to all your users.
  • Users - provide usernames who will be allowed to access the newly created database server.

Edit database server parameters

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

Cancel registration

To cancel registration of the database server, select it from the list and click the "Delete" icon. Confirm that you want to cancel registration of the selected database by clicking OK in the following form.

If you cancel registration of the databases server, the databases that were created through the control panel won't be deleted.

Was this helpful? Yes | No
Personal tools