Menu
▾
▴
#2550 (ok 2.11.2) Can\'t delete user with a german umlaut.
fixed
1
2013-06-11
2007-10-11
No
Hallo,
Main question:
I can create and edit a user with the name e.g. "Müller". But I can't delete this user.
additional questions:
a)
the prefered download is "phpMyAdmin 2.11.1 UTF-8". But in "config.default.php" $cfg['DefaultLang'] is set to 'en-iso-8859-1' and not 'en-utf-8'?
b)
Maybe a good idea, to set $cfg['Lang'] in "config.default.php" also to 'en-utf-8'?
c)
In "config.default.php" the $cfg['DefaultConnectionCollation'] is set to 'utf8_unicode_ci'. But for UTF-8 it should be 'utf8_general_ci'?
c) Maybe a good idea, to set $cfg['DefaultCharset'] in "config.default.php" also to 'utf-8'?
Regards,
Carsten
Logged In: YES
user_id=326580
Originator: NO
comes from htmlentities()
Logged In: YES
user_id=326580
Originator: NO
Fixed in subversion, thanks for reporting.
Logged In: YES
user_id=1910840
Originator: YES
| Fixed in subversion, thanks for reporting.
Fine, now I can delete such a user...
Another problem:
If I have e.g. a user 'Müller'@'%', I can't add the user 'Muller'@'%', which not exists yet. Error message in phpMyAdmin:
| The user 'Muller'@'%' already exists!
(which is not true)
Logged In: YES
user_id=326580
Originator: NO
this depends on your mysql collation settings, in some collations is u = ü
Logged In: YES
user_id=1910840
Originator: YES
|this depends on your mysql collation settings,
| in some collations is u =ü
Well, we are talking about the system database `mysql`, table `user` and column `User`. This table and column have allways 'utf8_bin'. The server is running with "default-character-set=utf8"
==> standard MySQL setup.
In phpMyAdmin i have the "MySQL connection collation:" set to 'utf8_gerneral_ci' (which is the standard collation for 'utf8').
So, I think that's a problem with phpMyAdmin and it must be this statement you are using to find duplicate users:
| SELECT 'foo'
| FROM `mysql`.`user`
| WHERE
| CONVERT(User USING utf8) = CONVERT('Muller' USING utf8) AND
| CONVERT(Host USING utf8) = CONVERT('%' USING utf8)
-- phpMyAdmin Version: 2.11.1
-- Server Version: 5.0.45
-- PHP-Version: 5.2.4
Logged In: YES
user_id=1910840
Originator: YES
After a small test, with:
| SELECT 'foo' FROM `mysql`.`user`
| WHERE
| CONVERT(User USING utf8) COLLATE utf8_bin = CONVERT('Muller' USING utf8) COLLATE utf8_bin AND
| CONVERT(Host USING utf8) COLLATE utf8_bin = CONVERT('%' USING utf8) COLLATE utf8_bin
I have the expected result.
Logged In: YES
user_id=326580
Originator: NO
yes, you are right, should be fixed in SVN, fix will be in next bugfix release (2.11.2)