A MySQL database will need to be set up before you can install phpBB forum, WordPress / Joomla or any other web based software that requires a MySQL database.
You can use the MySQL Manager tool to create new databases and manage your existing databases.
Creating a database
- Navigate to your Shaw Hosting portal and login.
- Launch MySQL Manager from the dashboard under Utilities.
- Click Add a database User
- Enter a password and Apply.
- Click OK to confirm.
- You should now see your new user listed in the table.
- Highlight the new username
- In the bottom left, enter the password you created earlier and click Login
- Select Create.
- To create a database
- Select Database
- Enter name for the database
- Click the Build Query button
- Click the Run Query & OK to complete
- Permissions to view, modify & delete are automatically assigned to the user your logged in with. Click OK to confirm.
- Take note of the following information as this will be needed when installing web based software requiring a MySQl database.
- Database Username
- Database Password (from Step 4)
- DB Type
- DB Host
- Database Name
You are now ready to install your web based software using the database information listed above!
Modify or Delete Existing Database
Launch MySQL Manager under Advanced Tools->Utilities after logging into http://shawhosting.ca
This is a powerful application that should only be used by advanced users and with extreme care. If you are not 100% comfortable making these changes please contact firstname.lastname@example.org for assistance.
- Select the user that is associated with the database and enter password; select Login
- If you have forgotten the username password, check off Yes, I want to change the password for the selected user
- Enter a new password, and login with it.
Delete a database
- Select Drop
- Select Database
- Select the database you want deleted
- Build Query
- Run Query
Modify an existing database
The database manager has limited MySQL commands to make modifications. More advanced users can use phpMyAdmin to run more sophisticated MySQL queries.
The following can be modified with the database manager:
- Changing user Privileges
- Restoring Backups
- Setting a database as the default by running the USE query