[Phpmyadmin-devel] Create Database

[Tom Sommer - dreamcoder.dk]

Hey,

I'm having some problems with the "Create Database" form being shown on 
the front page, even if the user does not have permission to create a 
new database.


I traced the problem down to line 246 in main.php (r: 2.8.2.1):

  else if (ereg($re0 . '%|_', $show_grants_dbname) || 
!PMA_mysql_select_db($show_grants_dbname, $userlink) && @mysql_errno() 
!= 1044) {

Where it is the ereg($re0 . '%|_', $show_grants_dbname) parts that 
returns true (1).

Now, I don't really know what this ereg() does, except for this part:
$re0 = '(^|(\\\\\\\\)+|[^\])';
Which I am sorry to say I don't understand.

So, I'm willing to fix the problem on my own (and submit a patch), if I 
could just get past this point. The problem is that my GRANT line looks 
like this:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE 
TEMPORARY TABLES, LOCK TABLES ON `domain_net_db`.* TO 'domain_net'@'%'

Which makes $show_grants_dbname contain `domain_net_db` and makes the 
ereg() return 1.

So in other words, what does the ereg do?

Thanks for any help

-- 
Tom Sommer