To clear the cache in phpMyAdmin, you need to process the browser, MySQL server and phpMyAdmin's own cache separately: 1. Clear the browser cache and perform hard refresh (Ctrl Shift R or Cmd Shift R); 2. Execute FLUSH TABLES; and FLUSH STATUS in the SQL tag of phpMyAdmin (query cache is not supported in MySQL 8.0); 3. Log out and delete phpMyAdmin related cookies (such as pma_user_config, phpMyAdmin, etc.) and log in again; 4. If you have permission, restart MySQL service (such as sudo systemctl restart mysql) to completely clear the server cache. Combining the above steps can effectively solve most caching problems.

Clearing cache in phpMyAdmin isn't done directly through the phpMyAdmin interface, since it doesn't have a built-in "clear cache" button. However, the "cache" you're likely dealing with comes from either your browser, MySQL server, or phpMyAdmin's internal mechanisms (like query caching or table information caching). Here's how to handle each:

1. Clear Browser Cache

Since phpMyAdmin is web-based, your browser may cache outdated views or login sessions.

Steps:

• Press Ctrl Shift Delete (Windows) or Cmd Shift Delete (Mac)
• Select time range: "All time" or "Everything"
• Check boxes for Cached images and files
• Click "Clear data"

Alternatively, do a hard refresh:

• Ctrl F5 or Ctrl Shift R (Windows/Linux)
• Cmd Shift R (Mac)

This ensures you're seeing the latest version of phpMyAdmin and database changes.

2. Flush MySQL Server Cache

If you're seeing stale query results or metadata, the MySQL server might be caching data.

You can run these SQL commands in phpMyAdmin's SQL tab:

 -- Clear query cache (if query cache is enabled)
FLUSH QUERY CACHE;

-- Remove all query cache memory allocation
RESET QUERY CACHE;

-- Flush tables and close open handlers
FLUSH TABLES;

-- Refresh host cache (helps if DNS/connection issues)
FLUSH HOSTS;

-- Clear status variables (optional)
FLUSH STATUS;

?? Note: In MySQL 8.0 , the query cache is removed , so FLUSH QUERY CACHE won't work. Instead, focus on metadata and table caches.

For table and metadata cache:

 FLUSH TABLES;
FLUSH TABLE_STATISTICS;
FLUSH STATUS;

3. Clear phpMyAdmin's Internal Metadata Cache

phpMyAdmin sometimes caches table structures or relationships, especially if you've renamed or altered tables.

Solution:

• Log out of phpMyAdmin
• Delete the phpmyadmin cookies in your browser (look for pma_user_config , pma_lang , phpMyAdmin )
• Log back in

Alternatively, if you're using phpMyAdmin configuration storage (for bookmarks, saved queries, etc.), you can:

• Go to the Operations tab of any database
• Look for “phpMyAdmin configuration storage” section
• Click Clear on stored queries or bookmarks if needed

4. Restart Services (if you have server access)

If you're on a local or private server (like XAMPP, WAMP, or Linux with Apache/MySQL):

 # On Linux (if using systemd)
sudo systemctl restart mysql
# or
sudo systemctl restart mariadb

# Optionally restart Apache too
sudo systemctl restart apache2

This clears most server-level caches and resets connections.

Summary

To effectively "clear cache" in phpMyAdmin:

• ? Clear your browser cache and cookies
• ? Run FLUSH TABLES; and FLUSH STATUS; in the SQL tab
• ? Use hard refresh to reload the interface
• ? Restart MySQL if changes aren't reflecting

It's not a single button, but combining these steps usually resolves caching issues.

Basically, most of the time, it's either the browser or MySQL server holding onto old data — so tackle both.

The above is the detailed content of How to clear cache in phpMyAdmin. For more information, please follow other related articles on the PHP Chinese website!