MySQL
MySQL Optimization and Repair with phpMyAdmin
Last Updated: Sep 24 2025This article guides you step by step through everything you can do directly in phpMyAdmin to keep your database healthy and fast: checking, analyzing, optimizing, repairing, indexes, charset, collation, plus a few useful SQL recipes. It is written for modern MySQL/MariaDB and assumes you have access to phpMyAdmin with a user that has sufficient privileges....
I can’t connect to the MySQL database
Last Updated: Jul 31 2025After creating a database (and uploading it), you need to create a MySQL user and add it to the database. To do this, go to cPanel/MySQL and under the User section, enter the username and password. Once the user is created, add it to the database by clicking the “Add User to Db” button. Both...
How to access phpMyAdmin from cPanel
Last Updated: Jul 31 2025phpMyAdmin is a web interface for working with a MySQL database.Attention! The phpMyAdmin provided with cPanel does not allow creating or deleting MySQL databases. For this, use the MySQL button in cPanel.With phpMyAdmin, you can modify content, delete or add new data, as well as run SQL commands (requires knowledge).When you want to work on...