How to Create MySQL Database

How to Create MySQL Database

Every website needs a place to store its data. Here, we’ll create a database for your website, along with creating and permitting a user to access it.

Step 1. Access the MySQL Databases

Once logged in, navigate to the MySQL Databases tool.

mysql databases tool in cpanel

Step 2. Create a New MySQL Database

You’ll be directed to the MySQL Databases window. To create a database, input the name (without spaces) in the appropriate field and click Create Database. Once done, click Go Back.

create a new database

Step 3. Create and Add New MySQL User

When you scroll down, you’ll find the Add New User form available. When filling it out, enter the username without spaces. Enter your password and repeat it.

You can also use the Password Generator to create a stronger password combination. If you did, click I have copied this password in a safe place and click Use Password.

Once done, click Create User.

create a new user for the database

Once you click Go Back, you can fill the form Add User To Database. Select the user from the drop-down list, and choose the database to which the user would be assigned.

adding new user to the database

Once you click Add, you’ll be directed to the Manage User Privileges window.

Step 4. Provide Privileges to the New User

In this step, all you have to do is to grant privileges to the user. If you’re creating an admin, you can check ALL PRIVILEGES and click the Make Changes button.

grant privileges to the new user

There you have it, you have successfully created a database, user and granted privileges that are required to access the website’s database. Keep in mind, we only created an empty database with this tutorial, so you need to manually create or import all the tables and entries to it.

 

  • cpanel, mysql, mysql database, database, db, add db, add database
  • 75 Users Found This Useful
這篇文章有幫助嗎?

相關文章

Access to the Control Panel (cPanel)

cPanel is a web hosting account management toolYou only get one username per cPanel. If you...

Access to the Easy Web Site Builder

To access to the Easy Web Site Builder that contains over 1000 ready-to-use templates are now...

How to Check Bandwidth

Step 1. Access a Short Summary of Bandwidth Usage When you log in, you can immediately see the...

Creating a Subdomain

How to Create a Subdomain Log into cPanel. In the Domains section, click on the Subdomains...

How to Configure Dreamweaver for FTP

How to Configure Dreamweaver for FTP If you are using Dreamweaver as your site designer, you...