Hello,
For internal development we use a GPL version of virtualmin. For development reasons the database has to be available on the desktop of teh developen. We try toconnecto to the databaseon the server. therefor I change the user permission in every host instead ofloacalhost. This setting makes the database unavailablein virtualmin. The user can't edit the database due a permision denied.
Martin
Status:
Closed (fixed)
Comments
Submitted by andreychek on Wed, 06/16/2010 - 12:07 Comment #1
Hi Martin -- you'll want to make sure that the IP addresses or networks your users will be accessing the database from are listed in the "Remote Hosts".
After logging into Virtualmin, if you click Edit Databases -> Remote Hosts, you'll see a box labeled "Allowed hosts for MySQL".
By default, just "127.0.0.1" would be in there.
If you want to have your developers remotely access MySQL, you'll just want to add in the IP addresses of their machines, or perhaps even add the entire LAN.
Make sure that "127.0.0.1" remains in there though, or else your applications on the server itself won't be able to access the database.
Submitted by JamieCameron on Wed, 06/16/2010 - 12:10 Comment #2
How did you grant the remote permissions exactly? Generally you can allow access from localhost and from a remote IP. This is easiest done in Virtualmin at Edit Databases -> Remote hosts.