Reputation: 12370
What is the best way to figure out the cause of a mysql 1044 error?
ERROR 1044 (42000): Access denied for user 'web'@'%' to database some_db
Upvotes: 1
Views: 2182
Reputation: 360702
show grants for web@%
would be the best way. If you don't get back anything, or what HAS been granted doesn't cover what's being requested, there's your problem...
Upvotes: 5