We just did a MySQL server migration. I completely cleared out all the triggers and executed


This rebuilt the triggers. When I examine them, though, they all have for the definer field

[email protected]/

The IP for the new MySQL server is Where is the rebuild trigger function getting the other IP? I believe that was the old IP, but am unsure as that server has been decommission by our host service.

We are running CiviCRM 5.10.3 on WordPress 5.1

Thanks for any help

  • Doesn't seem to be decommissioned. Seems like that's still a live block of IPs. Check what you have for the CIVICRM_DSN in civicrm.settings.php.
    – Demerit
    May 7, 2019 at 23:46
  • Interesting as I could not ping the old IP earlier. If I ping our CIVICRM_DSN host, mysql.sdbikecoalition.sdcbcdream.org it shows It seems that the seems hard-wired "somewhere" in our configuration. May 8, 2019 at 0:10
  • Just to clarify, your domain is still test.sdcbcdream.org, which still points to a 173.x address, and only your mysql server has moved? And you're looking at the civicrm.settings.php file on the 173.x server?
    – Demerit
    May 8, 2019 at 1:01
  • Ah ... now I see my confusion.The websites we host are all on a 173.236.x address so that must be where that is coming from. Thanks for straightening me out. Yes, the MySQL server is separated from our web server. Should I just delete this post or do you think this thread might be useful to someone else? THANK YOU May 8, 2019 at 1:48
  • This could be useful for others. That kind of split setup with a block of IPs can be confusing.
    – Demerit
    May 8, 2019 at 2:01

1 Answer 1


Thanks to comments by Demerit, my confusion arises from the fact that our MySQL server and web server (with core CiviCRM files) are separate. The mask matches our web server and so that definer field in the trigger just indicates the server from which the triggerRebuild command was executed. There was nothing wrong with our website operation. I just didn't understand the source of that IP, thinking it should match the IP of the MySQL server, which is wholly different. A good argument for a true VPS where you have full control of both Apache and MySQL on the same server.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.