I am relatively new to Virtualmin and am hoping someone might be able to help with a problem I am experiencing with MySQL database creations for new sites.
I have a need to create virtual sites for several groups of similar domains: Eg. new-domain.com, new-domain.net, new-domain.biz. The 1st site creation is successful, however an additional site fails with the error "Failed to create virtual server : A MySQL database called new_domain_com or user called new-domain.com already exists".
I believe I have traced the problem to MySQL not being able to create the user as the Fully Qualified Domain Name is more than 16 characters long, which is the MySQL limit on usernames. With this in mind, I have not found anywhere where I can specifically/manually configure the MySQL user for each domain (only the database name).
Any suggestions or ideas on this would be greatly appreciated.