Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.12.0
    • Component/s: PMM Client
    • Labels:

      Description

      1. install MySQL 8 with default option following instruction for Centos 7
      2. Install last PMM build (201806140933) and client
      3. Execute :
         sudo pmm-admin add mysql --query-source=perfschema --user=root --password='qwertyUIOP)(*&^%$#@1' --create-user --force
        

        Result:

        [linux:metrics] OK, now monitoring this system.
        [mysql:metrics] Problem creating a new MySQL user. Failed to execute GRANT SELECT, PROCESS, REPLICATION CLIENT, RELOAD, SUPER ON *.* TO 'pmm'@'localhost' IDENTIFIED BY 'gm-Rr8B5,U7qx39;Ck7_' WITH MAX_USER_CONNECTIONS 10: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'gm-Rr8B5,U7qx39;Ck7_' WITH MAX_USER_CONNECTIONS 10' at line 1
        
        Verify that connecting MySQL user has GRANT privilege.
        

      As I understand the problem in " IDENTIFIED BY PASSWORD syntax has been removed " from MySQL 8 regarding this https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  nailya.kutlubaeva Nailya Kutlubaeva
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 2 days, 5 hours, 50 minutes
                    2d 5h 50m