- 2024.04.28 09:58
Note : This tutorial will teach you how to create a database and how to add an authorized user to it. Also, your database name along with your username will always include your cpanel account username and it should be taken into consideration when using the database (cpanelusername_mydatabasename is the right name to use to populate the configuration of a CMS)
1) Login to your cPanel accountÂ
2) Click on the "MySQL Databases" icon within the cPanel interface.
3) In the "Create New Database" field, type the name of the database you want and hit "Create Database".
Your database is now created.
4) Now, we will create a new user. In the MySQL Users and "Add New User" section. You may fill the Username / Password fields. You can use the password generator for a more secured password. Click on  "Create User".
Your user is now created.
5) We need to allow the user to interact with the database with granular authorisations. At the bottom of the MySQL Database page, you may  the "Add User to Database" section. You would need to select the database and the username you have just created and click "Add".
Then, you can select the privileges of the user on the database. Generally, you would need to select "All Privileges and then click on the "Make Changes" button.
That's it, you have now created a database along with an authorized users. You can now use it in your web applications.Â
Most of your web apps will ask you for a host / hostname for the MySQL which should be either "localhost" or "127.0.0.1".Â
Â
