![VuOnline's picture VuOnline's picture](https://archive.virtualmin.com/sites/default/files/styles/thumbnail/public/pictures/picture-5560780-1457348821.png?itok=O-iwQjbu)
Hi there,
I would like to change which hostnames a mysql user can connect from.
In:
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.
Thanks, Laurence
Comments
Submitted by JamieCameron on Thu, 12/22/2016 - 23:44 Comment #1
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.