1. bluehost knowledge base

 

How to Create and Delete MySQL Databases and Users

Databases offer a method for managing large amounts of information easily over the web. They are necessary to run many web-based applications such as bulletin boards, content management systems, and online retail shops.

To begin, you will need to log in to your Bluehost control panel.

  • For the Bluerock Accounts - Click the Advanced tab from the side navigation menu to the left.
  • For the Legacy Accounts - Click the cPanel in the sub-menu that stretches across the top of your screen.

​​If you are not sure whether the account uses the Legacy or Bluerock interface, please see Bluerock vs Legacy to determine which steps to follow.

Create or Delete a MySQL Database

Create a MySQL Database

  1. Under the Database section, select MySQL databases.
  2. In the New Database field, type a name for the database.
  3. Click Create Database.
  4. Click Go Back.
    • The new database will appear in the Current Database table.
 

Delete a MySQL Database

  1. Under the Database section, select MySQL databases.
  2. Navigate to the Current Databases section
  3. Click the Delete Database link next to the database you wish to delete
If you would like to remove a user that has been assigned to a database, click the red "X" next to the user on this table. 

 

Create or Delete a Database User

After creating the database, a user will need to be created and their privileges added to the newly created database. Please note that MySQL user accounts must be created separately from mail and web administrator accounts.
 

Create a Database User

  1. Under the Database section, select MySQL databases.
  2. Locate the MySQL Users section of the MySQL Databases tool. To quickly find this section, click "Jump to MySQL Users".
  3. Under Add New User, enter a username.
    Note: The username must be 7 letters or shorter.
  4. Enter a password in the Password field.
    • For help generating a strong password, click the Generate Password button.
  5. Retype the password in the Password (Again) field.
  6. Click Create User.
 

Delete a Database User

  1. Log in to your Bluehost control panel.
  2. Under the Database section, select MySQL databases.
  3. Navigate to the Current Users section
  4. Click the red "X" icon next to the user you wish to delete
 

Define a User's Privileges

Privileges define how the user is able to interact with the database. For example, they will determine whether or not the user can add and delete information.
 

Assign a Database User

  1. Under the Database section, select MySQL databases.
  2. Under Add User to Database, select a user from the User drop-down menu.
  3. From the Database drop-down menu, select the database to which you wish to allow the user access.
  4. Click Add.
  5. From the MySQL Account Maintenance screen, select the privileges you wish to grant the user or select ALL PRIVILEGES.
  6. Click Make Changes.
 

Un-assign a user

To un-assign, a user from a database clicks the red "X" next to the user on the database table. 

 

Using the Database

Now that you can create databases, users, and assign appropriate privileges, you can use the following articles as a reference to editing and connecting to your databases.