How to Set mysql Remote Access

How to Set mysql Remote Access
Zookeeper Mysql cannot be accessed through a remote machine by default. The following configuration allows you to enable remote access.

On the MySQL Server:

Run the mysql command to enter the mysql command mode,

SQL code
Mysql> use mysql; mysql> grant all on *. * TO admin @ '%' identified by 'admin' with grant option; # allow any IP address (% above) use the admin account and password (admin) to access this MySQL Server # You must add an account similar to this to remotely log on.

Mysql> use mysql; mysql> grant all on *. * TO admin @ '%' identified by 'admin' with grant option; # allow any IP address (% above) use the admin account and password (admin) to access this MySQL Server # You must add an account similar to this to remotely log on. The root account cannot be remotely logged on. You can only log on locally.