MYSQL安装Bug解决

安装MYSQL8.0版本出现mysql-创建用户报错ERROR 1396 (HY000): Operation CREATE USER failed for 'mysql.infoschema@‘localhost’

mysql8ERROR 1449 (HY000): The user specified as a definer (‘mysql.infoschema‘@‘localhost‘) does not

解决办法：删除该用户再重建

use mysql;
drop user ‘mysql.infoschema’;
flush privileges;
create user ‘mysql.infoschema’@’localhost’ identified by ‘mysql密码’;
// 授权
grant select on *.* to  `mysql.infoschema`@`localhost`;
flush privileges;