0

I got spare laptop and I want to host my own Mysql database for personal project (client-server type). But after try several ways I still could not be able to connect to mysql server remotely. Things that I've try are:

  • In my.ini file : - Change binding address to : 0.0.0.0 and Comment out #skip-networking line
  • Set inbound rule for port 3306 and check with netstat -an and see port 3306 listening
  • With Mysql user: GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' and FLUSH PRIVILEGES
  • I do try to turn off all firewall with Set-NetFirewallProfile -Profile Domain,Private,Public -Enabled False but got the same result

I can connect within localhost but in client side I get error when test connection with telnet on port 3306. I think somethings are blocking connection to port 3306 but can't figure it out. Any ideas would be appreciated!

AndyVu2311
  • 1
  • This question is not about programming (which makes it off-topic on stackoverflow), and seems pretty tight related to [MySQL unable to connect with remote server](https://stackoverflow.com/questions/21627421/mysql-unable-to-connect-with-remote-server) which has a slightly longer list of items to check. – Luuk Sep 15 '22 at 08:20

0 Answers0