We have a basic 2-tier setup: Web Server / DB Server
Both run Virtualmin Pro.
I have everything (I believe) setup to point the Web Server to the DB Server as the MySQL DB Server. Accounts and databases are created.
The issue is when a new account is created, the MySQL user is created with "localhost" as the host the user is allowed to connect from.
I manually fix this my changing "localhost" to our "web server" and then the user will work just fine.
When that user creates a new database via Webmin, the system then creates a new user with "localhost" as the access host, instead of using the existing user.
Any thoughts as to what I may have wrong here, if anything?
Thanks in advance for your assistance.