mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFINED BY '12345678@Lhj' WITH GRANT OPTION;
#root表示用户名,12345678@Lhj表示密码
mysql> FLUSH PRIVILEGES;
#刷新
图形化界面操作mysql
2003错误原因是Linux防火墙没有关
#查看防火墙状态
[root@localhost /]# firewall-cmd --state
running
#本次关闭防火墙
[root@localhost /]# systemctl stop firewalld.service
#永久关闭防火墙
[root@localhost /]# systemctl disable firewalld.service
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
重新登录mysql,就可以连接上sqlyog了