Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1568

pt-show-grants doesn't work for mysql 5.5

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

       

      # ./pt-show-grants -u msandbox -pmsandbox -h 127.0.0.1 -P5552
      -- Grants dumped by pt-show-grants
      -- Dumped from server 127.0.0.1 via TCP/IP, MySQL 5.5.52-log at 2018-06-12 15:06:42
      DBD::mysql::db selectall_arrayref failed: Unknown column 'account_locked' in 'where clause' [for Statement "SELECT DISTINCT User, Host FROM mysql.user WHERE NOT (`account_locked`="Y"
       AND `password_expired`="Y"
       AND `authentication_string`=""
       ) ORDER BY User, Host"] at ./pt-show-grants line 1915.
      # ./pt-show-grants --version
      pt-show-grants 3.0.10
      
      

       

       

       

        Attachments

          Issue Links

            Expenses

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  iwo.panowicz Iwo Panowicz
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: