Hi
I'm looking for a way to give access to my mysql server from outside localhost. I've found this here. Is that the way to do it?
I would like to add % instead of an ip, so all computers on our local network could access the mysql server. We have a corporate firewall, that blocks for internet access to port 3306, so I don't see a problem doing this.
Or should I use webmin/servers/mysql and Host Permissions and then select any,any and all permissions?
Login to Virtualmin as root.
2) Open the 'System settings' category on the left menu, and click on 'Server Templates'
3) Click on 'Default settings', then select 'MySQL database' from the menu.
4) In the 'Allowed MySQL client hosts' field, enter :
localhost virtualmin.mydomain.com x.x.x.x
where x.x.x.x is the IP on your Virtualmin server.
5) Click save.