Solution For “No tables found in database” Mysql Error In phpMyAdmin

Updated: November 8, 2019 / Home » The Web » Tutorials, Optimization, and SEO

Are you having the “No tables found in database” error where accessing them via phpmyadmin is not possible while the websites or blogs runs perfectly without any problem? The pulldown correctly lists the number of tables next to the database name [example: “blogA (13)” and blogB (18)] in the pulldown.

Alternative 2020 Article ➤ 7 Must Use SQL Queries To Clean And Optimize WordPress MySQL Database

Solution For

If your phpMyAdmin no longer sees any tables in any of your local databases, that is because permissions change away from mysql.mysql on any database directory under /var/lib/mysql to, say, root.root (most probably).

Long story short, you will have to change the owner from root.root to mysql.mysql, to do this, you’ll need root access and putty. Key in this command.

chown -R mysql.mysql /var/lib/mysql/*

This will most probably solve your ‘No Table Found’ problem, it took me much searching and trial and error to resolve this issue, not to mention growing a really long beard while waiting for your web hosting to figure out the problem, let alone replying you. Cheers.