Funny topic maybe. I have a app and database I'm moving over from Plesk to Virtualmin. My database has some uppercase letters in it. When you create a database through Virtualmin it looks like it forces lowercase automatically.
So before I try to change the app to use a different database, I took the easy way out and created the database myself via mysql. The problem is after I set this up, the database does not show up in the list of database for the user in Virtualmin. Is there some Virtualmin database table that I need to add this in or some file?
I did these commands to set up the database:
create database myName;
grant all on myName to 'user'@'localhost identified by 'password';
(where user and password is the same user and pass as the vhost user)
My database is working great and the app is working great, I'm just being picky that it doesn't show up in the list.
It does show up great in phpmyadmin when I log on as the vhost user.