Knowledge Base » cPanel Paper Lantern MySQL Series (11)

Category > cPanel Paper Lantern MySQL Series (11)

How to setup a database using the MySQL Database Wizard in cPanel

Thursday, June 14th, 2018

How to setup a database using the MySQL Database Wizard 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 setup a database using the MySQL Database Wizard.

Click the MySQL Database Wizard icon.

Enter a name for the new database, then click Next Step.

Now we have to create a user for this database. Enter a username and create a password, then click Create User.

Click the All Privileges check box, then click Next Step.

That’s it! My MySQL database has been created, and the new user added to the database. The database name, username and password will all be needed for scripts that need to connect to the database.

Now click the MySQL Databases icon on the main page.

Here you can see the new database you just setup.

This is the end of the tutorial. You now know how to setup databases using the MySQL Database Wizard.

How to create a MySQL database in cPanel

Thursday, June 14th, 2018

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.

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

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

How to delete a MySQL database in cPanel

Thursday, June 14th, 2018

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 user in cPanel

Thursday, June 14th, 2018

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.

Click the MySQL Databases icon.

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

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 assign a user to a MySQL database in cPanel

Thursday, June 14th, 2018

How to assign a user to a MySQL database in cPanel

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

Click the MySQL Databases icon.

Now let’s learn how to assign a user to a database.

Under Add User To Database, select the user you want to add, and then select the database you want to add it to.

When ready, click Add.

Select the privileges you want to grant the user… in this case, let’s select All Privileges.

Then click Make Changes.

That’s it! The user has been assigned to the database.

You can see the user assigned to the database in the table of databases.

This is the end of the tutorial. You now know how to assign database users to databases in cPanel.

How to change a MySQL database users password in cPanel

Thursday, June 14th, 2018

How to change a MySQL database users password in cPanel

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

Click the MySQL Databases icon.

Now let’s learn how to change a database users password.

Locate the user whose password you want to change, and click Set Password.

Enter and confirm a new password, then click Change Password.

That’s it! The database user’s password has been changed.

This is the end of the tutorial. You now know how to change a database user’s password in cPanel.

How to remove a user from a MySQL database in cPanel

Thursday, June 14th, 2018

How to remove a user from a MySQL database in cPanel

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

Click the MySQL Databases icon.

Now let’s learn how to remove a user from a database.

In the table of databases, locate the database you wish to remove a user from…

… then locate the specific user assigned to that database that you want to remove… and click the delete icon.

Click Revoke User Privileges from Database to confirm.

That’s it! The user has been removed from the database.

The user hasn’t been deleted… you can see it’s still listed in the list of current users.

It has simply been removed from that database.

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

How to delete a MySQL database user in cPanel

Thursday, June 14th, 2018

How to delete a MySQL database user in cPanel

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

Click the MySQL Databases icon.

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

Locate the Current Users section at the bottom of the page, and click the Delete icon next to the user you want to delete.

Then click Delete User to confirm.

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

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

How to check a MySQL database for errors in cPanel

Thursday, June 14th, 2018

How to check a MySQL database for errors in cPanel

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

Click the MySQL Databases icon.

Now let’s learn how to check a database for errors.

Under Modify Databases, and in the Check Database drop down box, select the database you want to check.

Then click Check Database.

That’s it! The check has been completed, and no errors were found.

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

How to repair a MySQL database in cPanel

Thursday, June 14th, 2018

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.

Click the MySQL Databases icon.

Now let’s learn how to repair a database.

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.

How to manage a MySQL database with phpMyAdmin in cPanel

Thursday, June 14th, 2018

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.