Go to your HostGator control panel and login. Once you are logged in click on the ‘MySQL Database Wizard’ from the Databases group, which was previously shown in Figure 1-12. You should be at the page shown below in Figure 3-9.
Figure 3-9 MySQL Database Wizard, Step 1.
Enter the name of your database. Your database can be any name you would prefer. You could name your database ‘arcadeDB’ or ‘ArcadeDatabase’. Any name you can think of will be okay.After you have created your database you can click the ‘Next Step’ button and you will arrive at Step 2, displayed in Figure 3-10.
Figure 3-10 MySQL Database Wizard, Step 2.
In step 2 we need to specify a username and password. This username and password will grant you rights to access the database. After entering in the information click the ‘Next Step’ button and continue to Step 3, shown in Figure 3-11.
Figure 3-11 MySQL Database Wizard, Step 3.
This step is asking you what kind of rights you want to grant this user. Since we are the administrator of our arcade we want to have full access. Click on the ‘all priveleges’ checkbox. Finally click ‘Next Step’ and you will be at the final step, shown in Figure 3-12.
Figure 3-12 MySQL Database Wizard, Step 4.
Step 4 confirms that the username has been added to the database. You can click on ‘Return to Home’ to return back to the main page.
As you may have noticed when you create a new database it will be created with your user name and an underscore before the actual name of your database. This also happens with your username. This gets created by default. So, when you are asked to enter your database name or your database user it should be entered with the preceding ‘username_’.
You have now finished creating your arcade database. Next we will be installing the arcade script which will populate the database with the necessary information to run our arcade.