I’m trying to set up my first Omeka site using a lamp server with Digital Ocean. For some reason, no matter what I do, I always end up with the following error message:
Omeka Database Error
Access denied for user ‘bk’@‘localhost’ to database ‘katzir’.
Confirm that the information in your db.ini file is correct.
The db.ini file matches the MySQL login exactly. I’ve even created multiple databases just to make sure (and changed the db.ini file accordingly), but no matter what, I always get the same error message. What am I missing here? Thanks for your help.
Access denied is pretty straightforward. There should be some issue with the credentials in db.ini, whether the user doesn’t have permission for that specific database, or they’re not set up to log in from localhost, or the name or password are wrong, or even the server isn’t actually supposed to be localhost, something along those lines.
Can you log in with your credentials using the command-line mysql client?