Category: Hosting, cPanel & Site Administration
Audience: Clients of Thomas McKee Website Design & SEO Solutions who need to view or adjust website files and databases within cPanel.
Goal: Teach clients how to safely use File Manager, manage databases, and understand phpMyAdmin access without breaking their website or risking data loss.

Introduction

Every website runs on a collection of files and databases that work together to display pages, store content, and process information.

Inside cPanel, tools like File Manager, MySQL Databases, and phpMyAdmin allow you to access these components directly. However, they should be used carefully — even a small mistake (like deleting one configuration line) can take your website offline.

At Thomas McKee Website Design & SEO Solutions, we encourage our clients to use these tools for observation and light maintenance, while leaving deeper tasks (edits, migrations, cleanups) to our support team.

This article explains how each tool works, what you can safely do, and when to contact us for help.

1. Overview of Website Structure

A standard website has two main parts:

These two must stay synchronized for your site to work properly.

2. Understanding File Manager

2.1 What File Manager Is

The File Manager in cPanel lets you view and manage all files stored in your hosting account through a browser — no need for FTP or command-line access.

It’s ideal for:

• Uploading or downloading files

• Editing configuration files

• Managing images or documents

• Creating backups of single files

3. Accessing File Manager

1. Log into cPanel.

2. Scroll to the Files section.

3. Click File Manager.

You’ll see your file structure in a tree view on the left and details on the right.

3.1 Key Folders

4. Navigating the File Structure

• Double-click a folder to open it.

• Use the breadcrumb bar at the top to move backward.

• Right-click files or folders for context actions (Edit, Download, Rename, Delete).

• Use the Search Bar to locate files quickly by name.

4.1 Sorting Files

Click the column headers (e.g., Last Modified, Size) to sort.
This helps when checking which plugin or file was recently updated.

5. Common File Tasks (Safe Operations)

5.1 Uploading Files

1. Click Upload at the top.

2. Select the destination folder (usually /public_html/).

3. Choose your file and confirm.

5.2 Downloading Files

• Right-click → Download to save a local copy before editing.

5.3 Editing Files

1. Right-click a file → Edit or Code Edit.

2. Make small, careful adjustments (like updating text or image paths).

3. Click Save Changes.

5.4 Creating or Renaming

• Click +File or +Folder.

• Use lowercase names without spaces.

5.5 Deleting

• Only delete files you are 100% sure of.

• Avoid removing .htaccess, wp-config.php, or any folder in /wp-content/.

6. Important File Types to Know

7. File Permissions and Ownership

7.1 Safe Permission Values

To view or adjust permissions:

1. Right-click the file → Permissions.

2. Adjust if directed by our support team only.

Incorrect permissions can break WordPress or cause 403 errors.

8. Creating Manual Backups Before Edits

Before changing or deleting anything:

1. Right-click the file or folder.

2. Click Compress.

3. Download the .zip backup to your computer.

If something goes wrong, you can easily restore the compressed version.

9. Understanding Databases

9.1 What a Database Does

The database stores:

• Page content, posts, and settings

• User information

• Plugin and theme configurations

WordPress websites connect to a MySQL/MariaDB database using credentials stored in wp-config.php.

10. Managing Databases in cPanel

1. Log into cPanel.

2. Scroll to Databases.

3. Choose one of the following:

   • MySQL® Databases — to create or delete databases/users.

   • phpMyAdmin — to view or manage data directly.

11. Creating a New Database (for Advanced Users)

You won’t normally need this unless directed by our team.
To create one:

1. Go to MySQL Databases.

2. Under Create New Database, enter a name.

3. Under MySQL Users, create a username and password.

4. Assign the user to the database → check All Privileges → Make Changes.

We’ll use these credentials when installing a new WordPress site or migrating content.

12. Accessing phpMyAdmin

12.1 What phpMyAdmin Is

phpMyAdmin provides a visual interface for viewing and editing database content.

You can:

• View tables and data

• Export or import databases

• Optimize or repair tables

⚠️ Use caution. phpMyAdmin changes take effect immediately and cannot be undone without a backup.

13. phpMyAdmin: Common Safe Actions

13.1 Viewing Data

1. Log in to cPanel → phpMyAdmin.

2. Select your database in the left sidebar.

3. Click a table (e.g., wp_posts or wp_users).

4. Click Browse to view contents.

13.2 Exporting a Database

1. Select your database.

2. Click Export.

3. Choose Quick → SQL.

4. Click Go.

5. Save the file to your computer.

This is the safest way to create a backup before edits or migrations.

13.3 Repairing a Database Table

If WordPress shows “Error establishing a database connection”:

1. In phpMyAdmin, check all tables.

2. At the bottom, choose Repair Table.

3. Reload your site to verify resolution.

14. Actions to Avoid in phpMyAdmin

❌ Do not delete or empty any table unless explicitly instructed.
❌ Do not manually edit rows in wp_options, wp_users, or wp_posts unless you know their structure.
❌ Do not import large SQL files without confirming compatibility.
❌ Never rename database tables — it will break your WordPress installation.

If you’re unsure, export the database first and contact us for help.

15. Database Optimization (Safe Maintenance)

Occasionally, databases accumulate overhead from deleted posts or plugin activity.

To safely optimize:

1. Log in to phpMyAdmin.

2. Select your database.

3. Check all tables.

4. From the dropdown menu, select Optimize Table.

This removes unnecessary data and improves performance.

16. Using the File Manager and Database Together

Sometimes you’ll reference both tools:

• You may edit wp-config.php to confirm your database name, username, and password.

• You might upload a new configuration file after a site migration.

Always:

• Confirm file and database names match.

• Create a backup of both before changes.

• Contact us if anything doesn’t line up — incorrect settings cause “Error establishing database connection.”

17. Troubleshooting Common Issues

18. When to Contact Support

Reach out to Thomas McKee Website Design & SEO Solutions immediately if:

• You accidentally deleted files or folders.

• Your site shows “Database Connection Error.”

• You see corrupted data or foreign entries in phpMyAdmin.

• A plugin update caused layout or login issues.

• You suspect malware or hacked files.

We can restore your site from backup or correct file/database mismatches safely.

19. Client Safety Checklist

✅ Access File Manager via cPanel only — not via FTP unless instructed.
✅ Always back up before edits or deletions.
✅ Never modify .htaccess or wp-config.php without guidance.
✅ Export your database before any major changes.
✅ Check your SSL padlock and backups regularly.
✅ Contact support for database or security concerns.

Conclusion

Your hosting tools give you powerful access to your website’s inner workings — but with great power comes great responsibility.

By understanding File Manager, databases, and phpMyAdmin, you can monitor and maintain your website confidently without taking unnecessary risks.

At Thomas McKee Website Design & SEO Solutions, we encourage our clients to explore, learn, and grow — while we provide the technical safety net that ensures every change can be reversed and every website stays secure.

If you ever feel unsure, reach out. We’ll handle the heavy lifting — quickly, safely, and professionally.