mysql8.0问题bug

mysql8.0版本无法连接显示化软件

进入mysql，输入如下语句，单引号中的数据为密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

The user specified as a definer ('root'@'%') does not exist

输入grant all privileges on *.* to 'root'@'%';
        flush privileges;

注：如果执行发现报错：用户授权或提示You are not allowed to create a user with GRANT

执行如下命令

CREATE USER 'user123'@'%' IDENTIFIED BY 'user123';
grant all privileges on *.* to 'user123'@'%';
alter user 'user123'@'%' identified with mysql_native_password by 'user123';
flush privileges;