H-Sphere 3.x end-user series

22. How to create a MySQL database in H-Sphere

This tutorial assumes that you've already logged into your H-Sphere control panel

Now let's learn how to create a MySQL database

1) Scroll over Databases...

2) ...then scroll over MySQL...

3) ...then click MySQL DB Wizard

4) Enter the database name here

5) Then enter a Database description (this field is optional)

6) Then click Next

Scroll down

The database has been created. Now we need to add a database user

7) Enter a new database username here

8) Enter and confirm a password for this user

9) Choose the role for this user

10) When finished click Add user

That's it! The database that we have just created now has a user set up for it, so the database is ready to use

Now let's see how we can grant or change privileges for the existing and new database users

11) Choose User role from the drop-down list here

12) Then click Grant

You may now see that the requested privileges have been granted for the given database user

Scroll down

13) To complete the setup click Finish

After you complete the database setup you'll get the database management area where you can perform different operations with your database and its data. These operations will be described in detail in the next database tutorial

This is the end of the tutorial. You now know how to set up a database, its user and how to grant privileges on this user within your H-Sphere control panel