MySQL 8.0常用操作

创建只读账号

CREATE USER 'readonly'@'%' IDENTIFIED BY '123456';
GRANT SELECT ON *.* TO 'readonly'@'%';

SQLyog连接报错 Error No.2058 Plugin caching_sha2_password could not be loaded

ALTER USER'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)

执行
SET GLOBAL log_bin_trust_function_creators = 1;

或者修改MySQL配置文件my.ini或my.cnf中的[mysqld]添加
log-bin-trust-function-creators=1