mysql异常问题解决

1449-The user specified as a definer(‘mysql.infoschema‘@localhost‘) does not exist

drop user  `mysql.infoschema`@"localhost";
flush privileges;
create user `mysql.infoschema`@"localhost" identified by '123456';
flush privileges;

ERROR 1356 (HY000): View ‘information_schema.COLUMNS’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
ERROR 1356 (HY000): View ‘information_schema.SCHEMATA’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

select * from user where User ='mysql.infoschema';
update user set Select_priv = 'Y' where User = 'mysql.infoschema';
flush privileges;

update mysql.user set authentication_string=password(“123456”) where user=“root” password报错

在其他数据库执行password方式生成密码直接authentication_string=xxx

grant all on . to root@’%’ identified by ‘123456’ with grant option; identified报错

最新版数据库需要密码和授权分开;
create user 'test'@'%' identified by '123456'; 
grant all on *.* to test@'%' with grant option;
grant all on *.* to root@'%' with grant option;