as suggested by brian-as, a simple guide to setup a MySQL db using (cPanel 10.8.1-RELEASE-113)
login to your websites cPanel (usually @ domain.com/cpanel)
navigate to "Site Management Tools" & select the option "MySQL Databases"
this will take you to a new page, where cPanel lists your current databases ( and users assigned to these db's ) and a little lower, three forms are available. one to create a MySQL database, one to create a MySQL user, and one to assign a user to a specific database.
go ahead and type in a database name in the form next to "MySQL Database:" and click "Create MySQL Database", this will take you to a confirmation page.
now, return to the MySQL Database manager in cPanel, and scroll down to the form that asks for a username/password, enter in a username with the password, and then click "Create MySQL User", again this will take you to another confirmation page, after you've completed this hit back or re-navigate to the MySQL section of cPanel.
now, to give the user access to a specific database, scroll down to "Grant permissions on a MySQL database to a MySQL user" make sure the checkbox "ALL" is checked to grant uninhibited access to all MySQL commands (you can limit it if you wish by selecting other boxes), and click the button "grant permissions"
congratulations, you have succesfully created a mysql db & user! you can now use them to connect!
© nuri hodges ( irunbackwards @ phpmydonut.com
more to come....