Overview

phpMyAdmin is an outside tool for working with MySQL® and MariaDB® databases, for instance to add or remove rows. Its usage is covered on the phpMyAdmin website.

MySQL 8.0 and later caching

From version 8.0 onward, MySQL caches table statistics by default. Without extra configuration, changes to tables and their metadata can take as long as 24 hours to show in phpMyAdmin. After deleting data, for example, the real table size shrinks while phpMyAdmin may keep showing the old size for up to a day.

Adjust this behavior with the information_schema_stats_expiry variable.

Was this answer helpful? 0 Users Found This Useful (0 Votes)

Most Popular Articles

Manage PostgreSQL databases with phpPgAdmin in cPanel

Overview phpPgAdmin is an external web tool for working with PostgreSQL® databases, for instance...
Create a MySQL database and user with the cPanel wizard

Follow these steps to create a database and its user with the wizard. Type a name for the...
Create and manage MySQL databases in cPanel

Create a database Follow these steps to add a new database: Type a name for the database into...
Create a PostgreSQL database and user with the wizard

Set up a database Note: Database and user names can be at most 63 characters long. If your...
Allow remote MySQL connections in cPanel

Overview Remote Database Access lets other servers connect to the MySQL® or MariaDB® databases of...