phpmyadmin

melkoraton · 06-22-2010, 08:47 AM

currently i have lots of databases on MySQL so every time when I login into phpmyadmin the MySQL server freezes or gets loads of charge cause of the show database; query, is there a way to disable this from phpmyadmin coe, cause i tried removing the show database privilege from the mysql user and it didn't work.
thx in advance

subho.d · 06-23-2010, 02:34 AM

Download update phpmyadmin and update ur php then reconfigure that i think your problem will solve ...

Quote:

How much TB of data in ur Mysql have ?

melkoraton · 06-23-2010, 12:15 PM

i dont have lot of Gb i think is like 100gb but the thing is that there are a lot of DBs like 12 thousand that;s the issue

bathory · 06-23-2010, 12:32 PM

Hi,

You can take a look at the following 2 options of phpmyadmin

Quote:

$cfg['Servers'][$i]['only_db']
$cfg['Servers'][$i]['hide_db']

Regards