Create database and user

This command opens a dialog window for creating a database and user. This can usually be done using the tools delivered by the producer along with the database server, but the following method is the easiest:

Enter the login data to the administrator account (root, sa, etc.) in the upper pert of the window. Choose the server address (usually localhost for the local connection or IP server address for local network connection). Select the database type.

In next section, enter the name of the database you want to create or remove. For some types of databases, it is also necessary to enter the database size and location of the data files. The pre-set database size is 1GB, the pre-set path to the data files is taken from the Windows system registers.

Enter the name and password for the user account you are creating in the last section.

Note

We recommend setting the same name of user and database. If the names are different, you will have to adjust the configuration database file..

Note

When creating a user, you must also enter the database name because the user's right to the database is created automatically after the account creation.