How do I enable external access to MySQL Server?

Question :

How do I enable external access to MySQL Server?,

Answer :

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.

Change the bind-address parameter to your machine’s IP address.

Read More  Storing a file in a database as opposed to the file system?

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.

Disclaimer :

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

Read More  How do I change the password of the root user in MySQL?