发现这样一个错误,但是密码确实是一样的:
[2024-06-18 09:47:23.821368] WDIAG [PROXY.SM] print_mysql_complete_log (ob_mysql_sm.cpp:5906) [20539][Y0-00007F95205909C0] [lt=0] [dc=0] finishing mysql tunnel((sm_id=299376, cs_id=2147667756, proxy_sessid=9151315546812383356, ss_id=124, server_sessid=3221589785, client_ip={Not IP address [0]:0}, server_ip={10.xx.xx.64:2881}, server_trace_id=, proxy_user_name=proxyro@sys#obdemo, database_name=, is_flow_controlled=false, cpu_flow_control_count=0, memory_flow_control_count=0, sql=, sql_cmd=“Login”, result={is_trans_completed:true, is_resp_completed:true, ending_type:2, is_partition_hit:true, has_new_sys_var:false, has_proxy_idc_name_user_var:false, is_server_db_reset:false, reserved_len:0, connection_id:0, scramble_buf:"", is_resultset_resp:false, server_capabilities_lower_.capability:0, ok_packet_action_type:2, last_ok_pkt_len:12, rewritten_last_ok_pkt_len:0, extra_info:{is_exist_sess_info:false, sess_info_count:0, extra_len:0}, error_pkt:field_count:255, errcode:1045, sqlstate:“42000”, message:“Access denied for user ‘proxyro’@‘xxx.xxx.xxx.xxx’ (using password: YES)”})
admin@ubuntu:~/obproxy/log$ mysql -uproxyro@sys -h10.xx.xx.64 -P2881 -paaAA11__ -e "show databases;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+--------------------+
| Database |
+--------------------+
| information_schema |
| oceanbase |
+--------------------+
加上集群名字就会报错:
admin@ubuntu:~/obproxy/log$ mysql -uproxyro@sys#obdemo -h10.xx.xx.64 -P2881 -paaAA11__ -e "show databases;"
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (42000): Access denied for user 'proxyro'@'xxx.xxx.xxx.xxx' (using password: YES)