Troubleshooting

How to set up Shaw Hosting MySQL Manager

Learn how to create and manage a MySQL database which will need to be set up before you can install phpBB forum, WordPress / Joomla or any other web based software.

Keypoints

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.

How to create a MySQL user

ComplexityAdvanced

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.

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.

Adding a database user
Adding a database user

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

Viewing user & database details
Viewing user & database details

Show more

How to create a MySQL database

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

Select Create
Select Create

Enter Database information
Enter Database information

  1. 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.
  2. Permissions to view, modify, and delete are automatically assigned to the user you're logged in with.

Permissions are automatically assigned
Permissions are automatically assigned

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

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

Show more

How to modify or delete existing databases

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

Logging in to MySQL database
Logging in to MySQL database


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.

Deleting a Shaw Hosting MySQL Database
Deleting a Shaw Hosting MySQL Database


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.
Show more