修改认证插件

-- 修改 root@% 的认证插件（适用于远程连接）
ALTER USER 'root'@'%' IDENTIFIED VIA mysql_native_password USING PASSWORD('123456');

-- 修改 root@localhost 的认证插件（适用于本地连接）
ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('123456');

FLUSH PRIVILEGES;

查看用户

SELECT User, Host FROM mysql.user;
SELECT * FROM mysql.db WHERE Db='dbname';

结构

+-------------+-----------+-----------------------+
| User        | Host      | plugin                |
+-------------+-----------+-----------------------+
| mariadb.sys | localhost | mysql_native_password |
| mysql       | localhost | mysql_native_password |
| root        | localhost | mysql_native_password |
| root        | %         | mysql_native_password |
+-------------+-----------+-----------------------+

还真有2个 root 用户

MariaDB 默认会创建两个 root 用户

• root@localhost（默认无密码或密码不同）
• root@%（你刚创建的）