宝塔面板安装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; 刷新一下权限就可以了,不用重启