cpanel panel How to build MySQL database

Source: Internet
Author: User
Tags cpanel

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.