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.
Hi @fuzzybase
Please use next requests:
CREATE USER 'pmm'@'%' IDENTIFIED BY 'pass';
GRANT SELECT, PROCESS, REPLICATION CLIENT ON *.* TO 'pmm'@'%';
ALTER USER 'pmm'@'%' WITH MAX_USER_CONNECTIONS 10;
Hi @Vadim_Yalovets, thank you very much for those commands. I was able to complete the steps finally. 
Should I also run the following as per the documentation in the link?
GRANT SELECT, UPDATE, DELETE, DROP ON performance_schema.* TO ‘pmm’@‘%’;
That depends on how you are intending to get Query Analytics data from your RDS instance. I believe by default we will use Performance Schema so I’d say yes (technically I believe you’ll get QAN data anyway as the grant you already ran gives select privs to read the tables but I believe PMM does some housekeeping that the other permissions in the second grant handle).
Thank you for the technical explanation. Helps me to understand the reasoning behind that grant. Will go ahead and run that, too.
