How do I add a mysql database in Cpanel?

To create a MySQL database:

- Go to 'Manage Mysql' under the database header in Cpanel

- In the DB text field, type the name you wish to give your database
- Click the Add DB button
- At the bottom of MySQL Manager under 'Users' type a
database user name and password
- Click the Add User button

Now for the important part that everyone misses:

You should now see your new user listed in the dropdown menu after "User:" and your new database listed in the "DB:" dropdown menu. (if you don't try refreshing the page in your browser) Then, select BOTH the username AND the DATABASE NAME and click the Add User to DB button to add your user to your database and you're done.

Now that you have created a database, created a database user and have granted that user access to the database your mysql database is fully ready to use.

  • 9 Users Found This Useful
Was this answer helpful?

Related Articles

How can I backup a database using phpmyadmin?

Backing up your database in Phpmyadmin is accomplished by doing the following: 1) Once you have...

How do I backup a database via SSH?

First, you'll need to log into your account via a secure shell client like Putty or SecureCRT....

How do I restore a database using PHPMyadmin?

You can restore a database backup in PHPMyadmin by doing the following: 1) After entering...

What is Mysql?

MySQL is a Relational Database Management System. A relational database adds speed and...

How do I delete a MYSQL database?

Removing a database will delete that database ENTIRELY from the server. Please make sure you...