WEB HOSTING SUPPORT NETWORK
     
 

Creating a MySQL database/user

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

Note: The MySQL 5 and MySQL 8 servers are separate and do not share databases or users, so you can access MySQL 5 databases only with MySQL 5 users and MySQL 8 databases only with MySQL 8 users. This allows you to have two users for MySQL 5 and MySQL 8 with the same name, but with different passwords and privileges.

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. Select the MySQL version of your database from the MySQL version drop-down menu.
  5. 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.
  6. Select the collation for your database from the Collation drop-down menu. By default, the utf8mb4_general_ci collation is selected for MySQL 5 databases and utf8mb4_0900_ai_ci for MySQL 8 databases.
  7. 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. Select the MySQL version for the user.
  5. Specify a name for your MySQL user in the MySQL user field.
  6. 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.
  7. 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.
  8. Click on the Add button.