linux share anti complaints server

cpanel control panel is easy to set up、delete、Database Management。

Create a new MySQL database requires only three steps：
1,build database，
2,Create a user name and password；
3,Adding users and permissions to the database。

Specific steps are as follows：

First login cpanel background，Locate the database area，Then click on the icon to enter the database mysql "database operation page"，As shown below：

1，First, a new database；
In the input box, enter the name you plan to use the database，For example cpdb，Then click on the background of the "Add Database" button，As shown below：

After a successful database creation，Click "Back" button，

2，Then establish a database user name and password；
As shown below，Sequentially inputted
username;
password;
confirm password;
Then click on the "Create" button.

3，Assign permissions to the database and add users，So that the database user has permission to use the database just created。
As shown below，Choose a username and database name，Then click the Add button，Assign access rights page，

As shown below，Check the "all rights"。Click the "Change" button。ok

At this time we have successfully created a new database，And added user permissions for this database。

A few additional points:
1,In the cPanel，Prefix created database with cPanel account，such as：Suppose you Cpanel user name cpanel12, database name you enter is cpdb，Then the name of the database cpanel12_cpdb

2,Database user name and the same as above。

3,Examples of the information database built：
Database name cpanel12_cpdb (front to fill out the database name，I remember prefix，）
Database user name cpanel12_cpanel1 (fill in front of their username，I remember prefix)
Database Password **** (Fill in your own password)
Server localhost
4,When you add a "privilege" for the database user，Usually check the "all rights"。Of course, you can also assign separate permissions for certain users。