If you plan to do any work involving web scripts on your website, or if you need to store data on your website in a way that allows for dynamic retrieval of that data later, you will want to work with databases. cPanel includes a number of tools to make working with databases easier. In this chapter, you will learn how to:
Create a database
Create database users
Add users to the database
Change common connection settings for databases
Delete databases and users
Check for damage, repair, and optimize databases
Work with databases using phpMyAdmin or phpPgAdmin
Back up databases with phpMyAdmin or phpPgAdmin
Before you can learn how to use databases, however, we first need to figure out what they are and why we might need to use them.