Learn how to create a database with cpanel.
In this tutorial we will be learning how to manage your database with cPanel. We will explain you how to create.
So once you enter the credentials like username and password you can simply press Log In. Once your credentials are authenticated you will be redirected to your cPanel dashboard. Now we will talk about database.
By clicking on MySQL Databases, we will create a new database. So for that you can keep a note of your database name that you have one to keep in account.
This will further help you, then you will be Login with your WordPress admin. So you need not to remember any thought of credentials later. This is a new database, has been added, so you can press go back.
Now you will create a MySQL user, so for the user you need to have a username. For example, we set the complete username will be: mysite12_my_home
Now you can set your password. Again the same password. You can see the strength of your password. Now you have an optional password generator, if you click this you see a system generated password.
If you want to use this you can directly use this, either case you can set advance options. Like if you want to set the password strength you can use alphacharacters or non-alphacharacters.
For example: if you only want to keep lowercase you can press this, if you only want to keep symbols you can press this. So if you want to use this password press generate password, and a password is generated.
And then simply use the password. If you want to use your own password, press cancel and click “Create User”. An user will be created successfully. Go back and we will show you the user and database.
This is the database that we created, you can rename and delete by clicking this. Similarly you can check the user that is created, you can manage its password that we just created, you can rename this and also delete it.
Now if you go back to your cPanel, in the File Manager, you can then set your folder permissions and privileges. Have your database hosted in this web hosting site.