#3300 (ok 3.4.9) Error trying to set table privileges

3.4.0
fixed
nobody
Privileges (64)
5
2013-06-11
2011-05-14
No

Used phpMyAdmin 3.4.0.

Create a user and try to set table privileges. There is an error:
REVOKE ALL PRIVILEGES ON `Users` . * FROM 'test_pass_test'@'localhost';
#1141 - There is no such grant defined for user 'test_pass_test' on host 'localhost'

The only way to make it working I found is to revert to the old fuction PMA_DBI_try_query().
File server_privileges.php, line 1190:
if (! PMA_DBI_query($sql_query0)) {
Should be changed back to:
if (! PMA_DBI_try_query($sql_query0)) {

Discussion

  • David Fox

    David Fox - 2011-05-14

    I found the same issue. Just to note, it also occurs when trying to set database privileges too, not just tables.

     
  • Marc Delisle

    Marc Delisle - 2011-05-15
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2011-05-15

    For me the answer is yes. This is a very popular scenario.

     
  • Victor Volkov

    Victor Volkov - 2011-05-15

    -- Does the user you are working as have 'ALL PRIVILEGES'?
    Yes, it have ALL PRIVILEGES, it's root.

     
  • Marc Delisle

    Marc Delisle - 2011-05-15

    We are planning a quick 3.4.1-rc1 in one or two days, with either Victor's fix put in place, or a better one by Herman that would take the case he mentionned into consideration.

     
  • Marc Delisle

    Marc Delisle - 2011-05-15
    • assigned_to: lem9 --> nobody
     
  • Marc Delisle

    Marc Delisle - 2011-12-29

    Victor,
    can you give a step-by-step scenario to reproduce this problem (assuming it's still there in version 3.4.9)?

     
  • Marc Delisle

    Marc Delisle - 2011-12-29
    • status: open --> pending
     
  • Victor Volkov

    Victor Volkov - 2011-12-30

    Mark,
    I don't see any problems in 3.4.9. Privileges works fine.

     
  • Victor Volkov

    Victor Volkov - 2011-12-30
    • status: pending --> open
     
  • Marc Delisle

    Marc Delisle - 2011-12-30

    Thanks Victor for the feedback.

     
  • Marc Delisle

    Marc Delisle - 2011-12-30
    • summary: Error trying to set table privileges --> (ok 3.4.9) Error trying to set table privileges
    • status: open --> closed
     
  • Michal Čihař

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

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks