I am using Digital Ocean’s droplet I want to access my database through my workbench. Earlier I was using Google’s compute engine with the same settings like changing bind-address to server’s private-ip and then creating user with same ip as a host. Example
port = 3306 bind-address = 10.223.0.1
CREATE USER 'adam'@'10.223.0.1' IDENTIFIED BY 'abc@123'; GRANT ALL PRIVILEGES ON *.* TO 'adam'@'10.223.0.1' WITH GRANT OPTION;
I was able to access this user on my local machine with the use of server’s external IP.
But now if I update bind-address with my private IP and check with external port checker tool. it tells me that port 3306 is closed and if I change to 0.0.0.0 than port shows open and I am able to access. But the thing is, I am adding updating private ip as I want to replicate my database to another server. how I can solve this. Thank you in advance.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.