.7和.5服务器是可以正常使用root用户访问登录的,已经开了root@%的权限
把.5服务器MySQL停止之后,emqx还是保持外部数据源是192.168.31.7的情况,日志同样还是报错
2024-02-18T03:18:38.617607+00:00 [info] msg: starting_mysql_connector, mfa: emqx_mysql:on_start/2(108), config: #{backend => mysql,database => <<"main-cloud">>,enable => true,mechanism => password_based,password => "******",password_hash_algorithm => #{name => plain,salt_position => disable},pool_size => 8,prepare_statement => #{emqx_authn_mysql => [<<"SELECT access_password as password_hash FROM plat_device where device_id = ">>,"?",<<" LIMIT 1">>]},query => "SELECT access_password as password_hash FROM plat_device where device_id = ${clientid} LIMIT 1",query_timeout => 5000,server => "192.168.31.7:3306",ssl => #{ciphers => [],depth => 10,enable => false,hibernate_after => 5000,log_level => notice,reuse_sessions => true,secure_renegotiate => true,user_lookup_fun => {fun emqx_tls_psk:lookup/3,undefined},verify => verify_peer,versions => ['tlsv1.3','tlsv1.2']},username => <<"root">>}, connector: <<"emqx_authn_mysql:1">>
2024-02-18T03:18:38.622988+00:00 [error] crasher: initial call: mysql_conn:init/1, pid: <0.3383.0>, registered_name: [], exit: {{1045,<<"28000">>,<<"Access denied for user 'root'@'192.168.31.5' (using password: YES)">>},[{gen_server,init_it,6,[{file,"gen_server.erl"},{line,835}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,240}]}]}, ancestors: [<0.3382.0>,<0.3381.0>,<0.3379.0>,ecpool_sup,<0.2757.0>], message_queue_len: 0, messages: [], links: [<0.3382.0>], dictionary: [], trap_exit: false, status: running, heap_size: 376, stack_size: 28, reductions: 292; neighbours:
2024-02-18T03:18:38.623234+00:00 [error] Supervisor: {<0.3381.0>,ecpool_worker_sup}. Context: start_error. Reason: {1045,<<"28000">>,<<"Access denied for user 'root'@'192.168.31.5' (using password: YES)">>}. Offender: id={worker,1},pid=undefined.
2024-02-18T03:18:38.623629+00:00 [error] Supervisor: {<0.3379.0>,ecpool_pool_sup}. Context: start_error. Reason: {shutdown,{failed_to_start_child,{worker,1},{1045,<<"28000">>,<<"Access denied for user 'root'@'192.168.31.5' (using password: YES)">>}}}. Offender: id=worker_sup,pid=undefined.
2024-02-18T03:18:38.623614+00:00 [error] crasher: initial call: ecpool_worker:init/1, pid: <0.3382.0>, registered_name: [], exit: {{1045,<<"28000">>,<<"Access denied for user 'root'@'192.168.31.5' (using password: YES)">>},[{gen_server,init_it,6,[{file,"gen_server.erl"},{line,835}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,240}]}]}, ancestors: [<0.3381.0>,<0.3379.0>,ecpool_sup,<0.2757.0>], message_queue_len: 0, messages: [], links: [<0.3381.0>,<0.3383.0>], dictionary: [], trap_exit: true, status: running, heap_size: 376, stack_size: 28, reductions: 241; neighbours: neighbour: pid: <0.3383.0>, registered_name: [], initial call: mysql_conn:init/1, current_function: {re,grun,3}, ancestors: [<0.3382.0>,<0.3381.0>,<0.3379.0>,ecpool_sup,<0.2757.0>], message_queue_len: 0, links: [<0.3382.0>], trap_exit: false, status: runnable, heap_size: 4185, stack_size: 55, reductions: 17074, current_stacktrace: [{re,do_replace,5,[{file,"re.erl"},{line,417}]},{re,replace,4,[{file,"re.erl"},{line,387}]},{logger_formatter,format,2,[{file,"logger_formatter.erl"},{line,82}]},{logger_h_common,try_format,3,[{file,"logger_h_common.erl"},{line,407}]},{logger_h_common,do_log_to_binary,2,[{file,"logger_h_common.erl"},{line,395}]},{logger_h_common,log,2,[{file,"logger_h_common.erl"},{line,177}]},{logger_backend,call_handlers,3,[{file,"logger_backend.erl"},{line,51}]},{proc_lib,exit_p,3,[{file,"proc_lib.erl"},{line,260}]}]
2024-02-18T03:18:38.624349+00:00 [error] msg: start_ecpool_error, mfa: emqx_resource_pool:start/3(51), pool_name: <<"emqx_authn_mysql:1">>, reason: {1045,<<"28000">>,<<"Access denied for user 'root'@'192.168.31.5' (using password: YES)">>}
2024-02-18T03:18:38.624560+00:00 [warning] msg: start_resource_failed, mfa: emqx_resource_manager:start_resource/2(612), id: <<"emqx_authn_mysql:1">>, reason: {start_pool_failed,<<"emqx_authn_mysql:1">>,{1045,<<"28000">>,<<"Access denied for user 'root'@'192.168.31.5' (using password: YES)">>}}
2024-02-18T03:18:53.625572+00:00 [info] msg: starting_mysql_connector, mfa: emqx_mysql:on_start/2(108), config: #{backend => mysql,database => <<"main-cloud">>,enable => true,mechanism => password_based,password => "******",password_hash_algorithm => #{name => plain,salt_position => disable},pool_size => 8,prepare_statement => #{emqx_authn_mysql => [<<"SELECT access_password as password_hash FROM plat_device where device_id = ">>,"?",<<" LIMIT 1">>]},query => "SELECT access_password as password_hash FROM plat_device where device_id = ${clientid} LIMIT 1",query_timeout => 5000,server => "192.168.31.7:3306",ssl => #{ciphers => [],depth => 10,enable => false,hibernate_after => 5000,log_level => notice,reuse_sessions => true,secure_renegotiate => true,user_lookup_fun => {fun emqx_tls_psk:lookup/3,undefined},verify => verify_peer,versions => ['tlsv1.3','tlsv1.2']},username => <<"root">>}, connector: <<"emqx_authn_mysql:1">>
2024-02-18T03:18:53.631044+00:00 [error] Supervisor: {<0.3397.0>,ecpool_worker_sup}. Context: start_error. Reason: {1045,<<"28000">>,<<"Access denied for user 'root'@'192.168.31.5' (using password: YES)">>}. Offender: id={worker,1},pid=undefined.
2024-02-18T03:18:53.631061+00:00 [error] crasher: initial call: mysql_conn:init/1, pid: <0.3399.0>, registered_name: [], exit: {{1045,<<"28000">>,<<"Access denied for user 'root'@'192.168.31