How do I enable external access to MySQL Server?,
How do I enable external access to MySQL Server? I can connect locally but I cannot connect from another box on the network.
I just tried
grant all privileges on *.* to root@'%' identified by '*****' with grant option;
And restarted MySQL Server with no success.
You probably have to edit the configuration file (usually my.cnf) to listen in the external interface instead of on localhost only.
bind-address parameter to your machine’s IP address.
If this is an old MySQL installation, you should comment out the skip-networking parameter.
Afterwards, restart MySQL and you’ll be set
That’s the answer How do I enable external access to MySQL Server?, Hope this helps those looking for an answer. Then we suggest to do a search for the next question and find the answer only on our site.
The answers provided above are only to be used to guide the learning process. The questions above are open-ended questions, meaning that many answers are not fixed as above. I hope this article can be useful, Thank you