After successfully installing a copy of SilverStripe on Localhost and playing about with it, I am trying to install a clean copy for the final site. When running the installer as ROOT user (plus pswd), I am advised that everything 'appears' to be OK'. However when I click 'install' I get the following two errors:
That username/password doesn't work: Access denied for user 'root'@'localhost' (using password: YES); and
I can't create new databases and the database 'SS_mysite' doesn't exist (user 'root' doesn't have CREATE DATABASE permissions.)
Strangely enough, when I log in using system admin user and pswd, I only get the second message...
On a tight deadline and really want to get this running, so any advice is very much appreciated!!
The quickest fix would be to manually create the database and user for the database beforehand. At install, provide that information in the SilverStripe installer, and it should be able to build the database tables needed.
As a general rule, I always follow these steps to help partition databases and permissions for security reasons. Using the "root" user for a website frontend is a very bad idea, especially for a publicly-accessible site.
Thanks for your comment. Point about security taken, although at the moment this is only running on Localhost and is not publicly accessible! Setting up database beforehand and connecting to it does make sense!