Within Bankoi WebHost Panel there is the ability to create multiple MySQL and PostgreSQL databases as well as multiple users within each database. Also, directly accessible via Bankoi WebHost Panel, are the links to PhpMyAdmin and PhpPGAdmin, the PHP interface applications that abstract mysql or postgresql into a web-based administration tool, allowing you to sort, edit, and create tables within a given database. Database limits are set through domain preferences and database disk usage is calculated within the domain's total allotted disk space.
Searching the Databases List
Bankoi WebHost Panel allows you to search the Databases List for a certain pattern. It may help you in case you have a great number of databases in the system and you need to work with a particular one. To search in the Database List:
Select the input field next to the SEARCH button and type in the pattern string.
Click the SEARCH button.
If there were any items found matching the pattern string entered, they will all be displayed in the form of the reduced Database List.
If no matches were found it will be so stated.
The button SHOW ALL will revert to displaying the whole list of databases.
There is also another way to ease the process of working with a large list of databases. An option of sorting the list by several various parameters is made available to you. You can sort the Database List by Type and Database Name. To sort the list by a certain parameter in ascending or descending order, click on the name of the parameter. An arrow will appear indicating the order of sorting: down for descending order, up for ascending.
Creating a New Database
At the Domain administration page, click the DATABASES button. The Databases Management page appears.
To add a new database select the Database name field, enter the desired name, select the type from the drop-down list and click ADD. The Database Editing page appears.
To add database users to the newly created database, click ADD. The Database User Management page appears.
Enter the user name into Database user name text box, specify a password in the New Password text box, and then enter it again in the Confirm Password text box. Select UPDATE to complete the creation of the new user. Selecting UP LEVEL will ignore all entries and return to the Database Editing page making no changes.
Once you have completed the creation of the new database and its users select UP LEVEL to return to the Database Management page.
To add further databases, follow the steps described above. To return to the Domain Administration page select UP LEVEL.
Editing an Existing Database
At the Domain administration page, click the DATABASES button. The Databases Management page appears.
Click on the database name that you wish to edit. The Database Editing page appears.
To add database users to the selected database, click ADD. The Database User Management page appears.
Specify user name, enter new password in the New Password text box, and then enter it again in the Confirm Password text box. Select UPDATE to complete the creation of the new user. Selecting UP LEVEL will ignore all entries and return to the Database Editing page making no changes.
To edit the password of an existing database user, select the user from the database user list. The Database User Management page appears.
To delete existing database users select the users that you wish to delete using the checkboxes on the right of the page and click REMOVE SELECTED. You will be asked for confirmation prior to final deletion of the selected users.
To access and/or edit database content you can do so using the PHPMYADMIN option for the MySQL type database or PHPPGADMIN for the PostgreSQL database. These options can be used to make content edits to your existing databases.
Once you have completed all edits of the database and its users select UP LEVEL to return to the Database Management page.
To delete existing databases select the databases that you wish to delete using the checkboxes on the right of the page and click REMOVE SELECTED. You will be asked for confirmation prior to final deletion of the selected databases.
To edit further databases, follow the steps described above. To return to the Domain Administration page click UP LEVEL.