Login to your account at
http://example.com/cpanel/
Click on the “MySQL Databases” Icon
To create a new database, enter a database name in the new database input. Example: “blog”. Once you confirm the name, your hosting login name is prefixed to your database name. EX:
bob_blog. Use this name to configure your software.
Next, a user needs to be added to the database. Enter a user name and password for the database. EX: “bob”. Again, the final name has your hosting–login–name attached to the name. EX:
bob_bob.
Under the heading “Add Users to Your Database,” select your user and permissions (typically “All” is needed), then click “Add User to Database”.
That’s it!
Note: The document root of your site is
/home/domainname/public_html