Mysql user allowed hostname

Hi there,

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, and

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.

Thanks, Laurence



The current Virtualmin code actually always adds localhost even if % is in the allowed hosts list, because in some MySQL versions % does not match local (socket-file) connections.