I’ve been trying to find this one, but I’m not able to. Is there such an option or a way that this can be achieved via CLI?
In short if anyone knows a way to add IP grants to certain database with Virtualmin CLI it would be really helpful.
IF someone also can confirm if this might be a working proper way and wouldn’t mess anything regarding Virtualmin server, I can use something like this as well.
mysql -u username -ppassword -Bse "GRANT ALL ON username.* TO 'username'@'220.127.116.11' IDENTIFIED BY 'password';FLUSH PRIVILEGES;"
Granting user username to access from 18.104.22.168 to database username.
OR if there is a way to add even IP 22.214.171.124 to access all databases with proper user/password would be ideal. If one edit helps here, even GUI method would work, but CLI is preferred if possible in any way.
If anyone can help a bit with this it would be really appreciated.