Menu
▾
▴
#2581 (ok 2.11.3) unable to add user to mysql < 4.1
phpmyadmin 2.11.2
MySQL 3.23.58
PHP 4.4.7
When attempting to add a MySQL user privilege on the latest version it fails, PHPMyAdmin 2.11.1 works fine as it appears to use a different syntax (without utf8 which 3.23 doesn't support). Perhaps an IF mysql version<4.0 condition is required here?
error:
SQL query:
SELECT 'foo'
FROM `mysql`.`user`
WHERE CONVERT( `User`
USING utf8 )
COLLATE utf8_bin = CONVERT( 'testuser'
USING utf8 )
COLLATE utf8_bin
AND CONVERT( `Host`
USING utf8 )
COLLATE utf8_bin = CONVERT( '%'
USING utf8 )
COLLATE utf8_bin;
MySQL said:
#1064 - You have an error in your SQL syntax near '(`User` USING utf8) COLLATE utf8_bin = CONVERT('testuser' USING utf8) COLLATE utf8' at line 1
Logged In: YES
user_id=210714
Originator: NO
Broken by this patch:
http://phpmyadmin.svn.sourceforge.net/viewvc/phpmyadmin/branches/QA_2_11/phpMyAdmin/server_privileges.php?r1=10784&r2=10788
will have to revert to PMA_convert_using() with an additional parameter to force UTF-8. This function does handle the pre-MySQL 4.1 case.
Logged In: YES
user_id=210714
Originator: NO
File Added: patch_1826022.zip
new server_privileges.php and libraries/common.lib.php
Logged In: YES
user_id=210714
Originator: NO
Please test the new files attached to this tracker and report here ASAP.
Logged In: YES
user_id=1383652
Originator: NO
the patch fixed the issue on mysql 4.0.14, pma 2.11.2
sorry, couldn't find an older version ;)
Logged In: YES
user_id=232494
Originator: YES
Thanks,
That patched version is now working on 2.11.2, MySQL 3.23