Support

Search
Article

Creating & Managing Databases

« Go Back

Information

 
Description
Traditionally the web was filled with static HTML pages but moving forwards more and more website owners are moving towards a dynamically driven website. Database management with WebCentral is quite easy. In this article we'll separate it into two sections, the first for Linux/Windows hosting and the second the section being dedicated to cPanel.

Linux/Windows

  1. Log into the console
  2. Select Manage next to the domain/plan of your choosing
  3. On the left hand navigational bar select 'Database' under the Cloud Hosting category
Please refer to this picture as a reference:

User-added image

In this section you can create/manage databases. Simply select the database type of your choosing. Please note that Linux plans can't use MSSQL databases( Microsoft's Web Database variant)

At the bottom of the screen you'll see a section titled 'Current Databases'. If you have a MySQL database created you can then Administer it via PHPMyAdmin.

User-added image

For MSSQL databases you will need to connect to via a remote client such as MSSQL management studio.

cPanel

  1. Log into the console
  2. Select Manage next to the domain/plan of your choosing
  3. Select cPanel from the entry of the screen
  4. Scroll down to the Databases category
  5. Select MySQL Databses
Here you can create/manage database.

Please refer to this picture as a reference:

User-added image

Note: By default no users are assigned to the database. You will have to create a database user from this screen.

Once you have created a user, you may assign a user to a databases. You can specify privileges when assigning the user. It is possible to create and assign multiple users with varying access levels.

To manage PHPMyAdmin you'll need to go back to the cPanel Home screen. The cPanel  Home Screen is easily accessible from the top left hand corner. Once again scroll down to the 'Databases' category and this time select PHPMyAdmin.

Whilst this pretty much covers databases there are many more tips and tricks to databases for the experienced user. When connecting your dynamically driven website to your database always double check the connection string. Small things such as case sensitivity in your database password and incorrect host name can cause your website to not load.
Attachment 
Attachment 
Attachment 
Feedback

Was this article helpful?

   
Feedback

Please tell us how we can make this article more useful.

Characters Remaining: 255