# MySQL client version: 5.0.22 (Strict mode)
# Used PHP extensions: mysql
# PHP 5.1.5
# PHPMyAdmin 2.9.0 and 2.9.0-beta1 (<-- tested on)
PMA = PHPMyAdmin
When a user is created in the Privileges part, and when
you then just copy the displayed query PMA used and
when you then try to use this query in a SQL exec part
of PMA it gives an error.
It fails because there is a space between the @ and
'%', see other 'bug' in the PMA displayed SQL code (PMA
does execute the query ok when adding a user, so the
SQL in the background is OK, but what PMA is displaying
what it used to create is wrong, the space)
The same problem you have when you DROP a user, and
maybe when you grant, change or maybe all actions with
a user.
---
CREATE USER 'lala'@ '%' IDENTIFIED BY '****';
GRANT USAGE ON * . * TO 'lala'@ '%' IDENTIFIED BY
'****' WITH MAX_QUERIES_PER_HOUR 0
MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0
MAX_USER_CONNECTIONS 0 ;
-- AND MAYBE ALL OTHER USERS
DROP USER 'lala'@ '%';
---
Logged In: YES
user_id=1383652
if you use [edit] instead of cut&paste
you get the correct syntax
Logged In: YES
user_id=1609064
it would be a lot better if it is displayed, and the
displayed SQL is working well :)
hopefully it will be fixed soon or later :)
They already fixed 2 out of the 3 bugs I submitted ;)
Logged In: YES
user_id=1383652
yes, it will be fixed eventually, i ran into similar troubles
(http://sourceforge.net/tracker/index.php?func=detail&aid=1572218&group_id=23067&atid=377408),
my comment was just meant as a quick workaround for you.