Well, after about 2 hours of research and frustration I finally found an old post that said that using special characters in the database password caused the following error in the drupal module:
The mysqli error was: Access denied for user 'username'@'localhost' (using password: YES).
The only way to clear the error is to disable the module, uninstall it, then re-enable the module. It's rather annoying. There's a couple things that should be done:
1st. I'd like to see the ability to use more complex database passwords made available
2nd. For the time being the documentation should be updated to reflect that using complex passwords will cause the module to error out and NOT to use them to prevent this from being an issue for others. :)
Comments
Comment #1
paulbeaney commentedHi Forbid,
Sorry you had these problems, but glad you got it sorted. I am changing this to a non-critical bug report as the work-around is trivial. If you would like to contribute to the documentation and or the database password issue, please feel free - I need all the help I can get as I am very limited for time.
Regards,
- Paul
Comment #2
paulbeaney commentedFollow-up re passwords and allowed characters. Drupal uses the PHP function parse_url() to handle the database connection string. Using characters such as
/ . @ # ,which have special meanings in URLs, are highly likely to break this module. You'd get a similar problem if you tried to use them as your main Drupal password too. I've added this the FAQ.Regards,
- Paul