Navicate connecting MySQL

Recently a lot of friends, are asking me how to connect navicate,mysql not connected. In fact, it is not recommended to do so

Firewall shutdown project is very unsafe, but it is personal testing to do some of their own to the project is not necessary

The following people really need a friend can refer to, but must pay attention to the core of the project do not shut down the firewall

1 mysql-uroot-p access to the database
2 Grant all privileges on * * to ' root ' @ '% ' identified by ' Your database password ' with GRANT OPTION;
Set logon Permissions
3 FLUSH privileges; Execute now
4 exit; exit
5 iptables-f; Turn off the firewall

Experiment many times, are successful, there is a problem if you leave a message to me

Navicate connecting MySQL