this should fail on 5.5 as well. MAX_USER_CONNECTIONS introduced in Create user in 5.7 only
Kamil Dziedzic June 21, 2018 at 7:20 PM
Turns out CREATE USER supports MAX_USER_CONNECTIONS since 5.7 ;( This means I can't write one query to support all MySQL versions, I need to specifically query database and check for version, and depending on version execute specific queries - I will redo this tomorrow;/
Nailya Kutlubaeva June 21, 2018 at 6:53 PM
Edited
Works great for MySQL 8, but doesn't work for MySQL 5.6
Server version: 5.6.33-0ubuntu0.14.04.1-log (Ubuntu)
I checked twice (removed and the install pmm-client again)
install MySQL 8 with default option following instruction for Centos 7
Install last PMM build (201806140933) and client
Execute :
Result:
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