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
- Mysql> use mysql;
- Mysql> grant all on *. * TO admin @ '%' identified by 'admin' with grant option;
- # Allow any IP address (% above) to access the MySQL Server using the admin account and password (admin ).
- # 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.