# Help Category: MySQL

> Canonical: https://jethost.com/kb/category/mysql/ · Results: 10

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

- [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. On shared hosting: […]
- [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. This guide shows how. Why an SSH tunnel, not direct […]
- [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. Open phpMyAdmin Log in to cPanel and, in the […]
- [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 […]
- [How to Find MySQL Database Details on cPanel](https://jethost.com/kb/how-to-find-your-mysql-database-details-on-cpanel/) — Need to plug a site or application into its database? This quick guide shows exactly where to locate the database name, username, host, and port inside cPanel. Step 1: Log in to cPanel 1. Sign in to your cPanel account.2. From the dashboard, go to the Databases section. Step 2: View current databases 1. Click […]
- [How to Use Database Wizard](https://jethost.com/kb/how-to-use-mysql-database-wizard/) — The Database Wizard in cPanel lets you create a database, add a user, and assign privileges in one guided flow. This article walks you through each step so you can complete the setup quickly and correctly. Step 1: Access the Database Wizard in cPanel 1. Log in to your cPanel account.2. Scroll to the Databases […]
- [How to create a MySQL database, user, and assign privileges](https://jethost.com/kb/creating-a-mysql-database-and-user-in-cpanel/) — MySQL is a popular database system that powers many websites and applications. In this guide, you’ll learn how to create a new MySQL database in cPanel, add a database user, and grant the user access to the database. All steps are in one streamlined process. Step 1: Access the MySQL Databases in cPanel 1. Log […]