Book Image

cPanel User Guide and Tutorial

By : Aric Pedersen
Book Image

cPanel User Guide and Tutorial

By: Aric Pedersen

Overview of this book

"A great book for getting the most out of your cPanel-supporting web host" If you have web hosting requirements beyond the most basic, you should look for a host that offers cPanel. cPanel gives you tight control over every aspect of your web site, email accounts, and domain names. But once you've got a web site with cPanel support, how do you go about using it? While the documentation included with cPanel may provide a quick reference, to really get the most from it you need a more detailed, systematic tutorial. Read this book to find out exactly how to get the most from cPanel in all aspects of your web site management: web, email, FTP, security, domains, back ups, and more.
Table of Contents (18 chapters)
cPanel: User Guide and Tutorial
Credits
About the Author
Preface
Glossary

Chapter 5. Working with Databases

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.

Database 101

Defined generally, a database is a collection of information designed to make later retrieval easier. If you have ever used Microsoft Access or FileMaker Pro, you are probably familiar with databases. If not, then your eyes...