Sequel Pro cannot connect to MySQL server

The MySQL client I used on my Mac was sequel Pro, and for the first time, there was an error connecting to the MySQL server.

My MySQL was installed through the LNMP one-click installation package, and the solution was found through the LNMP forum:

1. Add Users

' Root '@'%'your_passwd'   Root'@'%' with GRANT OPTION;

2. Rules for removing the drop 3306 port in Iptables

Iptables-l-n--line-numbers//  My drop 3306 rule on line 5th 5

Resources:

lnmp1.3 MySQL cannot remotely connect host ' xxx.xx.xxx.xxx ' is not allowed to connect to this MySQL server

Sequel Pro cannot connect to MySQL server