Hosting User Manual
You are currently looking at one special topic of our Hosting User Manual. If you would like to go back to the general overview click here.
1. MySQL

a. Creating MySQL databases

To create MySQL databases:
  • Click the 'MySQL Server' icon.
  • Click the 'add' icon next to the words 'add database'
  • Enter the name for your new database along with a description of the database. When you are finished, click 'next'.
  • Now, you will need to create a user name and password. Enter this same password again in the 'confirm password' field and assign a role for this user.
  • Click the 'add user' button. When this completes, it will return you to the same page. You may now add additional users or grant privileges to users of other databases. Click the 'finish' button at the bottom when you are done.

You have now successfully created a MySQL database and user.

b. Changing MySQL disk quota

To change MySQL disk quota:
  • Click the 'MySQL Server' icon.
  • Choose the database name that you would like to change the quota for and click the 'edit' icon that appears to the right of the database name.
  • In the 'quota' field, you will see the current amount of space the database uses and current disk quota set for this database. Click on the "pen & paper" icon to the right of this.
  • At this screen you may set the new database quota. Click 'submit' when you are finished.
c. Adding/Removing MySQL users

To add a MySQL user:
  • Click the 'MySQL Server' Icon.
  • Click the database name.
  • This will bring up the database settings page.
  • At the bottom, click the 'add' icon.
  • Create a new user name along with a password and confirm this password. Choose a user role and click 'add'.
To remove a MySQL user:
  • Click the 'MySQL Server' Icon.
  • Click the database name.
  • This will bring up the database settings page.
  • Click the "trash can" icon next to the username and confirm to remove it.
d. Changing user passwords

To change user passwords:
  • Click the 'MySQL Server' icon.
  • In the 'database users' field, select the user that you would like to change the password for
  • Click the "pen & paper" icon that appears to the right of the user name.
  • Enter the new password and confirm.
  • Click 'change'.
e. Changing user permissions

To change user permissions:
  • Click the 'MySQL Server' Icon.
  • In the 'database users' field, select the user that you would like to change the privileges for and click the 'edit' icon that appears to the right of the user name.
  • Click the empty box to add a check to each privilege you would like to grant to the user.
  • Click 'submit'.
f. Hosting MySQL databases

MySQL is a database management system. It allows you to add, access, and process stored data.

To access the MySQL database settings page:
  • From the control panel, click the 'MySQL Server' icon.
  • Then select the database name.

    mysql3.hostexcellence.com (76.163.252.3)

    Host Name: The domain name and IP address of the database server
    Port number: MySQL 3306

    NOTE: If you have problems accessing phpMyAdmin from here, try the main phpMyAdmin icon on the control panel.

Back To Top
2. phpMyAdmin

Phpmyadmin is a common tool used to view and edit the content within your databases. This can also be used to create and restore Mysql backups.

a. Editing MySQL databases

To edit a MySQL database:
  • Click the 'MySQL Server' icon.
  • Click the specific database name that you would like to edit.
  • Click "Built in phpMyAdmin control panel."

NOTE: If you have problems accessing phpMyAdmin from here, try the main phpMyAdmin icon on the control panel.

  • Click on the database name to the left.
  • From here, you can make changes to the database such as creating/removing tables and editing data.
b. Creating backups

To create a backup:
  • Click the phpMyAdmin icon on the control panel.
  • Click the 'MySQL Server' icon.
  • Click the specific database name that you would like to create a backup of.
  • On the left hand side, click the database name in the drop down box.
  • Click the 'export' tab located near the top of the screen.
  • Choose your preferred format type and any options you would like to apply.
  • At the bottom, check 'Save as File' and create a name for the backup. You may also choose a compression format.
  • Click go
  • Depending on your browser's settings, the backup file may automatically download or your browser may prompt you to save the file.
c. Restoring backups

To restore a database:
  • Click the phpMyAdmin icon on the control panel.
  • Click the specific database name that you would like to restore from a backup.
  • Click the database name on the left-hand side.
  • Click the 'Import' tab located near the top of the screen.
  • Click the 'Browse' button to select the backup file from your local computer.
  • Click go

Back To Top
3. PostgreSQL

a. Hosting PostgreSQL databases

In addition to MySQL, you may also create PostgreSQL databases.

pgsql.hostexcellence.com (69.49.230.14)

Host Name: The domain name and IP address of the database server
Port number: MySQL 3306

b. Creating PostgreSQL database

