How to Set mysql remote access and mysql Remote Access

How to Set mysql remote access and 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

1. Mysql> use mysql;
2. Mysql> grant all on *. * TO admin @ '%' identified by 'admin' with grant option;
3. # Allow any IP address (% above) to access the MySQL Server using the admin account and password (admin ).
4. # You must add an account like this to log on remotely.

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.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.