I installed PMM through the AWS marketplace and after completing the PMM server side instructions, am following along with the client side ones on this page:
However, the command given for creating the pmm user on the RDS instance simply doesn’t work:
GRANT SELECT, PROCESS, REPLICATION CLIENT ON . TO ‘pmm’@’%’ IDENTIFIED BY ‘pass’ WITH MAX_USER_CONNECTIONS 10;
I get the following response:
ERROR 1064 (42000): 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 'MAX_USER_CONNECTIONS 10 IDENTIFIED BY ‘password’ at line 1
I have tried various combinations of the command to figure out a fix, but without success.
Could someone please suggest the right syntax?
Thanks in advance.