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
 

MSSQL Database Managment

Unfortunately, a web interface is not available for MSSQL database administration. Customers using an MSSQL database will need to connect to the MSSQL server using third party software such as Microsoft SQL Server Management Studio ExpressMicrosoft® SQL Server® 2008 Management Studio Express or EMS SQL Manager for SQL Server.

MSSQL Database Details

Your MSSQL Details can be viewed in your Domain Level Console.

  1.  Login to your Domain Level console, Under the Windows Hosting heading, click Database.
    User-added image
  2. You can Create a new Database in this section and also view your Current databases.
    User-added image
    User-added image
  3. Click the View hyperlinks along the Database Name lines will provide you with the Database Credentials.
     User-added image
  4. The Database Credentials Area is where you can find the associated Database Host and reset Database User passwords.


MSSQL version

We support MSSQL 2005, 2008 and 2012 databases. To determine which version of MSSQL your database is running on follow the below instructions.

  1. Log into your Account
  2. Manage the domain you want to make changes to
  3. Click the Database icon
  4. Your database host will be one of the following:
    Database ServerPre Migration HostnamePost Migration HostnameExample Hostname
    MSSQL 2005mssql2005.partnerconsole.netbne3-0006q.server-web.commssql2005.your-domain.tld
    MSSQL 2008mssql2008.partnerconsole.netbne3-0006q.server-web.commssql2001.your-domain.tld
    MSSQL 2012mssql2012.partnerconsole.netbne3-0016q.server-web.commssql2012.your-domain.tld

If your domain is not yet delegated to our name servers, using you-domain.tld in the connection settings won't work. If you wish to connect to the MSSQL database prior to delegating your domain name to our name servers, replace your-domain.tld with partnerconsole.net.

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