To create a PostgreSQL database:
  • Click the 'PgSQL Server' icon on the control panel.



  • Click the 'Add Database' icon.
  • Assign a name for the database. Choose an owner for the database from the dropdown. When finished, click the 'Submit' button.
c. Changing PgSQL disk quota

To change the PostgreSQL disk quota:
  • Click the 'PgSQL Server' icon on the control panel.
  • Click on the database name that you would like to change the quota for.
  • At the bottom, you will see the current disk space used and the total disk space the database can occupy. Click the "Pen & Paper" icon located to the right.
  • Enter the desired quota.
  • Click the 'Submit' button.
d. Adding/Removing PostgreSQL users

Adding PostgreSQL users
  • Click the 'PgSQL Server' icon on the control panel.
  • Click the 'Add User' icon at the bottom.
  • Enter a desired user name and password and confirmed the password.
  • Click the 'Add' button.
Removing users
  • Click the 'PgSQL Server' icon on the control panel.
  • Near the bottom, you will see all created users.
  • To delete a user, click the "trash can" icon that appears to the far right of the user name.
  • Click 'Yes, I agree with the above' to confirm.
e. Changing passwords

To change PostgreSQL passwords:
  • Click the 'PgSQL Server' icon on the control panel.
  • Near the bottom, you will see all created users.
  • To change the password, click the "Pen & Paper" icon located to the right of the user name.
  • Enter the new password and confirm it
  • Click Change
Back To Top
4. phpPgAdmin

a. Editing PgSQL databases

To edit a PgSQL database:
  • Click the 'PgSQL Server' icon on the control panel.
  • Click on the specific database name that you would like to edit.
  • Click 'Built in phpPgAdmin control panel'.

NOTE: If you have problems accessing phpPgAdmin from here, try the main phpPgAdmin icon on the control panel.

  • Click on the database name to the left
  • From here, you can make changes to the database such as creating/removing tables and editing data.
Back To Top
5. MSSQL (Windows plans only)

a. Hosting Microsoft SQL databases

Microsoft SQL Server is a relational database management system produced by Microsoft. It supports a superset of SQL.

b. Creating MSSQL databases

To create a MSSQL database:
  • Click the 'MSSQL Server' icon on the control panel.
  • At the bottom, click the 'add' button next to 'add database'
  • Enter the desired database name. Next, select the user from the dropdown that you would like to associate with this database. When you are finished, click the 'submit' button.
c. Adding MSSQL database users

To add MSSQL database users, do the following:
  • Click the 'MSSQL server' icon on the control panel.
  • Click the 'add' button next to 'add new MS SQL login'
  • Enter the desired login name then enter the desired password twice. When you are satisfied, click the 'submit' button.
d. Changing MSSQL disk quota

To change MSSQL disk quota, do the following:
  • Click the 'MSSQL Server' icon on the control panel.
  • At the bottom under the 'MS SQL databases' heading, you will see all existing databases. Click the 'edit' button that appears to the right of the database name that you would like to edit.
  • In the 'database quota' field, click the "pen & paper" icon
  • Set the desired quota then click the 'submit' button
Back To Top
6. ODBC

a. What is ODBC?

ODBC - Open Database Connectivity is a standard database access method developed by Microsoft Corporation.

ODBC makes it possible to access any data from any application by means of ODBC drivers - one for each database format.

You can create a DSN (date source name) records based on ODBC drivers to access databases of different formats under Windows plan.

b. Creating a new DSN record

To create a new DSN Record, do the following:
  • Click the ODBC icon on your control panel page, and the list of available ODBC drivers will show.



  • Click the Add icon next to the DB driver you need.
  • Fill the form that appears. Forms are different depending on the DSN type:
  • Enter the second part of your full DSN name in the DSN field.

    NOTE: The first part of your full DSN name is your Windows login.

    Directories and file names must include paths relative to your home dir root, (the SourceDB field should include the name of the database and the extension).



  • Click Create
c. Editing DSN records

To edit a DSN record, do the following:
  • Click the ODBC icon on your control panel.
  • On the page that shows, in the "Your DSN" section, click the edit icon next to the DSN record you need.
  • Edit the DSN records in the form that appears.
  • Click update

d. Deleting DSN records

To delete a DSN record, do the following:
  • Click the ODBC icon on your control panel.
  • In the Your DSN section, click the "trash can" icon next to the existing DSN to delete it.
Back To Top
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams