I'm trying to setup automated testing on Silverstripe! in CPanel/WHM. When I ran any of the test in url (for my case it is DOMAIN/dev/tests/AggregateTest), it says
Fatal error: Couldn't run query: CREATE DATABASE tmpdb2605857 Access denied for user 'todaytes_root'@'localhost' to database 'tmpdb2605857' in /home/todaytes/public_html/sapphire/core/model/MySQLDatabase.php on line 525
Silverstripe will create a random-named database every time the test executed and destroy it after the test finished.
From the "databases" menu in cPanel/WHM, I am only allowed to add database and user manually with some prefix name for it (in my case, all my database and user start with todaytes_). How do I configure cPanel/WHM to give permission to the user so that Silverstripe Automated Test could work fine?
Or is there any other solution on this?