PHPMyAdmin shows every database when logging in as a user

PHPMyAdmin shows every database when logging in as a user

If phpmyadmin shows all the databases on a server when it should only show the users databases do the following:

First be sure a MySQL root password is set.

Add safe-show-database in the mysqld section of /etc/my.cnf


[mysqld]
safe-show-database

Then restart mysql.

If this does not work do the following:

mysql -u root -p mysql

update `user` set Create_tmp_table_priv = ‘N’, Lock_tables_priv = ‘N’ where user <> ‘root’;

Go back to shell and run mysqladmin reload

If you get an error about a column not found run the following:

mysql_fix_privilege_tables [mysql root password]

then rerun the update command.

  • 0

How to Block Bots using Robots.txt File?

How to Block Bots using Robots.txt File? The robots.txt file is a simple text file placed on...

PageSpeed on cPanel Server

PageSpeed on cPanel Server PageSpeed on cPanel Server PageSpeed (mod_pagespeed) is a module for...

How to change cPanel logout URL

How to change cPanel logout URL Do you know that it is possible to change cPanel logout URL any...

How to Change cPanel Style

How to Change cPanel Style How to Change cPanel Style cPanel is the most popular control panel...