- [FIX] Turns out it was me that was confused. Plogger uses it's own schema.
Having successfully installed Plogger on a MySQL setup with a single schema I decided to try it out on another site, this one containing a setup with with multiple schemas.
This seems to have confused the install procedure (or, quite possibly, me!). I have root access to MySQL and have tried several different user / password combinations to try and connect to the plogger database, but no joy. The empty plogger database has been created under schema3 and I have set the user and password correctly.
Using localhost / normal_user / normal_password / plogger I get "Couldn't find the database plogger. MySQL error: Access denied for user 'normal_user'@'%' to database 'plogger'"
Using localhost / root / root_password / plogger I get "Couldn't find the database plogger. MySQL error: Unknown database 'plogger'"
I also tried I tried schema3.plogger but that just returns "Couldn't find the database devafcw.plogger. MySQL error: Incorrect database name 'schema3.plogger'"
Now, using the same information I can connect to the plogger database with a simple php script, so I'm happy my data is correct, but my php scripts always select the schema as part of the process.
So I suppose the question is, how do I prompt Plogger to select the correct schema?