How to Create a My SQL Database in cPanel


To add a My SQL Database in cPanel, follow the instructions below:

Procedure:

  • On the homepage of your cPanel, click MySQL Database under “Databases”.

CPanel

  • Enter a new name for your new database in the New Database text box.

Database text box

  • Click the Create Database button.

Create Database button

  • Click Go Back.
  • Enter a username in the Username text box. The characters of the username cannot exceed seven characters.

Username text box

  • Enter a password in the Password text box.

Password Text box

  • If you want to use a generated password, click the Generate Password button.
  • Enter the password again.

Password Again

  • Click the Create User Name button.

User Name button

10. Now add the username to the database you have just created.

11. Select the username from the User drop down menu.

User drop down menu

12. Select the database name from the Database drop down menu.

Database drop down menu

13. Click the Submit button.

Submit Button

14. Check the ALL PRIVILEGES checkbox.

PRIVILEGES checkbox

15.  Click the Make Changes button.

Changes Button

16. The username is now successfully assigned to the database.

Be Sociable, Share!

Related posts:

  1. How to Create a New Email Account in Cpanel
  2. How to Create FTP Accounts in Cpanel
  3. How to Install Soholaunch Pro Edition through Cpanel
  4. How to Install Support Services Manager through Cpanel
  5. How to Install 4Images Gallery through Cpanel

Filed Under: Computers & Technology

Tags:

About the Author: Justin Belden is a freelance web & graphic designer with over 15 years' experience. He is also an Avid member of the Design/Development community and a Serial Blogger who loves to help people by sharing interesting and informative tips and trick related to computer and technology.

RSSComments (0)

Trackback URL

Comments are closed.