LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   phpmyadmin - show databases (https://www.linuxquestions.org/questions/linux-software-2/phpmyadmin-show-databases-815653/)

melkoraton 06-22-2010 08:47 AM
phpmyadmin - show databases
 
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


All times are GMT -5. The time now is 05:53 AM.