0

One of my db have tables around 10000(temporary use). But what it has done that opening phpmyadmin become slow and my version is "2.6.0-pl2".

Because of this version I cannot use skip_db option of phpmyadmin.

So I decided to have a new user with permission to all database except one but I don't know how to do that.

So can someone tell me how to write grant to all db with skipping just one db ?

mtk
  • 13,221
  • 16
  • 72
  • 112
Leana D cruz
  • 5
  • 3

1 Answers1

0

There is no need to create a user for this problem.

use show database command and you will get list of db.

In phpmyadmin version "2.6.0-pl2" , you can use show_db variable and set all tables there are your problem will be solved

chicharito
  • 1,047
  • 3
  • 12
  • 41