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> ALTER USER 'nagios' @'localhost' IDENTIFIED BY 'xxxxxxxxxxxxxx xxxxxxxxxxxxxx' ; xxxxxxxxxxxxxx' ' at line 1
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 'xxxxxxxxxxxxxx
mysql> SHOW VARIABLES LIKE "%version%"; ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- --+ ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- --+ conversions | | 26.21.c70c68b, wsrep_26.21 | compile_ machine | x86_64 | ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- --+
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.37-82.2 |
| protocol_version | 10 |
| slave_type_
| tls_version | TLSv1.1,TLSv1.2 |
| version | 5.6.37-82.2-82.2 |
| version_comment | Percona XtraDB Cluster (GPL), Release 5.6.37-
| version_
| version_compile_os | debian-linux-gnu |
+------