Question

【iDesktopX】mysql数据库桌面连接失败，日志报错：Plugin sha256_password could not be loaded

Answer 1

【解决方法】由于MySQL8.0认证方式改了，mysql_native_password方式来连接就可以了 使用mysql进入控制台，然后输入ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY ‘*****’;