Remote Access Host.

[hmaddy]

One of my website need to connect the database with Remote connection. I tried to connect it with Remote access Host.

i followed this tutorial. https://help.directadmin.com/item.php?id=308

But Not found any Add Access Host Option on mySQL Management Page.

 

[Richard G]

If it's only for 1 website, be aware that this could case a security risk for the whole server.
As you also have to open port 3306 in your firewall, which free's the way for bruteforces on your mysql server.

Next to that, check your /etc/my.cnf for lines like:
bind-address = 127.0.0.1
you might need to change that to:
bind-address = *
and restart mysql afterwards.

But Not found any Add Access Host Option on mySQL Management Page.

As the docs say, it's Mysql management -> database -> access host.
What I can see from your screenshot is that you are on the Mysql Management page... not the database page. Click the according database and then you will see the access hosts option on the end of the page.

 

[hmaddy]

If it's only for 1 website, be aware that this could case a security risk for the whole server.
As you also have to open port 3306 in your firewall, which free's the way for bruteforces on your mysql server.

Next to that, check your /etc/my.cnf for lines like:
bind-address = 127.0.0.1
you might need to change that to:
bind-address = *
and restart mysql afterwards.


As the docs say, it's Mysql management -> database -> access host.
What I can see from your screenshot is that you are on the Mysql Management page... not the database page. Click the according database and then you will see the access hosts option on the end of the page.

Thank you, Its solved.