Javascript Menu by Deluxe-Menu.com

US & Canada: 1-888-354-6128

Local & International: 1-206-438-5887

1-703-564-9887/1-604-638-2525

Web Site Hosting, Dedicated Hosting, Cheap Hosting  Web Hosting Sales Assistance

MySQL Usage

Setting up your database
If you would like to use a MySQL database, you must first create a mySQL database by using your myCP Control Panel. After logging into the mySQL area, click on "create database".
Database and login name naming scheme

The database naming scheme is automated in myCP. The database name is based on your website FTP login name. For example, if your FTP login name is shb8_134, the first database you setup will be called shb8_134_1. If you request a second database, it will be called shb8_134_2, and so on. Because we use dedicated mySQL servers, for all clients we need to know the database owners, therefore there can be no exceptions regarding the naming scheme.

The database login name is the same as the database name. The user has full control over the database. It can create, modify and drop tables, add and drop indexes, insert, modify and delete records from a table, etc.

Logging into your database

You can login to the database in myCP with phpMyAdmin to create your tables, and do all of your MySQL work. You may also login with any mySQL client, or with a PHP, Perl, or ASP script on your site. To login you need four pieces of information:

1. the database hostname/server, which you can determine by clicking on phpMyAdmin. You will see text in the login dialogue indicating the name of your server, for example mysql1.dca1.superb.net.
2. the database name, which you can determine by looking at the entry under "database" in the main mySQL screen in myCP.
3. the database username, which is the same as the database name.
4. the database password. If you forget the password you used to create the database, you can change it as specified below.

Database size

For each mySQL database are given 20 megabytes. By default you have 5 databases, so you have 100 megabytes in total for database usage. ie. if you only have one database, it can be up to 100 megabytes.

Changing the mySQL user password and user permissions

You may want change the password and the user permissions for security reasons. The user created for your database is initially set-up with full permissions for the newly created database.
  1. Click the link Users for the database you want
  2. Change the Permissions you would like for that User, and if you don't want to change the password, just leave both password fields blank.
  3. If you would like to change the password, but not the permissions, just type in the Password (in both fields) and don't change any of the permissions.
  4. Click on Submit.
Notes:
- If you remove all privileges, the user is going to be removed from mysql (this is how GRANT statement is supposed to work).
- If you are not sure why you should change the user permission, don't do it. You can make your scripts stop working.
(for more information on mySQL database permissions, see: http://www.mysql.com/doc/P/r/Privilege_system.html)
DB Dump Tool
This tool can be extremely useful. Using the DB Dump Tool, you can transfer structure and data from any mySQL server onto our server or from our server to another.
  1. Click in the link Dump for the database you want.
  2. Type in the server name, Db name, login and password of the server you want to transfer the data from (your old hosting company for example)
  3. Type in the server name, Db name, login and password of the server you want to tranfer the data to (it defaults to our server and your database and login name)
  4. Click on Submit Query button

Stats
This gives you the stats on your mySQL databases. Just for informational purposes.
phpMyAdmin Suite
This is the most used suite for mysql administration. This is an open source, third-party application.
  1. Click in the link PhpMyAdmin for the database in question
  2. You will be prompted to enter the database login and password
  3. After logging in, you can begin working with phpMyAdmin Suite.
Notes:
A very nice feature of phpMyAdmin is the ability to dump your database into a plain text file in your own computer (this is great for local backups). Creating and editing tables is very simple and fast.
 

myCP® Login


Domain Registration

starting at
$9.95/yr

RatePoint Site Seal

Microsoft, Plesk, cPanel, Fedora, RedHat, FreeBSD, Intel, Cisco
All material © 1996 - 2008 Superb Internet Corp.