A database is where information for your website is stored at. It is a collection of information that is organized so that it can be easily accessed, managed and updated. In this post, we will see how to create a database and assign a user to the database in cPanel.
There are two methods to do this.
username_test(username is your cPanel username). Click on ‘Next step’ once you have enetered the database name
You cannot use a database to store and retrive information unless you are authorized. For this reason, we will have to create a database user and the provide that user all the required previlages over the database. You can have one or more than one database users assigned to a database with full previlages.
If you create the user as test, the full database username would be
username_test (username is your cPanel username)
You now have the database user ‘username_test’ with full privileges on the database ‘username_test’.
In next page, we see how to set this up without the database wizard.