diff options
-rw-r--r-- | ChangeLog | 4 | ||||
-rw-r--r-- | server_privileges.php | 2 |
2 files changed, 5 insertions, 1 deletions
@@ -5,6 +5,10 @@ phpMyAdmin - ChangeLog $Id$ $HeadURL$ +2006-12-05 Marc Delisle <lem9@users.sourceforge.net> + * server_privileges.php: Grant all privileges on wildcard name: we should + really grant on username\_ instead of username_ + 2006-12-05 Michal Čihař <michal@cihar.com> * server_privileges.php: Add IF NOT EXISTS to CREATE DATABASE query (RFE #1608372), reload navigation after creating database. diff --git a/server_privileges.php b/server_privileges.php index 3d8362dd3f..17708a2ed4 100644 --- a/server_privileges.php +++ b/server_privileges.php @@ -846,7 +846,7 @@ if (!empty($adduser_submit) || !empty($change_copy)) { $sql_query .= $q; PMA_DBI_try_query($q) or PMA_mysqlDie(PMA_DBI_getError(), $sql_query); } elseif ($createdb == 2) { - $q = 'GRANT ALL PRIVILEGES ON ' . PMA_backquote(PMA_sqlAddslashes($username) . '_%') . '.* TO \'' . PMA_sqlAddslashes($username) . '\'@\'' . $hostname . '\';'; + $q = 'GRANT ALL PRIVILEGES ON ' . PMA_backquote(PMA_sqlAddslashes($username) . '\_%') . '.* TO \'' . PMA_sqlAddslashes($username) . '\'@\'' . $hostname . '\';'; $sql_query .= $q; PMA_DBI_try_query($q) or PMA_mysqlDie(PMA_DBI_getError(), $sql_query); } |