How to set up Shaw Hosting MySQL Manager

There are two steps to create a MySQL database in your Shaw Business web hosting.

Step one: Create a database user
Step two: Create a database

To start, log in to the web portal at shawhosting.ca/.

Launch MySQL Manager from the dashboard under Utilities.

The database username is automatically generated and cannot be changed.

1. Select Add a Database User
2. Enter a password and Apply
3. Click OK to confirm

See screenshots below.

You should now see your new user listed in the table.

1. Highlight the new username or an existing username.
2. In the bottom-left corner, enter the password you created earlier and click Login.
3. Select Create.

4. Now, to create a database:
   1. Select Database.
   2. Enter the name for the database.
   3. Click the Build Query button.
   4. Click Run Query and OK to complete.
5. Permissions to view, modify, and delete are automatically assigned to the user you're logged in with.

6. 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

   You are now ready to install your web-based software using the database information listed above!

1. Select the user that is associated with the database and enter the password. Select Login.
2. If you have forgotten the username and password, check the box next to Yes, I want to change the password for the selected user.
3. Enter a new password, and log in with it.

---

How to delete a database

1. Select Drop.
2. Select Database.
3. Select the database you want deleted.
4. Click Build Query.
5. Choose Run Query.

---

How to modify an existing database

Note that 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.