How to enable remote access to MySql database?
-
I have a PC that runs Laragon. I'm trying to connect to MySql from my Mac that is on the same network as the PC. I have briefly tried changing the my.ini and added bind-address = 0.0.0.0 which didn't work. Can anyone advise how I can access the database. (I'm trying to use Navicat).
Thanks
-
@kwedsd : The MySQL root has no password so for security, the root is only allowed at
localhost
.
Therefore, you need to add another remote user then use the user to connect.
Ref: https://stackoverflow.com/questions/16287559/mysql-adding-user-for-remote-access/37341046