I am trying to install SilverStripe on a host provider but am striking problems with the database (see attached screenshot). When I create the database the install programme says it can't see it so I deleted it but then the installer says I don't have the permission to create a database even though that user had just been used to create one via the hosting interface. I am confused, I have logged a ticket with the host provider but I am wondering if I am missing something on the SS side
That error as it says in the bottom corner - You have not got a database called 'SS_mysite' and your user can't create the database. So you will have to a) Use a different user which has CREATE rights b) Give your user CREATE rights so that SilverStripe can create the database for you or c) Use an existing database or create the database.
I am trying to get the host provider to hep me sort the permissions, for some reason I don't have access to this. I am using the database administrator shouldn't tis work?
In the meantime I am wondering if I can get around the problem. The database has a prefix newzealandboutiq_-_ which the install script seems to change to newzealandboutiq__ (see attached ss)when I click Recheck Requirements which I am guessing is why it says the database doesn't exist when it actually does. Is there anyway to stop this?