Comment 1 for bug 1916672

Revision history for this message
Linda Guo (lihuiguo) wrote :

mysql> ALTER USER 'nagios'@'localhost' IDENTIFIED BY 'xxxxxxxxxxxxxxxxxxxxxxxxxxxx';
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 'IDENTIFIED BY 'xxxxxxxxxxxxxxxxxxxxxxxxxxxx'' at line 1

mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+-------------------------------------------------------------------------+
| Variable_name | Value |
+-------------------------+-------------------------------------------------------------------------+
| innodb_version | 5.6.37-82.2 |
| protocol_version | 10 |
| slave_type_conversions | |
| tls_version | TLSv1.1,TLSv1.2 |
| version | 5.6.37-82.2-82.2 |
| version_comment | Percona XtraDB Cluster (GPL), Release 5.6.37-26.21.c70c68b, wsrep_26.21 |
| version_compile_machine | x86_64 |
| version_compile_os | debian-linux-gnu |
+-------------------------+-------------------------------------------------------------------------+