hi__study的博客

在做mysql数据库备份的时候出现如下异常：然后，我查询了一下mysql库里的user表，的确是没有'root'@'%'的用户：select user,host from mysql.user;于是，将root的host字段改成'%'，再刷新权限，即可：update mysql.user set host='%' where user='root'flush privi...

在MySQL8.0.19上创建函数，报错：ERROR 1418 (HY000): 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 lo...