I would like to change which hostnames a mysql user can connect from.
Virtualmin > System Settings > Server Templates > Default Settings > MySQL Database
I have changed 'Allowed MySQL client hosts' to %
This enables mysql users to connect from anywhere. However, I would not like there to be any other mysql users created. I just need one user created for each domain and for that user's hostname to be %. Currently the system also creates users for localhost, panel.vuonline.co.uk and 127.0.0.1
You may think that it is not necessary, but due to a separate problem, which is being resolved, some users have empty passwords and it made me realise how unwieldy it is to have 5 users, 4 of which are usually redundant, until something goes awry.