How do I set up a remote connection with Oneinstack installed MySQL?

1.iptables-i INPUT 4-p tcp-m State--state new-m TCP--dport 3306-j ACCEPT

2.service iptables Save

3.mysql-uroot-p

4.grant all privileges on * * to [email protected] '% ' identified by ' 123456 ';

5.flush privileges;

6.exit;

The explanations are as follows:

1. Open Iptables 3306 Port.
   

2. Save Iptables Rules

3. The database is authorized to the new user sunny, the password is 123456, the authorization% indicates that all IP can be connected, and the * * has permissions on all databases.

4. Refresh Settings

5. Exit

If only one database, such as the Oneinstack database, is assigned, *. * to oneinstack.*

How do I set up a remote connection with Oneinstack installed MySQL?