Plesk Web Hosting 6.0 ADMINISTRATOR MANUAL > Domain Administration

Databases Management

contained by Plesk Web Hosting there is the ability to create multiple MySQL and PostgreSQL databases as well as multiple users contained by each database. Also, directly accessible via Plesk Web Hosting , 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 contained by a given database. Database limits are set through domain preferences and database disk usage is calculated contained by the domain's total allotted disk space.

Searching the Databases List

Plesk Web Hosting 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:

  1. Select the input field next to the SEARCH button and type in the pattern string.

  2. Click the SEARCH button.

  3. If there were any items found matching the pattern string entered, they will all be displayed in the form of the reduced Database List.

  4. If no matches were found it will be so stated.

  5. 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

  1. At the Domain administration page, click the DATABASES button. The Databases Management page appears.

  2. 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.

  3. To add database users to the newly created database, click ADD. The Database User Management page appears.

  4. 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.

  5. Once you have completed the creation of the new database and its users select UP LEVEL to return to the Database Management page.

  6. To add further databases, follow the steps described above. To return to the Domain Administration page select UP LEVEL.

Editing an Existing Database

  1. At the Domain administration page, click the DATABASES button. The Databases Management page appears.

  2. Click on the database name that you wish to edit. The Database Editing page appears.

  3. To add database users to the selected database, click ADD. The Database User Management page appears.

  4. 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.

  5. To edit the password of an existing database user, select the user from the database user list. The Database User Management page appears.

  6. 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.

  7. 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.

  8. Once you have completed all edits of the database and its users select UP LEVEL to return to the Database Management page.

  9. 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.

  10. To edit further databases, follow the steps described above. To return to the Domain Administration page click UP LEVEL.


to top 

Web Hosting is made easy with the Pleask on-line hosting Controller.
Pleask Web Hosting Control panel Documents Index

Pleask Web Hosting Control Panel Document's Index1

Earth First Professional Affordable Reseller Web Hosting Services
Earth first Provides web hosting plans that are affordable . Top Service Guaranteed
Reseller web hosting plans available.. Click the link above to purchase web-hosting now
What is Hosting - Is it all Web Hosting the same? - Different Hosting Technologies - Hosting Issues to watch out for
Choosing a Web Host Free Web Hosting Services - Web Site Security - About the Web Hosting Report -Web Hosting Report Home
Proud to Sponsor Online Yoga Free Videos Yoga Meditation

For more information on this Quality Web hosting control panel please go to http://www.Pleask.com