Database is a set of data organized by means of the database management system.
This module is designed to manage databases. You can add a new database, edit the parameters of existing databases, download a dump, create a list of users of a particular database.
Viewing the list of databases
- Name - the name of the database.
- Owner - the name of the control panel user whose disk quota includes the database. This column is not displayed on the ISPmanager user level.
- Server address.
- Database server type and version - database management server.
- Number of users - number of users in the database.
- Size (MB) - size of disk space (in megabytes) occupied by database files.
Creation of a new database
To create a new database, click the Create button and fill out the following form:
- Name - Name of the database
- Owner - Specify the name of the user who will own the database. This field is not available on the ISPmanager user level.
- Database Server - select the database management server.
- Encoding - the default encoding in which data will be stored.
- User - select an existing user or create a new one.
- New user - specify the name of the new database user. The name can contain letters of the Latin alphabet, numbers and the "_" sign. The name must be unique within the server.
- Password - the password for access to the database. The password must not be empty. Too short and simple passwords are not recommended.
- Confirm - repeat the password typed in the previous field.
- Remote access - check the box to allow this user to access his databases from other servers or workstations.
- List of IP addresses - specify the IP addresses from which the user can access his databases.
Edit Database Settings
To change the owner of an existing database, select the database of interest in the list and click the Edit button. In the form that appears, you can change only the name of the database.
Removing a database
To delete a database, select it from the list and press the Delete button. After pressing the OK button, the selected database will be deleted.
Dump database
With this function you can download a database dump to your computer. To do this, select the database and click the Download button.
If you have difficulties in setting up or have any additional questions, you can always contact our support team via Ticket system.