HOME TIPS ABOUT US FAQ CONTACT US
  DOMAIN NAMES - HOSTING - RESELLER - SHOUTCAST - MEMBERS 
Z-Host provide a variety of different packages to suit your requirements and pocket.
Z-100 £18.75 per year 
 100 MB   10 GB/month 
Suitable for a small personal/family site or a small business site.
         
Z-200 £26.25 per year 
 200 MB   10 GB/month 
For a medium site or one with many visitors.
         
Z-500 £52.50 per year 
 500 MB   20 GB/month 
Power hosting for large sites with high traffic.
         
Z-1000 £75.00 per year 
 1000 MB   40 GB/month 
Extra-Power hosting for large sites with high traffic.
         
COMPARE HOSTING PLANS


MySQL - Setting Up Databases >>

MySQL

Introduction
MySQL is a SQL Database Management System.

Documentation

Complete documentation is available at:

    http://dev.mysql.com/doc/mysql/en/index.html


Creating a MySQL Database from cPanel

Before you can use a MySQL database you need to create a MySQL database and a MySQL user to access it. You can do this from cPanel. In cPanel all MySQL databases and users are prefixed with your cPanel username to avoid possible clashes with other accounts on the same server.

Follow the steps below, replacing "cpanel" with your cPanel username.

  • Login to cPanel
  • Click on "MySQL Databases"
  • Next to "Db:" enter a database name (e.g. "db") and click "Add Db".
  • Return to the "MySQL Databases" page.
  • Under "Users" enter a username (e.g. "me") and a password and click "Add User".
  • Return to the "MySQL Databases" page.
  • Select the newly created user (e.g. "cpanel_me") and the newly created database (e.g. "cpanel_db") and click "Add User to Db"

Now use the following details to connect to the database:

    Server:   localhost
    User:     cpanel_me
    Database: cpanel_db
    Password: The password you entered when you created cpanel_me

You can view a flash tutorial showing how to create a MySQL database at:

    http://www.z-host.com/tutorial.php?tut=mysql-create-database


Administration

The PhpMyAdmin tool can be used to see the contents of databases. This can be launched from the "MySQL Databases" page within cPanel.

Hints and Tips Index

      HOME - TIPS - ABOUT US - FAQ - CONTACT US - FREE PDF HOSTING Privacy policy - Terms of service     

Copyright © 2002-2024 Z-Host. All rights reserved.