(ok 4.0) Table specific privileges not displayed for db name containing underscore

A software tool to bring MySQL to the Web

Brought to you by: ibennetch, nijel

#3827 (ok 4.0) Table specific privileges not displayed for db name containing underscore

Milestone: 3.5.6

Status: fixed

Owner: Marc Delisle

Labels: table speciffic privileges (2) Table privileges (1)

Priority: 1

Updated: 2013-06-11

Created: 2013-02-15

Creator: tomasz

Private: No

Phpmyadmin version: 3.5.6

nginx/1.1.19
Database client version: libmysql - 5.5.29
PHP extension: mysqli
Software version: 5.5.29-0ubuntu0.12.04.1 - (Ubuntu)

Table speciffic privileges are not displayed.

Discussion

Marc Delisle - 2013-02-15

Please give more details, because for me, they are displayed.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-02-15

status: open --> pending
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

tomasz - 2013-02-15

Hi Marc,

User has permissions as in attachment.

1.jpg

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

tomasz - 2013-02-15

User has table speciffic permissions - see attachment.

2.png

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

tomasz - 2013-02-15

And speciffic permissions to the view

3.png

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

tomasz - 2013-02-15

Sadly I don't see that Tomek user has any table speciffic privileges listed in phpmyadmin.

Sorry for posting 4 entries, but I'was unable to add 4 attachment in one message.

Last edit: tomasz 2013-02-15

4.png

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-02-16

status: pending --> open
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-02-16

Ok, the problem is that table-specific privileges are not displayed for a database having an underscore in its name.

Can you confirm by trying with a database not having an underscore in its name?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

tomasz - 2013-02-16

Hi,

When I use database without underscore it is ok.

Regards.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Samith Dassanayake - 2013-02-18

fixed and done a pull request.

https://github.com/phpmyadmin/phpmyadmin/pull/171

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-02-18

assigned_to: Marc Delisle
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-02-18

summary: Table speciffic privileges are not displayed at all. --> Table specific privileges not displayed for db name containing underscore
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-02-18

summary: Table specific privileges not displayed for db name containing underscore --> (ok 4.0) Table specific privileges not displayed for db name containing underscore

status: open --> open-fixed

priority: 5 --> 1
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2013-05-03

Status: open-fixed --> closed-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Michal Čihař - 2013-06-11

Status: closed-fixed --> fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link: