I have followed this document to give access to the mysql database remotely, changed the bind address to 0.0.0.0 and even with the IPv4 IP and did all the steps. I have tried to connect to the database using sequel pro and from local environment to the server database but its not connecting.
I get this error: MySQL said: Host ‘110.xxx.xxx.xxx’ is not allowed to connect to this MySQL server. I wonder what the public IP is and what I am doing wrong.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.