How to check a MySQL database for errors in cPanelThis 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 cPanelThis 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 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 setup a database using the MySQL Database Wizard in cPanelThis 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.
Renaming database tables with phpMyAdmin This video assumes you've already logged in to phpMyAdmin. Now let's learn how to rename a database table. First, select the database where the table exists... ... then click the table you want to rename. Click the Operations tab. Under Table Options, in the Rename table to section, enter a new name for the table, then click Go. That's it! The table has been renamed, as can be seen here in the left pane. This is the end of the tutorial. You now know how to rename a database table with phpMyAdmin.
.png "Microsoft Visio")
.png "VMware")
