ICCM Hosting

MySQL Hosting

How do I connect to and use MySQL?

Please login to your control panel and follow these steps to create the MySQL database, user and its password:

Once you login into your control panel, please click on "MySQL Databases" under "Database" section and then

a) Use the option "Create MySQL database" to create the database, say "SQLdbname". The database name will have your username as its prefix username_ i.e. username_SQLdbname

b) Create a database user from the same interface and note down the username and password, say username_user

c) Grant ALL privileges to this user on the database created using the option "Grant permissions on a MySQL database to a MySQL user"

Now you have following:

Database: username_SQLdbname
DB user: username_user
DB user passwd: XXXXXX (that you setup in step b)
host: localhost

Now you can use these values in your php or perl script to connect it to the database.

To browse your database, you can click on phpMyAdmin in your control panel.

You can also check these video (flash) tutorials:

http://www.iccmhosting.com/know/cpanel.php