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

Working with Databases in cPanel


Clicking on the MySQL or PostgreSQL icons on the main cPanel screen will allow you to create or work with those types of databases. The interfaces that cPanel uses for both types of databases are remarkably similar and since most hosts only offer MySQL, we will focus on that (noting where the PostgreSQL interface differs from the one for MySQL).

There are four main sections to the MySQL/PostgreSQL cPanel screen (referred to as the database screen from now on). The first section allows you to create and work with the databases themselves. The section below that allows you to create users that will be able to access one or more databases. Next, if your web host permits, you can set up remote access to your databases. Finally, there is a link to phpMyAdmin or phpPgAdmin, web interfaces for advanced work with your databases.

Creating a Database

Creating databases and users is easy but not the most intuitive process. The first thing you need to do to create a database...