Hello
- Installed webinolly (A) as this tutorial
https://webinoly.com/tutorial/ejemplo-completo-tutorial-webinoly/
- Now created external user in database like:
CREATE DATABASE ***;
CREATE USER '***'@'localhost' IDENTIFIED BY '***';
GRANT ALL PRIVILEGES ON ***.* TO '***'@'localhost';
CREATE USER '***'@'10.1.96.4' IDENTIFIED BY '***';
GRANT ALL PRIVILEGES ON ***.* TO '***'@'10.1.96.4';
FLUSH PRIVILEGES;
exit
- Now, from another instance (B), im trying to connect to that database with: mysql -u wpuser -h 10.1.96.3 -p
But i get this error: "ERROR 2002 (HY000): Can't connect to MySQL server on '10.1.96.3' (115)"
Do i have to open ports? If so, how to?
Note: IPs are local/private instance ip