DB Error: insufficient permissions [solved]

[sdragnev]

I'm using 4.3.2 and I'm getting a "DB Error: insufficient permissions" error when trying to create any record in CiviCRM. So far tested creating a new contact and new event.
The event does end up being created, the contact does not.

The civicrm db is called dev_civicrm, the user is dev_civicrm as well.
Here's the grants that mysql has:

Code: [Select]

mysql> show grants for dev_civicrm@localhost;
+--------------------------------------------------------------------------------------------------------------------+
| Grants for dev_civicrm@localhost                                                                                   |
+--------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'dev_civicrm'@'localhost' IDENTIFIED BY PASSWORD '*yadayada' |
| GRANT ALL PRIVILEGES ON `dev_civicrm`.* TO 'dev_civicrm'@'localhost'                                               |
+--------------------------------------------------------------------------------------------------------------------+
I've cleared drupal and civicrm caches (civicrm/clearcache).

Suggestions?
It's something silly but I can't figure out what.

[sdragnev]

Figured it out.
The db was a dump from another user/db and everything was fine but there were database triggers that used the old username so it was trying to write to the db using that.

[osxxso]

Could you reply with details on how to this fix the trigger issue?  Thanks in advance.

[sdragnev]

In my case, I opened the database dump and searched and replaced the old database name with the new name I'm importing into.

You're having the same issue only if you're importing into a database with a different name than the old one.
If that's not the case, the problem is elsewhere (most likely not enough permissions for the db user).

[JohnFF]

The other issue that I've had with mysqldump was when I had some, but not all, of the permissions. The one I was missing was "Show View"

[Chris Burgess]

Quick instructions: http://forum.civicrm.org/index.php/topic,34456.0.html