# Help Category: Databases

> Canonical: https://jethost.com/kb/category/db/ · Results: 13 · Page 1 of 2

JetHost Databases help explains how to create databases, manage users, and work with phpMyAdmin and phpPgAdmin. The articles show how to run basic queries, import and export data, and handle common database tasks in a clear, simple way.

- [Back Up & Restore a PostgreSQL Database](https://jethost.com/kb/back-postgresql-backup-restore/) — Backing up a PostgreSQL database means exporting it to a file; restoring or moving it means importing that file back. Both are done in phpPgAdmin in cPanel – handy before a big change, or when moving a site to JetHost. This guide covers export and import, step by step. phpPgAdmin is included with every JetHost […]
- [How to access phpPgAdmin in cPanel?](https://jethost.com/kb/how-to-access-phppgadmin-in-cpanel/) — phpPgAdmin is the web-based tool for managing your PostgreSQL databases from the browser – the PostgreSQL equivalent of phpMyAdmin. It’s built into cPanel, and it’s where you go to browse data, run queries, and back up or restore a database. This guide shows how to open it and what you can do inside. phpPgAdmin comes […]
- [How to create a PostgreSQL database?](https://jethost.com/kb/create-postgresql-database/) — PostgreSQL is a powerful open-source database, and it’s available on your JetHost hosting alongside MySQL. The quickest way to set one up is the PostgreSQL Database Wizard in cPanel, which creates the database, a user, and the privileges in one guided flow. This guide walks you through it. Open the PostgreSQL Database Wizard Step 1: […]
- [MySQL Character Set & Collation Explained](https://jethost.com/kb/mysql-character-set-collation-explained/) — Ever seen strange symbols where accented letters or emoji should be? That’s almost always a character set or collation mismatch. This guide explains both in plain terms and gives you the settings to use, so text stores and displays correctly – especially on multilingual sites and during migrations. What is a MySQL character set? A […]
- [MySQL Single, Double & Backtick Quotes Explained](https://jethost.com/kb/mysql-single-double-backtick-quotes-explained/) — In MySQL, the type of quote you use around a value or a name changes what it means – and mixing them up is a classic cause of syntax errors. This guide explains when to use single quotes, backticks, and double quotes, with clear examples. Single MySQL quotes: for string values Single quotes wrap string […]
- [How to Manage MySQL User Privileges](https://jethost.com/kb/how-to-manage-mysql-user-privileges/) — Privileges decide what a MySQL user is allowed to do with a database. On shared hosting you manage them in cPanel – no SQL needed. On a VPS or dedicated server with root access, you can also use SQL commands. This guide covers both, starting with the cPanel way most people need. Every JetHost web […]
- [How to Connect to MySQL Remotely (SSH Tunnel)](https://jethost.com/kb/how-to-connect-to-mysql-remotely-ssh-tunnel/) — Need to connect to your JetHost database from a desktop tool like HeidiSQL or MySQL Workbench? Direct remote MySQL connections are blocked at the firewall for security – even if you whitelist your IP. The safe, supported way to connect is through an SSH tunnel, available on every JetHost web hosting plan. This guide shows […]
- [How to Repair & Optimize a MySQL Database](https://jethost.com/kb/how-to-repair-optimize-a-mysql-database/) — Over time a MySQL database can pick up small problems: a crashed table after an interrupted write, or wasted space that slows queries down. Two quick jobs keep it healthy – repair fixes damaged tables, and optimize reclaims space. This guide shows both in phpMyAdmin. When you need this Repair a database when your site […]
- [Back Up & Restore a MySQL Database (phpMyAdmin)](https://jethost.com/kb/mysql-backup-restore/) — Backing up a MySQL database means exporting it to a file you keep safe; restoring or moving it means importing that file back. This guide shows both, using phpMyAdmin in cPanel – handy for backups before a big change, or for moving a site to JetHost. phpMyAdmin is available on every JetHost web hosting plan. […]
- [phpMyAdmin](https://jethost.com/kb/phpmyadmin/) — phpMyAdmin is a free, web-based tool for managing your MySQL databases straight from the browser – no software to install. It’s built into cPanel, and it’s where you go to view your data, run queries, and back up or restore a database. This guide shows how to open it and what you can do once […]

> Next: https://jethost.com/kb/category/db/page/2/