Article

How to Create & Manage Databases

« Go Back

Information

 
TitleHow to Create & Manage Databases
Description
Please Note: This guide refers to our Cloud & cPanel Hosting Plans

Creating & Managing your databases are easy with Melbourne IT. In this guide we have included the steps for both our Cloud & cPanel hosting plans. Databases are what drive dynamic websites

Cloud

  1. Log into your MyAccount
  2. Under Manage Services, click View Webhosting Services
  3. On the next page, click on the domain name’s Cloud Hosting product
  4. On the next page, click Manage Service
  5. A new window will open
  6. Under Cloud Hosting on the navigational bar click Database (under Cloud Hosting)
This is the management interface for your databases. Depending your plan you will have a limit to the amount of databases that can be created. It's quite easy to create a database, simply enter a name for your database and select the type. Most commonly people use MySQL.
 
Please Note: All of our databases for cloud are suffixed with _domain_extension

After you have created a database database management options become available. We have three fields available to us.
  • Credentials

    Displays Host, Username & Password details for your database. You can also reset your password via this interface. Please be aware that your host will only work if you have delegated your domain to Cloud's nameservers or have created the appropriate CNAME. 

  • DSN

    Displays sample database connection strings in various languages. This is a way to visually assist you when configuring your database to connect to your website.
  • PHPMyAdmin

    PHPMyAdmin is a web based management interfact for MySQL databases. It allows you to import/export & further manipulate your database. PHPMyAdmin is a common tool used by developers to interact with MySQL databases
 

cPanel

  1. Log into your MyAccount
  2. Under Manage Services, click View Webhosting Services
  3. On the next page, click on the domain name’s cPanel product
  4. On the next page, click Manage Service
  5. A new window will open
  6. Click cPanel Login
  7. Now that your inside of cPanel scroll down to the Databases category.
Inside of the databases category we have a few options, the two important tools in this category are MySQL® Databases & phpMyAdmin.

MySQL® Databases

On this page you can see a breakdown of your databases.

In the Create New Database section you can easily create a new MySQL database. After you have created a database you will need to create a user for it.

Under MySQL Users simply create the user of your choice. You will have to specify a username & Password.

Next we need to assign the user to a database. In the Add User to Database section select your user of choice and database then click Add. A new page will load giving you the option to modify permissions & access levels. You also have the ability to create multiple users for one database and set adjust their permissions accordingly.

Please Note: Only MySQL databases are available on cPanel. Also please be advised that every database is prefixed by your cPanel user id example0000_

PHPMyAdmin

PHPMyAdmin is a tool designed to manage and interact with your MySQL database. After you have created your database. Upon entering PHPMyAdmin you should see your database displayed on the left hand side.

After selecting your database you now have the option to manipulate tables & entries as well as Import / Export your database.


 
Attachment 
Attachment 
Feedback

Was this article helpful?

   
Feedback

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

Characters Remaining: 255