I set up remote mysql server for Virtualmin Pro 2.53 (using mysql module config by setting Mysql host to connect to another IP - Centos 4).
Everytime I create virtual server, mysql database created but virtualserver user unable to connecting.
After some analysis I found that all of permission in user table at remote mysql server set to 'N'.
This is an example:
| localhost | xxxuser | 3c2c54d67a6ed657 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 |