Hi, Where I find template of creation db user? I need to change a remote IP value. Now clients are created with value: allow connection from: AAA.BBB.CCC.DDD (in most cases - www server) I need to modify this to: allow connection from: AAA.BBB.CCC.* How to do this?
Changes that you do in the code will get lost on update. Or you write a custom ispconfig plugin which binds to the mysql user insert / update / delete events to add another mysql user instead of changing the one that get's added by ispconfig. Serverside plugins can be found in /usr/local/ispconfig/server/plugins-available/
you can allow mysql-remote-access in general and restrict the access with your firewall and allow AAA.BBB.CCC.* only