0 items
24/7 Support & Sales   1300 210 210
Online Support Web Hosting

How to create a MySQL Database and User

What is MySQL?

MySQL stands for My Structured Query Language is an open-source database management system. It is where data or information for your website is stored. However, in order to access data from MySQL, your system needs a computer language such as Java, Perl, Python, and PHP.

It was developed by Oracle Corporation and was initially released on May 23, 1995.

If you want to know more about what is a MySQL database, click here.

Fun fact: The term MySQL is a combination of "My", Michael Widenius' daughter, and the acronym for Structured Query Language, which is a programming language designed to manage data.

How to create a MySQL Database and User

If you are setting up a web-based application, such as a bulletin board, a blog, or an online shop, you will need a MySQL database to store the web files. Moreover, in order to gain access to the database you created, you also need to create a User that can read, write, or modify data in that database. You can do both of these within your Hosting Manager.

To know how to access your Hosting Manager, click the link below:

You can create a database and user using either the MySQL Databases or MySQL Database Wizard features in your Hosting Manager. However, if you are creating your first database and user, it is recommended that you use MySQL Database Wizard. This is because this feature offers an easier step-by-step process for users.
To create your first database and user in MySQL Database Wizard, follow the steps below:

  1. Click on My Account at the top of the page.
  2. Select Hosting Manager from the drop-down menu.
  3. Enter your username and password, and click Log In.
  4. On the Home page, click the word Databases or the [ v ] arrow symbol on the right side.
  5. Next, click the MySQL Database Wizard button, which is next to MySQL Databases icon.
  6. In Step 1, type the name you want to use for the database in the New Database field.
  7. Click Next Step.
  8. In Step 2: Create Database Users, fill out the following fields:
  9. Username This is the new privileged user’s name.
    Password This will serve as the key that will enable you to access your MySQL database. The system will tell you how weak or strong your password is when you type it in the appropriate fields.

    If you find it difficult to make a strong enough password for your email, you can let the system create one for you.

    Click the Password Generator button. In the pop-up box, copy the generated password and paste that in the Password fields.

    You can also choose to check I have copied this password in a safe place. Then, click Use Password. This will automatically copy and paste the generated password in the Password fields.

    Important Note: Make sure you have actually saved the generated password in a safe and easy to recall place.

    Password (Again) This is only for confirmation and should be the same as in the Password field above.
  10. Click Create User.
  11. In the next page you will get the following notification:
    ✔ You have successfully created a MySQL user named “hostingname_newuser”
    Below that is Step 3. This is where you will set the user privileges. Check the permitted actions you would like to grant the user within the database. You can also choose to check All Privileges to give the user permission to do everything on the list. Click Next Step.
  12. In Step 4, this is where you complete the task. If the creation is successful, you will get the following notification:
    ✔ User “hostingname_user” was added to the database “hostingname_database”.

Congratulations, you now know how to create a MySQL database and user.

Below the notification in Step 4, you have the option to do any of the following:

  • Add another database
  • Add another user for your MySQL database
  • Return to MySQL Databases main page
  • Return to Home page

Simply click the appropriate button to execute the command.

Note: When you create a database and/or user, the system will automatically provide your Hosting Manager username as a prefix.
e.g. username_user01, username_database01

For information on how to manage MySQL database user privileges, please view the guide below.

If you want to know what to do in case you lost your MySQL database user/password, click here.

If you want to know how to restore a MySQL Database backup, click here.

If you want to know how to fix a MySQL database, click here.

Was this helpful? Yes No 50% of people found this helpful.