navicate连接mysql 报错1130

宝塔面板安装Mysql8.0的时候，服务器3306端口未启动。安装mysql5.7时，navicate报错1130，这个时候是root权限问题。
Sql代码 GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

示例: 
Sql代码 
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; 
`
执行完后,再 mysql:flush privileges; 刷新一下权限就可以了,不用重启