How do I enable remote MySQL access?

By default, remote access to the server is disabled for security reasons. However many organizations are moving to a more distributed environment. By using a separate database server it can improve security and performance. In such cases, it is required to open MySQL ports remotely.

MySql Server Remote Connection.

Enable remote MySQL access by clicking the checkbox.

Grant Remote Access to New MySQL Database

Go to the Grant User button, now you can click it to assign the user to the database.

And scroll down to Select host. You have to choose remote host from the drop-down. And add your IP in the box. You will get your IP address by clicking here.

Now you are able to connect your database from remote a IP.