Doubt, about default access hosts

[samuelmf]

Hi guys, i've noted that there is a option for access hosts under:
Dashboard -> Administrator Settings ->Database Service Settings

Ok, if i add my desired ip addresses there, then save, ok

If i created db users before add the hosts on that section, the users reamain with no additional hosts, the hosts added on that section only will be applyed to new db users.
For the existent users must i add the additional hosts maually? o there is any command to do it automatic?

 

[zEitEr]

Hello,

You can always send a SQL query directly to a database server and create a new SQL user with a desired host. It should be automatically shown in DirectAdmin.

Or use DIrectAdmin API:

/api/db-manage/users/{dbuser}/change-hosts to change database user hosts

- https://petstore.swagger.io/?url=ht...ost_api_db_manage_users__dbuser__change_hosts

Parameters

o there is any command to do it automatic?

 

[samuelmf]

Hi @zEitEr , Thanks for reply
That is what I did a few days ago, I entered SQL and created the users manually. I could see the users through DirectAdmin without any problem. The problem was that I couldn't see the hosts that I assigned to the user, and I couldn't find a way to make the hosts that I added through MySQL CLI appear in the user details in DirectAdmin.