Not signed in (Sign In)

Vanilla 1.1.10 is a product of Lussumo. More Information: Documentation, Community Support.

    • CommentAuthorWUP
    • CommentTimeJul 13th 2008 edited
     
    - [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?

    Any help appreciated.