Saturday, 02 May 2009 00:00
Written by Shawn
Creating the MySQL Database
Log into your website's cpanel http://www.yoursite.com/cpanel or http://www.yoursite.com:2082
Scroll down and click
MySQL Databases

Enter a name for your database (phpmotion will work fine) and click
Create Database
Note: In most cases when you create a new database the database name will be given a prefix containing your cpanel username. So if you name your database phpmotion the actual name will be YourCpanelUsername_phpmotion
Create a MySQL User. If you already have one set up, skip to the next step.
Note: Just like the database name, the MySQL username will be given the prefix "YourCpanelUsername_". So again if you make a user named steve the name will really be YourCpanelUsername_steve
Add your MySQL user to the new database.

Assign user privileges to your database.
