diff options
| author | Sebastian Mendel <cybot_tm@users.sourceforge.net> | 2007-10-15 13:20:30 +0400 |
|---|---|---|
| committer | Sebastian Mendel <cybot_tm@users.sourceforge.net> | 2007-10-15 13:20:30 +0400 |
| commit | bb7587aabb0100d4eb287309caf80a499cbfc4a1 (patch) | |
| tree | c4f5bb710723d74924db06419c0a40b55a4c9b16 /server_privileges.php | |
| parent | b99b77cb64a398ba562796828950e709cf3e0f0d (diff) | |
bug #1811519 [privileges] fixed used collation for accessing mysql.user in server privileges
Diffstat (limited to 'server_privileges.php')
| -rw-r--r-- | server_privileges.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/server_privileges.php b/server_privileges.php index 1d73adc6c7..40513e2d9c 100644 --- a/server_privileges.php +++ b/server_privileges.php @@ -749,10 +749,10 @@ if (!empty($adduser_submit) || !empty($change_copy)) { } $res = PMA_DBI_query( 'SELECT \'foo\' FROM `mysql`.`user`' - .' WHERE ' . PMA_convert_using('User') - .' = ' . PMA_convert_using(PMA_sqlAddslashes($username), 'quoted') - .' AND ' . PMA_convert_using('Host') - .' = ' . PMA_convert_using($hostname, 'quoted') . ';', + .' WHERE CONVERT(`User` USING utf8) COLLATE utf8_bin ' + .' = CONVERT(\'' . PMA_sqlAddslashes($username) . '\' USING utf8) COLLATE utf8_bin ' + .' AND CONVERT(`Host` USING utf8) COLLATE utf8_bin ' + .' = CONVERT(\'' . PMA_sqlAddslashes($hostname) . '\' USING utf8) COLLATE utf8_bin ;', null, PMA_DBI_QUERY_STORE); if (PMA_DBI_num_rows($res) == 1) { PMA_DBI_free_result($res); |