#3546 (ok 3.5.1)Error in create user + underscore +create database

3.4.10
fixed
Marc Delisle
1
2013-06-11
2012-04-05
Anonymous
No

With the current release (3.4.10.2) :
* Go to "Privileges"
* "Add a new User"
* Create a user with "Create database with same name and grant all privileges" and an underscore in his name

In SQL, phpmyadmin do :
"
CREATE USER 'web_toto'@'localhost' IDENTIFIED BY '***';

GRANT USAGE ON * . * TO 'web_toto'@'localhost' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE DATABASE IF NOT EXISTS `web_toto` ;

GRANT ALL PRIVILEGES ON `web_toto` . * TO 'web_toto'@'localhost';
"

Why phpmyadmin doesn't backslash in the last line ?
GRANT ALL PRIVILEGES ON `web\_toto` . * TO 'web_toto'@'localhost';
I choose "Create database with same name" and not "Create databases with approximatly the same name"
Now my user can do create database webAtoto, webBtoto, ...

It's a bug or a feature ? ;)

Best regards,
Julien

Discussion

  • Marc Delisle
    Marc Delisle
    2012-04-05

    • assigned_to: nobody --> lem9
     
  • Marc Delisle
    Marc Delisle
    2012-04-05

    • priority: 5 --> 1
    • summary: Error in create user + underscore + create database --> (ok 3.5.1)Error in create user + underscore +create database
    • status: open --> open-fixed
     
  • Marc Delisle
    Marc Delisle
    2012-04-05

    This bug was fixed in repository and will be part of a future release; thanks for reporting.

     
  • Marc Delisle
    Marc Delisle
    2012-05-07

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

    • Status: closed-fixed --> fixed