In your Control Panel look for the heading "Website Management" and click the MySQL Database icon. Next click the 'Create New Database' button and you will then see a new screen
Type into the box a suitable name for your database and click 'Add' and you will see this message.
You can now close this screen and log out of your control panel.
Setting the Database Connection Details
After 10 minutes has passed you can log back into your control panel and again locate the heading "Website Management" and click the MySQL Database icon and you will now see the database that you just created in the list of database names. Go ahead and click that new database. You will see that the process of creating the database has already created a user with full administrative priveledges. It has used the username and password that you use to access your control panel to do this. Naturally, it is not a good idea to use this username and password combination to manage your new database so you need to add a new user. To do this click the 'Add User' button and the 'Add User' screen will appear.
Type any username you wish into the username box. You can use anything you wish but I'd reccomend you stick to lowercase letters for teh username. Next type your chosen password into the password box and confirm it in the confirmation box. Finally you need to choose a Role for this user from the dropdown box, when you have finished press Save. (Make sure to keep a note of the username and password as you will need it to access this database as this user.)
Accessing the Database
Most programs that require a database have a wizard that asks 3 specific questions.
Q1. What is your username A1. This is referring to the database username you just created
Q2. What is your password A2. This is referring to the database password you just created
Q3. What is the path to your database A3. yourdomainname_co_uk_nameofyourdatabase
Notice that the 'Dots' usually in "Dot co Dot UK" are replaced with the underscore and that no www or http is required.
Search the Knowledgebase
Browse by Category
Print this page
Email this page
Post a comment
(1 vote)
