Connecting remotely to website MySQL database from computer — CyberPanel - WebHosting Control Panel for OpenLiteSpeed
CyberLoader

Connecting remotely to website MySQL database from computer

Hi all, I am trying to configure remote connection to website MySQL database. I've added remote IP (my IP) and trying to use Navicat to connect and it does not work. I also added port 3306 in firewall to allow it from 0.0.0.0/0 and that did not help.

When I SSH into server, I tried to login by forwarding one of local ports to 3306 but that did not work neither.

IMPORTANT: once I added "Allow Remote Access on following IP" any IP there, my website stopped working. I guess there is another my.cnf (or what ever name is) config file where local 127.0.0.1 got blocked and website (php) can't access that DB any more.

Did anyone knows how to sort this out?
Sign In or Register to comment.
CyberPanel Discord

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!