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.

On this page

Creating a database

  1. Navigate to your Shaw Hosting portal and login.
  2. Launch MySQL Manager from the dashboard under Utilities.
  3. Click Add a database User
  4. Enter a password and Apply.
    2017-08-18-SH-MySQL_02
  5. Click OK to confirm.
    2017-08-18-SH-MySQL_04
  6. You should now see your new user listed in the table.
    2017-08-18-SH-MySQL_03
  7. Highlight the new username
  8. In the bottom left, enter the password you created earlier and click Login
    2017-08-18-SH-MySQL_05
  9. Select Create.
    2017-08-18-SH-MySQL_06
  10. To create a database
    1. Select Database
    2. Enter name for the database
    3. Click the Build Query button

    4. 2017-08-18-SH-MySQL_07
    5. Click the Run Query & OK to complete
    2017-08-18-SH-MySQL_08
  11. Permissions to view, modify & delete are automatically assigned to the user your logged in with. Click OK to confirm.
    2017-08-18-SH-MySQL_09
  12. Take note of the following information as this will be needed when installing web based software requiring a MySQl database.
    1. Database Username
    2. Database Password (from Step 4)
    3. DB Type
    4. DB Host
    5. Database Name
      2017-08-18-SH-MySQL_10

      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

2017-08-18-SH-MySQL_01

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 hosting@shawbusiness.ca for assistance.


  1. Select the user that is associated with the database and enter password; select Login
    1. If you have forgotten the username password, check off Yes, I want to change the password for the selected user
    2. Enter a new password, and login with it.
      2017-08-22-SH-MySQL_log_into_database

Delete a database

  1. Select Drop
  2. Select Database
  3. Select the database you want deleted
  4. Build Query
  5. Run Query
2017-08-22-SH-MySQL_drop_database

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