MySQL 8.0 授权远程访问

Access denied for user 'root'@'localhost' (using password:YES)

CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%';

Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found

ALTER USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

---

综合

CREATE USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%';