Ispmanager 6 lite, pro, host documentation

/
/
/
/
How to work with databases in the panel

How to work with databases in the panel

This guide describes:

Create a database

To create a database (DB):

  1. In the Main Menu, select Databases.
  2. On the form that opens, click Create a database.
  3. Fill in all the fields on the New database form that opens:
    • Name – database name;
    • Owner – control panel user who will own the created database;
    • Database server – database management server (if an alternative version is required - see Create a database server);
    • Encoding – select the default encoding that will be used for this database;
    • User – select from the list or create a new user:
      • Username;
      • Password;
    • Remote access (checkbox) – allow the database user to access from remote servers (available if this option is selected on the database server).
  4. After filling in all the fields, click Create.

The database will be created and added to the Databases form.

For more info see Database management systems.

Create a database server

By default, MySQL database management server is pre–installed in the panel.

If an alternative DBMS or version is needed, it should be installed.

Supported alternative MySQL DBMS:

  • MySQL 5.5;
  • MySQL 5.6;
  • MySQL 5.7;
  • MySQL 8.0;
  • MariaDB 10.0;
  • MariaDB 10.1;
  • MariaDB 10.2;
  • MariaDB 10.3;
  • MariaDB 10.4;
  • MariaDB 10.5;
  • MariaDB 10.6;
  • MariaDB 10.7;
  • MariaDB 10.8;
  • MariaDB 10.9;
  • MariaDB 10.10;
  • Percona Server for MySQL 5.6;
  • Percona Server for MySQL 5.7;
  • Percona Server for MySQL 8.0.
The alternative version is installed via Docker. If Docker has not been installed before, Docker will be installed in the panel first, and then the container with the corresponding DBMS will be loaded.

To install an alternative DBMS:

  1. In the Main Menu, select Databases.
  2. On the form that opens, click Database servers.
  3. On the form that opens, click Create server.
  4. Fill in the fields on the opened New database server form:
    • Name – database server name;
    • Type – database management server type;
    • Action – select an action (installation/connection) for the MySQL server;
    • Password – user password for administrative access to the database server;
    • Install Web scripts (checkbox) - the server will be used by default to install web scripts;
    • Remote access (checkbox) - enables remote access to the database server;
    • IP-address– select the IP address that the MySQL server will work with;
  5. After filling in all the fields, click Create.

The database server will be created and added to the list on the form.

Remote access is implemented only for MySQL-server.

For more info, see Database management systems.

In this article