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.

How to create a database

ComplexityAdvanced

There are two steps to create database.

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.

There are two steps to create database.

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.

Launch MySQL Manager
Launch MySQL Manager


Step one: Creating a database user

  1. Select Add a Database User
  2. Enter a password and Apply

Adding a database user
Adding a database user

  1. Click OK to confirm

You have successfully added a user
You have successfully added a user

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

Viewing user & database details
Viewing user & database details

Step two: Creating a database

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

Select Create
Select Create

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