Working with Databases | cPanel User Guide and Tutorial

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

cPanel User Guide and Tutorial

By : Aric Pedersen

4.4 (12)

cPanel User Guide and Tutorial

4.4 (12)

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.

cPanel: User Guide and Tutorial

cPanel: User Guide and Tutorial

Credits

Credits

About the Author

About the Author

Preface

Preface

Free Chapter

Introduction to cPanel Hosting

Introduction to cPanel Hosting

Webmaster, Meet cPanel…

What Tools Will You Need?

Finding cPanel Web Hosting

Questions to Ask Hosting Companies

Summary

Getting Started with cPanel

Getting Started with cPanel

Logging into cPanel

The Main cPanel Interface

Summary

FTP and cPanel’s File Manager

FTP and cPanel’s File Manager

FTP Basics

Creating and Managing FTP Accounts in cPanel

Anonymous FTP Access

cPanel FTP Session Control

Other Types of FTP Connections

cPanel’s File Manager

Summary

Working with Mail

Working with Mail

Why Manage your Own E‑mail Accounts?

Common E‑mail Terms

Accessing cPanel’s E‑mail Features

Managing POP3 and IMAP E‑mail Accounts

Creating an E‑mail Account

Configuring your E‑mail Client to Use your New Address

Changing Advanced E‑mail Options and Monitoring your E‑mail Account

Web Mail

E‑mail Forwarders (Aliases)

E‑mail Domain Forwarding

Mailing Lists

Dealing with Unsolicited E‑mail (SPAM)

Default (Catch All) E‑mail Address

E‑mail Auto‑Responders

Advanced E‑mail Tools

Summary

Working with Databases

Working with Databases

Database 101

Working with Databases in cPanel

phpMyAdmin and phpPgAdmin

Summary

Controlling Access to and Organizing Your Data

Controlling Access to and Organizing Your Data

Changing your cPanel Password

Subdomains

Redirects

Hotlink Protection: Stop People from Stealing Content

Password-Protect Directories

Leech Protect: Keep Users from Giving Away Access to your Site

Index Manager

IP Deny Manager

Custom Web Error Messages

Summary

Keeping an Eye on Account Activity

Keeping an Eye on Account Activity

Web Statistics: What’s Going On?

Raw (Apache) Web Logs

Web Stats to the Rescue!

Other Related Tools

Summary

Backing up and Restoring Data

Backing up and Restoring Data

Backups and their Importance

Automated Unattended Backups

Restoring Backups

Summary

Working with Scripts

Working with Scripts

What are Web Scripts?

The Scripts cPanel Offers for Installation

Advice on Working with Scripts

Summary

Advanced cPanel Features

Advanced cPanel Features

Welcome to cPanel 102

FrontPage Extensions

Add‑on Domains

Parked Domains

Cron Jobs

SSH/Telnet

MIME Types

Apache Handlers

OpenPGP Keys

SSL Management

Network Tools

cPanel Pro

Summary

Site and Account Security

Site and Account Security

Site Security and You

The Security Plan

What to do if the Worst Happens

Summary

Third‑Party Additions to cPanel

Third‑Party Additions to cPanel

cPanel Themes: New Look, New Features

Third‑Party Add‑ons

Summary

Useful Tools and Links and the Final Curtain Call

Useful Tools and Links and the Final Curtain Call

FTP Clients

Additional cPanel Information

Basic Webmaster and Scripting Assistance

Domain, DNS, and Site Monitoring Tools

Password Storing Programs

Curtain Call

Glossary

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...

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

cPanel User Guide and Tutorial

Search

Your notes and bookmarks