This website is deprecated, and remains online only for historic access to old issues and docs for historic versions of Virtualmin. It has been unmaintained for several years, and should not be relied on for up-to-date information. Please visit www.virtualmin.com instead.

External MySQL Server change User Host setting to ip instead of domain

3 posts / 0 new

Topic locked

Last post

#1 Fri, 08/31/2012 - 08:07

sydios

External MySQL Server change User Host setting to ip instead of domain

Hi,

on my Virtualmin/Webmin installtion i set up a external mysql server. When i now create a new Virtal Server Virtualmin creates a new user on the mysql server this works fine but can i change the seting that the user is createt with ip in the host field not the domain name

so instead of

CREATE USER 'test123'@'test.tld'

this

CREATE USER 'test123'@'1.2.3.4'

test.tld is the Webserver with the Virtualmin instalation.

thanks

#2 Fri, 08/31/2012 - 12:10

andreychek

Howdy,

You may be able to achieve what you're after by going into System Settings -> Server Templates -> Default -> MySQL Database -- and in there, you can set "Allowed MySQL client hosts".

That will make it so that any new users added will be allowed to connect from the IP address you specify.

Would that do what you want?

-Eric

#3 Fri, 08/31/2012 - 12:44 (Reply to #2)

sydios

Hi,

thanks, yes this did the trick and also there is no more localhost user createt as well.

thanks a lot :)

Topic locked