Kualo / docs

Databases

17 articles
How to create a MySQL database in cPanel
Popular
Use the Database Wizard in cPanel to create a MySQL database, add a user, and grant privileges in a few quick steps.
Becoming familiar with databases in phpMyAdmin
A quick guide to the main features of phpMyAdmin and how to work with your databases and tables.
Creating tables in a database with phpMyAdmin
Learn how to create a new table inside a MySQL database using phpMyAdmin in cPanel.
Deleting tables from a database with phpMyAdmin
Learn how to permanently delete a table from your database using phpMyAdmin in cPanel.
Inserting fields into database tables with phpMyAdmin
Learn how to add a new field (column) to a database table using phpMyAdmin in cPanel.
Modifying fields in database tables with phpMyAdmin
Learn how to edit a field in a database table - change its name, type, length or default - using phpMyAdmin in cPanel.
Deleting fields from database tables with phpMyAdmin
Learn how to delete a field (column) from a database table using phpMyAdmin in cPanel, and how to do it safely.
Renaming database tables with phpMyAdmin
Learn how to rename a table in a database using phpMyAdmin in cPanel, keeping all of its columns and data.
Copying a database table with phpMyAdmin
Copy any database table in phpMyAdmin in just a few steps, with options to copy the structure, data, or both.
Exporting databases and tables with phpMyAdmin
Learn how to export a database or a single table as a SQL file in phpMyAdmin, for backups or moving your data.
Importing databases and tables with phpMyAdmin
Learn how to import a SQL file into a database using phpMyAdmin in cPanel, to restore a backup or move data in.
Running SQL queries on a database with phpMyAdmin
phpMyAdmin lets you run SQL queries directly against your database tables from within cPanel.
Searching through a database with phpMyAdmin
Use phpMyAdmin's Search feature to find specific words or values across tables in your MySQL database.
How to access MySQL remotely
Kualo blocks direct external MySQL connections, but you can access MySQL remotely using an SSH tunnel.
How to set up a secure remote MySQL connection
Connect to your MySQL database remotely and securely using SSH tunnelling with MySQL Workbench or HeidiSQL.
How to Import a Large MySQL Database via SSH
If phpMyAdmin times out or refuses your SQL file because it is too large, importing via SSH is the reliable alternative. This guid...
Troubleshooting 'Error Establishing a Database Connection'
The 'Error Establishing a Database Connection' message means your application cannot connect to its MySQL database. Follow these s...
Didn't find your answer?
Ask us anything - real people, around the clock.