To create a MySQL database operation method in the Cpanel panel

First need to enter the Cpanel Virtual Host Management System interface, under the database module to find the MySQL database, click the MySQL database, enter the database to create an interface:

Enter the name of the database you want to create in the input box:

When you are done, click the wizard and you will be prompted to create the database username and enter the password as shown below:

Tip: Database username and data are prefixed, such as Storyday_demo rather than demo

Next is to add user rights, that is, the user is being created, the database Storyday_demo can have the right to operate, if you do not know how to set up, you can select all:

Clicking on the next database creates success, and the results created in this example are:

Database: Storyday_demo

Database User: Storyday_demo

Database user password: the password you just entered

Database server: localhost

Other common problems:

Forget database username password how to modify

Go to the database from the cpanel, note that this is not the Go to Database Wizard

To see database-related information

You can delete the user, delete the user will not lose the database data, delete the database will be!

Forget the password, you only need to create a database username with the same name, the following figure

If the access denied is displayed when connecting, then you authorize the user to the corresponding database again, as shown in the following figure

This example allows Storyday_demo to access the storyday_db database, click "Add", and then, like the Database Wizard, authorize

At this point, both the creation and authorization of the database have been completed.

If you want to manage the database, you can use phpMyAdmin, click on the Cpanel home page in the icon to enter

To this end, the use of cpanel panel database Some of the operation of a simple introduction, in fact, the operation is so simple, so the Chinese cpanel Virtual host Control Panel is very advantageous, it is worth hosting the trust of the virtual host management system!!

Available: Wende data