- Click on "Site Services" from the menu on the left-hand side of the page. When the menu expands, click on MySQL and then Databases.
- The Database Management screen will appear. Type a name for the database in the field titled "Database Name", then click Add.
Your newly created database will appear in the list of Existing Databases. - Next, you must give a MySQL User rights to access the database.
- If you already have a MySQL User set up that you would like to use, simply click on "Manage Users" which appears just to the left of the database name. Proceed to Step 4.
- If you have not created a MySQL User or if you need to create another user to access this particular database, select Users from the MySQL menu on the left side of the page.
Add the new user by entering a name in the Username field and then enter the password that you would like to assign to this user into the Password and Confirm Password fields. Click on Add to save this MySQL User.
Now you're ready to assign this user to the database so go back to the menu on the left and then select Databases. Click on "Manage Users" to the left of the database name that you created in Step 2 above and then proceed to Step 4.
- Select the MySQL User who should have access to this database from the drop-down list in the User column and then assign the appropriate permissions by clicking on the boxes under Permissions. Normally the program that you are creating the database for will give you a list of permissions that the MySQL User must have so you can refer to their documentation to find the settings.
When you're finished assigning permissions, click on Add to assign this MySQL User to the database. - You're done. You can now assign this database and its user (database username) to your program's configuration file.
(Note: The control panel adds a prefix to the database name and the username. The database name and the MySQL username are prefixed by your site's truncated name followed by an underscore, "sitename_", so the full database name and its username should be used in your program's configuration file (e.g. sitename_mydatabase and sitename_mysqlusername respectively).