To verify plugin issues, log in as an administrator and check the following:
use mysql;
SELECT `user`, `host`, `authentication_string`, `plugin` FROM mysql.user;
Repair users (adjust based on your actual details):
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Qian123#';
ALTER USER 'xiyuan123'@'%' IDENTIFIED WITH mysql_native_password BY '[email protected]';