SQLyog连接报错 Error No.2058 Plugin caching_sha2_password could not be loaded
ALTERUSER'root'@'localhost' IDENTIFIED WITH mysql_native_password BY'root';#更新一下用户的密码
FLUSH PRIVILEGES;#刷新权限
Error Code: 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)