MYSQL 5.7 - 8.0 a geçişte yetki verme

CREATE USER ‘username’@‘localhost’ IDENTIFIED BY ‘password’; GRANT ALL PRIVILEGES ON . TO ‘username’@‘localhost’ WITH GRANT OPTION;CREATE USER ‘username’@’%’ IDENTIFIED BY ‘password’;GRANT ALL PRIVILEGES ON . TO ‘username’@’%’ WITH GRANT OPTION; FLUSH PRIVILEGES; ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH caching_sha2_password BY ‘yourpasswd’;Authentication plugin ‘caching_sha2_password’ cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not foundSQLSTATE[HY000][2054] The server requested authentication method unknown to the client hatası içinALTER USER ‘username’@‘ip_address’ IDENTIFIED WITH mysql_native_password BY ‘password’;