How to create a MySQL database in H-Sphere
While not as popular as cPanel or Plesk, many hosts are using the H-Sphere control panel. Fortunately it is very easy to create a MySQL database through the H-Sphere interface.
Login and click the icon
The first step after logging in to your H-Sphere account is to click on the MySQL server icon.
Creating the database
Clicking on the MySQL server icon will take you to the following screen. Click on the Add Database icon on the bottom.
The blurred areas will contain information on your server and any databases that you have already created. I have blurred these here since they are specific to my account.
Give it a name
Now you’ll need to give your database a name and an optional description.
Again I’ve blurred out my account information. You will need to pay attention to the blurred part during your setup because the account name is used as part of the actual database name.
Type in a name and a description if you wish and click Next.
Adding Users
Now you will need to add the user that will access your database. You can either create a new user or use one that you’ve created in the past. Most likely you will be creating a new user.
Enter a username and password for your new user, again noticing that your account name is appended to the front of the username like it was to your database name.
You will also need to assign a role for this user. Your choices are read, read / write, or dba. For most database based web applications you will need to use dba since the setup for your program will be adding tables.
Click on Add user and you should see a message on the top that ‘User username has been added successfully’. Now click on Finish to continue and you will be taken back to the list of databases.
Question, Comments...
Do you have more questions. Please either leave a comment below or join us in our new forum.