How to create a MySQL database user in cPanel

cPanel Paper Lantern MySQL series

4. How to create a MySQL database user in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.

Now let’s learn how to create a MySQL database user.

Click the “MySQL Databases” icon.

Under “Add New User”, enter a username for the user you want to create, along with a password.

Then click “Create User”.

That’s it! The new database user has been created.

You can see the new database user listed at the bottom of the page.

This is the end of the tutorial. You now know how to create a MySQL database user in cPanel.

How to delete a MySQL database in cPanel

cPanel Paper Lantern MySQL series

3. How to delete a MySQL database in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.

Now let’s learn how to delete a MySQL database.

Click the “MySQL Databases” icon.

Locate the database name you want to delete, and click the “Delete Database” link next to it.

Then click “Delete Database” to confirm.

That’s it! The MySQL database has been deleted.

This is the end of the tutorial. You now know how to delete a MySQL database in cPanel.

How to create a MySQL database in cPanel

cPanel Paper Lantern MySQL series

2. How to create a MySQL database in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.

Now let’s learn how to create a MySQL database.

Click the “MySQL Databases” icon.

Enter a name for the new database, then click “Create Database”.

That’s it! A new MySQL database has been created.

The new database is listed on the databases page, under “Current Databases”.

This is the end of the tutorial. You now know how to create a MySQL database in cPanel.

How to manage a MySQL database with phpMyAdmin in cPanel

cPanel Paper Lantern MySQL series

11. How to manage a MySQL database with phpMyAdmin in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.

Now let’s learn how to manage a database with phpMyAdmin.

Click the “phpMyAdmin” icon.

This is the phpMyAdmin main page. It is from here that you can manage all MySQL databases that exist in your hosting account.

In the top left corner, you’ll see an entry with your account user name. Click the “plus sign” to its left.

You’ll now see a list of databases in your account. Click the one you want to manage.

You can now start managing your database. You can manage tables, add or delete entries, and perform queries among other things.

We won’t get into specifics… check out our phpMyAdmin series of tutorials for further details.

This is the end of the tutorial. You now know how to manage a MySQL database with phpMyAdmin.

How to repair a MySQL database in cPanel

cPanel Paper Lantern MySQL series

10. How to repair a MySQL database in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.

Now let’s learn how to repair a database.

Click the “MySQL Databases” icon.

Under “Modify Databases”, and in the “Repair Database” drop down box, select the database you want to repair.

Then click “Repair Database”.

That’s it! The database has been repaired.

This is the end of the tutorial. You now know how to repair a database in cPanel.