Checkmark

Thank you for your feedback

Set up a MySQL database

Learn how to create an active database for your Web Hosting or Merchant Solutions account.

Article ID: SLN20602

Set up your own MySQL database

  1. Sign in to your My Services page.
  2. Click the Web Hosting link.
    Web Hosting Link.
  3. Click the MySQL Databases link in the Databases module. MySQL Databases Link.
  4. Scroll down to Add New User and enter a Username and Password. Note: There is a 5 character minimum and a strength level of at least 65 for database passwords. To auto create a strong password, click the Password Generator button. A dialog box opens for additional options. 
    Add MySQL Database User.
  5. Click the Create User button.
    Create User Button.
  6. The new MySQL Database user is listed in Current Users.MySQL Database User List.

Add User to Database

  1. Scroll to the Add User To Database section and select the User and Database from the dropdown. 
    Add User to Database.
  2. Click the Add button. 
    Add Button.
  3. Checkmark ALL PRIVILEGES or select specific user privileges from the list. 
    Checkmark Privileges.
  4. Click the Make Changes button. 
    Make Changes Button.
  5. A success message will appear.
    Success Message.
  6. Click the Go Back link. 
    Go Back Link.
  7. Scroll to the Current Databases section. The user now has privileges to the assigned database. Note: You can assign a user to all databases by repeating the steps above. 
    Current Databases.

Once you've set up your database, we recommend that you use phpMyAdmin, a powerful database management tool. 

To learn more about MySQL, visit the MySQL website.

See Also: