Menu

#2263 (ok 2.10.1) Syntax highlighter: extra spaces

2.9.0
fixed
1
2013-06-11
2006-09-28
AniMatrix84
No

# 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'@ '%';
---

Discussion

  • Jürgen Wind

    Jürgen Wind - 2006-10-11

    Logged In: YES
    user_id=1383652

    if you use [edit] instead of cut&paste
    you get the correct syntax

     
  • AniMatrix84

    AniMatrix84 - 2006-10-27

    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 ;)

     
  • Jürgen Wind

    Jürgen Wind - 2006-10-27

    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.

     
  • Marc Delisle

    Marc Delisle - 2006-11-26
    • summary: Displayed SQL Queries some USER actions --> Syntax highlighter: extra spaces
     
  • Sebastian Mendel

    • priority: 5 --> 1
    • summary: Syntax highlighter: extra spaces --> (ok 2.11) Syntax highlighter: extra spaces
    • assigned_to: nobody --> cybot_tm
    • status: open --> open-fixed
     
  • Sebastian Mendel

    • summary: (ok 2.11) Syntax highlighter: extra spaces --> (ok 2.10.1) Syntax highlighter: extra spaces
     
  • Marc Delisle

    Marc Delisle - 2007-04-24
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed