cpanel panel How to build MySQL database

Creating a new MySQL database requires only three steps:

1, set up a database,
2, create user name and password;
3, add users and permissions to the database.

First login cpanel background, locate the database area, and then click on the MySQL database icon to enter the "Database Operation Page",

First login to your own cpanel control Panel, click on the MySQL database to see Add new users, enter your user name and password , you can also use the password generator, and then click to generate Users. The username and password to be filled in here must be remembered, if you want to build WordPress, it will be filled in when the first landing.

New users will need to create the next database, the front of the section for your cpanel account, in the back of the name you want to create a new database, you can be your website domain name, so that it is convenient to know which website database, easy to manage.

now that the database and the user are all built, we will add the created user to the newly created database and give the permissions. Find the Add user to the database, select the database you just created, select the user you just created, and then click Add.

after adding, you can choose the right to manipulate the database for the user. If you are an administrator-level user, select all permissions and click Change to save.

such a new MySQL database, the user is created well.