Is there any way to have an option to use UID (system user ID, a number under Linux, like 1001) as a user name for the database that is created during the site initialization?
The reason for this is that Mysql has a limit of 16 characters for a user name. If I choose to have the user name to be the same as the site name and the site name is too long, the name will not work or will be truncated. If I have two separate sites, such as:
the user names will be the same, as in "my-great-site-to", which is definitely not what I want and I lose tracking of user name correlation to the site name.
With UID as the database user, all I have to do is look up the UID of the site’s owner, like this [ id -u my-great-site-to-sell-products.com ]
I am currently using a script that creates a database with UID as the user (owner) but the problem with it is that Webmin/Virtualmin is completely unaware that the database owned by a particular user UID belongs to whatever site that was created, there is no relationship there.
Hence, a need to have an option in Webmin/Virtualmin for UID as the owner/user name for the database.
Any pointers/suggestions will be appreciated.