If your host uses CPanel for your site management, you can use this visual interface to create the database.
- Log into your CPanel (typically located at http://www.example.com/cpanel for your domain).
- Look for the option to work with databases - it may read Manage MySQL in the Databases box.
- Scroll down to where it says: Db: _________ [add]
- Enter your preferred database name.
- Click
Add.
This will create a database in the format of
account_databasename, where account is your username with your host, and databasename is the name you've chosen for your database. - Now scroll down to where it says Users.
- Enter your preferred username and password.
- Click
Add User.
This will create a username in the format of
account_username, where account is your username with your host, and username is the username you have just created for your new database. - Now scroll back up to locate the two drop down boxes with a button that says [Add User to Db]
- In the drop down select box on the left, choose your newly created username, and in the box on the right, choose your newly created database.
- Check "All" for Privileges.
- Click
Add User to Db.
