SiteHost

Database Users

Creating a User

This functionality allows users to create new database users. This will add the user to the database server, but will not assign the user to any databases - this is a separate process explained below.

  1. Once you are logged into the Control Panel click Databases in the left menu.
  2. Click the server which has the database you want to access and click Add User.
  3. Enter a Username and Password for the new user.
  4. Click the Add User button below the password fields to confirm.

You will be asked for a different username if the user already exists on the server, or another password if the one you entered is invalid, it must be at least 6 characters long.

Add User to a Database

  1. Once you are logged into the Control Panel click Databases in the left menu.
  2. Click on the name of the database you want to add the the user to.
  3. Click the Add User link above the list of users, or at the top right of the page.
  4. Select the name of the user you wish to add to the database from the drop-down list or create a new user.
  5. For Host, type in the location of the MySQL database server. If you're unsure of what to type, leave it as localhost.
  6. Select the privileges you wish to grant to the user on the given database. An explanation of the privileges available and their effects is available on the MySQL website.

Remove a User from a Database

This explains how to remove existing users from a MySQL database. This user will still exist on the database server, but will no longer be able to access the database. To completely delete a user from the database server follow the instructions in the section on deleting a user.

  1. Once you are logged into the Control Panel click Databases in the left menu.
  2. Click on the name of the database you want to remove the user from.
  3. Click the More Actions icon (᛫᛫᛫) at the end of the row of the user you wish to remove.
  4. Click the Remove User option to confirm and apply.

Delete a User

This article describes how to permanently delete a MySQL user. Users cannot be deleted if they are currently assigned to any databases. To delete the user from any databases, follow the steps above on deleting a user from a database.

  1. Once you are logged into the Control Panel click Databases in the left menu.
  2. Click the server the database user is on and click Database Users.
  3. Click the More Actions icon (᛫᛫᛫) at the end of the row of the user you wish to delete.
  4. Click the Delete User option to confirm and apply.