WEB HOSTING SUPPORT NETWORK
     
 

Creating a MySQL database/user

You can create MySQL databases and users only through the MySQL Databases section of the hosting Control Panel.

Creating a MySQL database

To create a MySQL database, you need to:

  1. Log in to your hosting Control Panel.
  2. Enter the MySQL Databases section.
  3. Navigate to the Databases tab.
  4. Specify a name for your database in the Database name field. The name of your database always starts with your hosting Control Panel username followed by an underscore.
  5. Select the collation for your database from the Collation drop-down menu. By default, the utf8_general_ci collation is selected.
  6. Click on the Create button.

Once your database is created, the system will automatically grant permissions to your master MySQL user. The name of your master MySQL user is the same as your hosting Control Panel username. Its default password is the same as your initial Control Panel password.

Creating a MySQL user

By default, your master MySQL user has full privileges over your databases. Due to security concerns, we recommend that you create and use a separate MySQL user for each software application installed on your account.

You can create a MySQL user by following these steps:

  1. Log in to your hosting Control Panel.
  2. Enter the MySQL Databases section.
  3. Navigate to the MySQL users tab.
  4. Specify a name for your MySQL user in the MySQL user field.
  5. Enter the password for your MySQL user in the Password and Confirm password fields.
    Note: You will notice that there is a password strength indicator below the Password field. It will update in real time as you are entering your password. There are five distinct levels of password strength: Very Weak, Weak, Fair, Strong, and Very Strong. Along with the password strength indicator, you will also get information and hints in a tooltip beside the indicator. Note that the Add button will remain inactive (grayed out) if the password level is Very Weak or Weak.
  6. Select the Enable remote option from the Remote connections options if the MySQL user will be used for accessing your databases from a remote location.
  7. Click on the Add button.