Title: Cannot activate plugin (MySQL 8)
Last modified: March 21, 2020

---

# Cannot activate plugin (MySQL 8)

 *  Resolved [robertbrockie](https://wordpress.org/support/users/robertbrockie/)
 * (@robertbrockie)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/cannot-activate-plugin-mysql-8/)
 * Trying to install the plugin and getting the following error:
 * Can’t activate WP Cerber due to a database error.
 * You have an error in your SQL syntax; check the manual that corresponds to your
   MySQL server version for the right syntax to use near ‘”” COMMENT “IP address”,
   ip_long_begin BIGINT UNSIGNED’ at line 2
 * My database version is MySQL 8

Viewing 4 replies - 1 through 4 (of 4 total)

 *  [caliphkhan](https://wordpress.org/support/users/caliphkhan/)
 * (@caliphkhan)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/cannot-activate-plugin-mysql-8/#post-12599285)
 * Same here, Any luck?
 *  [caliphkhan](https://wordpress.org/support/users/caliphkhan/)
 * (@caliphkhan)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/cannot-activate-plugin-mysql-8/#post-12599302)
 * Ok I found the issue with my MYSQL Mode it was set to ANSI (Shorthand)
    I removed
   it and it worked!
 *  Plugin Author [gioni](https://wordpress.org/support/users/gioni/)
 * (@gioni)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/cannot-activate-plugin-mysql-8/#post-12626359)
 * Good news! Anyway, I’ll rewrite the SQL statement to eliminate that rare issue.
 * [@robertbrockie](https://wordpress.org/support/users/robertbrockie/)
 *  [caliphkhan](https://wordpress.org/support/users/caliphkhan/)
 * (@caliphkhan)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/cannot-activate-plugin-mysql-8/#post-12626385)
 * That would be wonderful. Thanks for looking into it. Please let us know when 
   it is done.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Cannot activate plugin (MySQL 8)’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-cerber_77a9bf.svg)
 * [WP Cerber Security, Anti-spam & Malware Scan](https://wordpress.org/plugins/wp-cerber/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-cerber/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-cerber/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-cerber/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-cerber/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-cerber/reviews/)

## Tags

 * [ANSI](https://wordpress.org/support/topic-tag/ansi/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * 4 replies
 * 3 participants
 * Last reply from: [caliphkhan](https://wordpress.org/support/users/caliphkhan/)
 * Last activity: [6 years, 2 months ago](https://wordpress.org/support/topic/cannot-activate-plugin-mysql-8/#post-12626385)
 * Status: resolved