When doing MySQL master-slave synchronization by:
Mysql> show slave status\g; 1. Row *************************** slave_io_state:waiting for Master to send event master_host:192.168.18.139 Master_user:rep master_port:3307 connect_retry:60 master_log_file:mysql-bin.000001 read_master_log_pos:107 relay_log_file:relay-bin.000002 relay_log_pos:253 relay_master_log_file:mysql-bin.000001 Slave_ Io_running:yes slave_sql_running:yes seconds_behind_master:0master_ssl_verify_server_cert:no Master_server_id:31 row in Set (0.00 sec)error:no query specified ==> This error occurs
This error occurs because the command is executed: show slave status\g; when, add a ";" Semicolon.
This error does not occur when the semicolon is removed when the command is executed.
Mysql> Show slave status\g*************************** 1. Row *************************** slave_io_state:waiting for Master to send event master_host:192.168.18.139 Master_user:rep master_port:3307 connect_retry:60 master_log_file:mysql-bin.000001 read_master_log_pos:107 relay_log_file:relay-bin.000002 relay_log_pos:253 relay_master_log_file:mysql-bin.000001 Slave_IO _running:yes Slave_sql_running:yes
MySQL Error: No query specified