Showing posts with label Databases. Show all posts
Showing posts with label Databases. Show all posts

Monday, October 14, 2013

How to Find the Hostname of a Database Server?

Some web software for a website needs the value of the hostname of a database server for it to be installed to a web server, such as WordPress (software) which needs MySQL database connection details. The MySQL database hostname will usually be "localhost" on most web hosting companies, but not always!

The name could be simply "localhost" if your database is local to your web server or to the server on your hosting provider. But if your database is external to your web server or to your hosting server, then you or your hosting provider would need to put the name of that database.

Most Hosting Providers

To be sure about your database hostname, here we will going to find the exact hostname of MySQL server through the application called phpMyAdmin, version 4.0.5:

  1. First, log in to your control panel.
  2. Find the PHP application "phpMyAdmin":
    The Application 'phpMyAdmin' on the Home of cPanel
    • On the Databases heading section if you're using cPanel.
    • Or on the Advanced Features heading section if you're using DirectAdmin Web Control Panel.
    And then click it to run that application.
  3. And in phpMyAdmin, the value of the item "Server" on the top of the user interface, is your database hostname.
    The Database Hostname on the Application Interface of phpMyAdmin Version 4.0.5

Tuesday, July 9, 2013

Creating a Relational Database on C-Panel

There are many kinds of relational databases, such a MySQL database of MySQL a relational database management system (RDBMS) and a PostgreSQL database of PostgreSQL an object-relational database (ORD).

Creating a MySQL Database

Some web hosting control panels have a MySQL Database Wizard application that will guide you step by step on the creation of a MySQL database. Here are the steps to create and manage a MySQL database through this wizard app. for cPanel user. In the Home of your control panel:

This is a guide to creating and modifying MySQL database(s) in cPanel, through the “MySQL® Databases” application: