{"id":144880,"date":"2023-07-12T13:43:19","date_gmt":"2023-07-12T18:43:19","guid":{"rendered":"https:\/\/wpengine.com\/?p=144880"},"modified":"2025-11-25T10:35:33","modified_gmt":"2025-11-25T16:35:33","slug":"preparing-for-mysql-8-0","status":"publish","type":"post","link":"https:\/\/wpengine.com\/resources\/preparing-for-mysql-8-0\/","title":{"rendered":"Preparing for MySQL 8.0"},"content":{"rendered":"\n<p>The widely used MySQL version 5.7 will reach end-of-life (EOL) status in October 2023, formally shifting all official support to <a href=\"https:\/\/dev.mysql.com\/doc\/relnotes\/mysql\/8.0\/en\/\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL 8.0<\/a>.&nbsp;<\/p>\n\n\n\n<p>What does this mean for you? Well, if your site is among the 75% of all WordPress sites still running <a href=\"https:\/\/wpengine.com\/support\/mysql-8\/#Check_Current_MySQL_Version\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL 5.7 or older<\/a>, you\u2019ll need to take steps to ensure your site doesn\u2019t become vulnerable to increased security threats after 5.7 support lapses, and that it\u2019s ready for an upgrade to MySQL 8.0.&nbsp;<\/p>\n\n\n\n<p>This is a significant update, but with the correct information and timely preparation, you\u2019ll be able to rest easy knowing your site is running on the most up-to-date versions of its underlying software.<\/p>\n\n\n\n<p class=\"has-text-align-center\"><a href=\"https:\/\/events.wpengine.com\/MySQLwebinar\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Get ready for the MySQL 8.0 upgrade\u2014Join our upcoming webinar for a live walkthrough!&nbsp;&nbsp;&nbsp;<\/strong><\/a><\/p>\n\n\n\n<p>The following sections will take a closer look at the 5.7 EOL and the changes you can expect with MySQL 8.0. Here\u2019s what we\u2019ll cover:&nbsp;<\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">What is MySQL?<\/h2>\n\n\n\n<p><a href=\"https:\/\/www.mysql.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL<\/a> is an open-source relational database management system used by millions of websites to store, manage, and retrieve structured data. It\u2019s one of the most popular database systems in the world, with various applications ranging from small personal websites to large-scale enterprise systems.&nbsp;<\/p>\n\n\n\n<p>MySQL supports multiple programming languages and powers everything from dynamic web applications to content management systems (CMSs), eCommerce platforms, and more.<\/p>\n\n\n\n<p>Regarding WordPress specifically, the CMS is (in most cases) built using a combination of PHP and MySQL, where PHP handles the server-side processing, and MySQL manages the storage and retrieval of data.<\/p>\n\n\n\n<p>The first version of MySQL was released in 1995, and the widely used version 5.7 was released in 2015. The most recent version of MySQL, version 8.0, was released in 2018 and will be supported through April 2026.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator aligncenter has-alpha-channel-opacity\" \/>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Why is MySQL 5.7 reaching <br>End of Life status?<\/h2>\n\n\n\n<p>Since 2010, each version of MySQL has received official support for eight years after becoming generally available.<\/p>\n\n\n\n<p>MySQL 5.7, released in October 2015, will reach end-of-life status in October 2023, meaning by November 1st, it will no longer be supported with security patches and upgrades.&nbsp;<\/p>\n\n\n\n<p>Using the most current version of MySQL (version 8.0) will ensure your site is optimized for the future and protected against a greater number of threats.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator aligncenter has-alpha-channel-opacity\" \/>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Will this change be widespread?<\/h2>\n\n\n\n<p>MySQL plays a critical role within WordPress, as it is the default database management system for <a href=\"https:\/\/blog.gitnux.com\/mysql-statistics\/\" target=\"_blank\" rel=\"noreferrer noopener\">over 90%<\/a> of all WordPress sites. More than 75% of those sites use either MySQL 5.7 or an older version, meaning the coming EOL will affect a wide range of websites.&nbsp;<\/p>\n\n\n\n<p>Currently, websites hosted on WP Engine&#8217;s platform use MySQL 5.7 and will be upgraded to 8.0 <strong>before November 1st<\/strong>. We\u2019re assisting our customers with this change by providing them with tools to assess their site\u2019s readiness ahead of the needed upgrade.&nbsp;<\/p>\n\n\n\n<p class=\"has-text-align-center\"><a href=\"https:\/\/wpengine.com\/support\/mysql-8\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Test your site for MySQL 8.0 compatibility<\/strong><\/a><\/p>\n\n\n\n<p>As noted below, using <a href=\"https:\/\/wpengine.com\/local\/\" target=\"_blank\" rel=\"noreferrer noopener\">Local<\/a> to test your site with MySQL 8.0 and <a href=\"https:\/\/wpengine.com\/resources\/how-to-check-wordpress-plugins-themes-update\/\" target=\"_blank\" rel=\"noreferrer noopener\">ensuring your plugins and themes are all up to date<\/a> prior to migration will go a long way towards preventing issues once your site has been migrated.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator aligncenter has-alpha-channel-opacity\" \/>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">My site is just a blog or brochure site. Will I be impacted?&nbsp;<\/h2>\n\n\n\n<p>Yes, if your site is using MySQL 5.7. WordPress relies on the widely used MySQL database to store and manage your website&#8217;s data, and using an out-of-date and unsupported version of the software will increase the security risks facing your site.&nbsp;<\/p>\n\n\n\n<p>If your site is hosted on WP Engine\u2019s platform, we will no longer offer MySQL 5.7 and will upgrade all servers to 8.0 by the end of October, ensuring your site is protected against security threats.<\/p>\n\n\n\n<p>At the same time, updating to MySQL 8.0 may cause compatibility issues with existing plugins and themes, which is why it&#8217;s so important to prepare and assess your readiness for this necessary upgrade now, regardless of your website type.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator aligncenter has-alpha-channel-opacity\" \/>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">How will I know what is going to happen to my site?<\/h2>\n\n\n\n<p>To test your site\u2019s functionality using MySQL 8.0, we suggest using <a href=\"https:\/\/wpengine.com\/local\/\" target=\"_blank\" rel=\"noreferrer noopener\">Local<\/a>, a powerful WordPress development tool for setting up sites in a staging environment on your local machine. Using Local, you can download a version of your site and run it on MySQL 8.0 to verify functionality.&nbsp;<\/p>\n\n\n\n<p>Before testing your site, you should also make sure all of your installed plugins and themes are up to date\u2014even the ones you\u2019re not currently using on your site. In many cases, ensuring your plugins and themes are updated will help you avoid compatibility issues as a result of the update. And by testing your site this way in Local, you can rest easy knowing the migration to MySQL 8.0 won\u2019t negatively affect your site.&nbsp;<\/p>\n\n\n\n<p>To learn more about testing for MySQL 8.0 functionality using Local, check out <a href=\"https:\/\/wpengine.com\/support\/mysql-8\/\" target=\"_blank\" rel=\"noreferrer noopener\">this detailed support article<\/a>. For a detailed walkthrough, you can also join WP Engine\u2019s <a href=\"https:\/\/events.wpengine.com\/MySQLwebinar\" target=\"_blank\" rel=\"noreferrer noopener\">upcoming webinar<\/a>, where we\u2019ll provide a closer look at everything you need to know about the coming MySQL 5.7 EOL and upgrade to version 8.0.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator aligncenter has-alpha-channel-opacity\" \/>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">What benefits can I expect to see after upgrading to MySQL 8.0?<\/h2>\n\n\n\n<p>Upgrading to MySQL 8.0 can provide numerous benefits, as the most recent version includes significant functionality and performance enhancements. Here are a few of the key improvements:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Improved Code Organization and Readability&nbsp;<\/strong><br>MySQL 8.0 introduces several new SQL features including SQL Window Functions and Common Table Expressions as well as enhanced JSON capability. MySQL 8.0 also introduces the NOWAIT and SKIP LOCKED options, providing better control and concurrency handling in transactional scenarios.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Enhanced Reliability&nbsp;<\/strong><br>MySQL 8.0 enhances reliability by making Data Definition Language (DDL) statements atomic and crash-safe. Metadata is stored in a single, transactional data dictionary powered by InnoDB.&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Greater Observability and Manageability<\/strong><br>MySQL 8.0 significantly improves Performance Schema, Information Schema, Configuration Variables, and Error Logging, providing better observability. It also offers remote management, undo tablespace management, and new instant DDL for improved manageability.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Enhanced Security<\/strong><br>In addition to becoming the only version of MySQL with active, official support, MySQL 8.0 includes OpenSSL improvements, a new default authentication method, the introduction of SQL Roles, breaking up the super privilege, password strength enhancements, and more, strengthening database security.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Improved Performance<\/strong>&nbsp;<br>The default storage engine for MySQL 8.0, InnoDB, delivers significantly better performance for Read\/Write workloads, IO-bound workloads, and high contention &#8220;hot spot&#8221; workloads. The addition of the Resource Group feature allows users to optimize specific workloads on specific hardware by mapping user threads to CPUs.<\/li>\n<\/ul>\n\n\n\n<p>Find out more about all of the enhancements found in MySQL 8.0 <a href=\"https:\/\/dev.mysql.com\/blog-archive\/whats-new-in-mysql-8-0-generally-available\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator aligncenter has-alpha-channel-opacity\" \/>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">What can I do if the upgrade to MySQL 8.0 breaks my website?<\/h2>\n\n\n\n<p>To mitigate the effects of broken functionality on your site, it\u2019s advisable to make MySQL 8.0 compatibility updates on a <a href=\"https:\/\/wpengine.com\/support\/environments\/\" target=\"_blank\" rel=\"noreferrer noopener\">staging or development environment<\/a>. This will allow you to troubleshoot and roll-back changes as needed, without affecting your live site in production.&nbsp;&nbsp;<\/p>\n\n\n\n<p>As noted above, <a href=\"https:\/\/wpengine.com\/local\/\" target=\"_blank\" rel=\"noreferrer noopener\">Local<\/a> is an excellent option for testing your site\u2019s compatibility with MySQL 8.0. Because Local creates a copy of your website on your local machine (and not online) it\u2019s an inherently safe, secure, and easy-to-use option as you prepare for the upgrade.&nbsp;&nbsp;&nbsp;<\/p>\n\n\n\n<p>In addition to the above options, WP Engine customers will receive detailed information about their website(s) and scheduled updates to MySQL 8.0, which WP Engine will perform on their behalf. As always, customers can <a href=\"https:\/\/wpengine.com\/contact\/\" target=\"_blank\" rel=\"noreferrer noopener\">reach out<\/a> to our Support Team, who will be available to help if they run into issues. (Use code: mysql8).<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator aligncenter has-alpha-channel-opacity\" \/>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">How long do I have to prepare for this?<\/h2>\n\n\n\n<p>MySQL 5.7 will reach its end of support in October, so over the next three months you will want to prepare your site for this upgrade. That said, it\u2019s advisable not to wait until the last minute as some fixes may require more time to address. Assessing your site\u2019s compatibility with MySQL 8.0 in a staging environment (such as <a href=\"https:\/\/wpengine.com\/local\/\" target=\"_blank\" rel=\"noreferrer noopener\">Local<\/a>) can help you avoid unnecessary downtime with the upgrade.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator aligncenter has-alpha-channel-opacity\" \/>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Can WP Engine help me with this?<\/h2>\n\n\n\n<p>WP Engine\u2019s team of WordPress experts is always happy to help answer any questions you may have. You can <a href=\"\/contact\/\">speak to a WP Engine representative now<\/a>, or, if you find site code-related issues our team is unable to support, we have an extensive <a href=\"https:\/\/wpengine.com\/agency-directory\/\">agency partner directory<\/a> where you can connect with vetted professionals.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator aligncenter has-alpha-channel-opacity\" \/>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Preparing for MySQL 8.0: TLDR<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The vast majority of WordPress sites are currently using MySQL 5.7, which will reach EOL status at the end of October 2023.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To prevent the increased threat of security vulnerabilities, WordPress sites should upgrade to <a href=\"https:\/\/dev.mysql.com\/doc\/relnotes\/mysql\/8.0\/en\/\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL 8.0<\/a>, which will be officially supported through April 2026.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>WP Engine\u2019s platform will no longer offer MySQL 5.7 and will upgrade all servers to 8.0 by the end of October. We\u2019re assisting our customers with this change by providing them with tools to assess their site\u2019s readiness ahead of the needed upgrade.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Upgrading to MySQL 8.0 can provide numerous benefits, including significant functionality and performance enhancements. However, the upgrade may also cause compatibility issues with existing plugins and themes.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In many cases, making sure your plugins and themes are up to date will help you avoid compatibility issues as a result of the update.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You should also test your site\u2019s functionality using MySQL 8.0 in a <a href=\"https:\/\/wpengine.com\/support\/environments\/\" target=\"_blank\" rel=\"noreferrer noopener\">staging or development environment<\/a>. We suggest using <a href=\"https:\/\/wpengine.com\/local\/\" target=\"_blank\" rel=\"noreferrer noopener\">Local<\/a>, where you can download a version of your site and run it on MySQL 8.0 to verify functionality.&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>For a closer look at using Local to test your site for MySQL 8.0, join WP Engine\u2019s <a href=\"https:\/\/events.wpengine.com\/MySQLwebinar\" target=\"_blank\" rel=\"noreferrer noopener\">upcoming webinar<\/a>, where our WordPress experts will walk you through the process.&nbsp;<\/li>\n\n\n\n<li>WP Engine\u2019s team of WordPress experts is always happy to help answer any questions you may have. <a href=\"\/contact\/\">Speak to a WP Engine representative now<\/a>, or, if you find site code-related issues our team is unable to support, we have an extensive <a href=\"https:\/\/wpengine.com\/partners\/agencies\/\" target=\"_blank\" rel=\"noreferrer noopener\">Agency Partner Directory<\/a> where you can connect with vetted professionals.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The widely used MySQL version 5.7 will reach end-of-life (EOL) status in October 2023, formally shifting all official support to MySQL 8.0.&nbsp; What does this mean for you? Well, if your site is among the 75% of all WordPress sites still running MySQL 5.7 or older, you\u2019ll need to take steps to ensure your site<span class=\"tile__ellipses\">&hellip;<\/span><span class=\"tile__ellipses--animated\"><\/span><\/p>\n","protected":false},"author":1,"featured_media":144881,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[9,41],"tags":[],"class_list":["post-144880","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-product-updates","category-wordpress-news"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Preparing Your Site for MySQL 8.0<\/title>\n<meta name=\"description\" content=\"Official support for MySQL 5.7 ends in October\u2014here\u2019s what you need to know to keep your sites running smoothly.\" \/>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Preparing Your Site for MySQL 8.0\" \/>\n<meta property=\"og:description\" content=\"Official support for MySQL 5.7 ends in October\u2014here\u2019s what you need to know to keep your sites running smoothly.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wpengine.com\/resources\/preparing-for-mysql-8-0\/\" \/>\n<meta property=\"og:site_name\" content=\"WP Engine\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/wpengine\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T18:43:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-25T16:35:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wpengine.com\/resources\/wp-content\/uploads\/2023\/07\/MySQL_update_1200x627.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"627\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"WP Engine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/wpengine.com\/resources\/wp-content\/uploads\/2023\/07\/MySQL_update_1200x627.png\" \/>\n<meta name=\"twitter:creator\" content=\"@wpengine\" \/>\n<meta name=\"twitter:site\" content=\"@wpengine\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"WP Engine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/wpengine.com\/resources\/preparing-for-mysql-8-0\/\",\"url\":\"https:\/\/wpengine.com\/resources\/preparing-for-mysql-8-0\/\",\"name\":\"Preparing Your Site for MySQL 8.0\",\"isPartOf\":{\"@id\":\"https:\/\/wpengine.com\/resources\/#website\"},\"datePublished\":\"2023-07-12T18:43:19+00:00\",\"dateModified\":\"2025-11-25T16:35:33+00:00\",\"author\":{\"@id\":\"https:\/\/wpengine.com\/resources\/#\/schema\/person\/f5301455463371a10d1fc290e9ad0085\"},\"description\":\"Official support for MySQL 5.7 ends in October\u2014here\u2019s what you need to know to keep your sites running smoothly.\",\"breadcrumb\":{\"@id\":\"https:\/\/wpengine.com\/resources\/preparing-for-mysql-8-0\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/wpengine.com\/resources\/preparing-for-mysql-8-0\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/wpengine.com\/resources\/preparing-for-mysql-8-0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/wpengine.com\/resources\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Preparing for MySQL 8.0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/wpengine.com\/resources\/#website\",\"url\":\"https:\/\/wpengine.com\/resources\/\",\"name\":\"WP Engine\",\"description\":\"Managed Hosting for WordPress\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/wpengine.com\/resources\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/wpengine.com\/resources\/#\/schema\/person\/f5301455463371a10d1fc290e9ad0085\",\"name\":\"WP Engine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/wpengine.com\/resources\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d8770fe9625ca7c4601f13d9d0ab86565a6dac8cd6a77bfe2ada6d83c6837870?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d8770fe9625ca7c4601f13d9d0ab86565a6dac8cd6a77bfe2ada6d83c6837870?s=96&d=mm&r=g\",\"caption\":\"WP Engine\"},\"sameAs\":[\"https:\/\/wpengine.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Preparing Your Site for MySQL 8.0","description":"Official support for MySQL 5.7 ends in October\u2014here\u2019s what you need to know to keep your sites running smoothly.","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Preparing Your Site for MySQL 8.0","og_description":"Official support for MySQL 5.7 ends in October\u2014here\u2019s what you need to know to keep your sites running smoothly.","og_url":"https:\/\/wpengine.com\/resources\/preparing-for-mysql-8-0\/","og_site_name":"WP Engine","article_publisher":"https:\/\/www.facebook.com\/wpengine","article_published_time":"2023-07-12T18:43:19+00:00","article_modified_time":"2025-11-25T16:35:33+00:00","og_image":[{"width":1200,"height":627,"url":"https:\/\/wpengine.com\/resources\/wp-content\/uploads\/2023\/07\/MySQL_update_1200x627.png","type":"image\/png"}],"author":"WP Engine","twitter_card":"summary_large_image","twitter_image":"https:\/\/wpengine.com\/resources\/wp-content\/uploads\/2023\/07\/MySQL_update_1200x627.png","twitter_creator":"@wpengine","twitter_site":"@wpengine","twitter_misc":{"Written by":"WP Engine","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/wpengine.com\/resources\/preparing-for-mysql-8-0\/","url":"https:\/\/wpengine.com\/resources\/preparing-for-mysql-8-0\/","name":"Preparing Your Site for MySQL 8.0","isPartOf":{"@id":"https:\/\/wpengine.com\/resources\/#website"},"datePublished":"2023-07-12T18:43:19+00:00","dateModified":"2025-11-25T16:35:33+00:00","author":{"@id":"https:\/\/wpengine.com\/resources\/#\/schema\/person\/f5301455463371a10d1fc290e9ad0085"},"description":"Official support for MySQL 5.7 ends in October\u2014here\u2019s what you need to know to keep your sites running smoothly.","breadcrumb":{"@id":"https:\/\/wpengine.com\/resources\/preparing-for-mysql-8-0\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wpengine.com\/resources\/preparing-for-mysql-8-0\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/wpengine.com\/resources\/preparing-for-mysql-8-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wpengine.com\/resources\/"},{"@type":"ListItem","position":2,"name":"Preparing for MySQL 8.0"}]},{"@type":"WebSite","@id":"https:\/\/wpengine.com\/resources\/#website","url":"https:\/\/wpengine.com\/resources\/","name":"WP Engine","description":"Managed Hosting for WordPress","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wpengine.com\/resources\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/wpengine.com\/resources\/#\/schema\/person\/f5301455463371a10d1fc290e9ad0085","name":"WP Engine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wpengine.com\/resources\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d8770fe9625ca7c4601f13d9d0ab86565a6dac8cd6a77bfe2ada6d83c6837870?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d8770fe9625ca7c4601f13d9d0ab86565a6dac8cd6a77bfe2ada6d83c6837870?s=96&d=mm&r=g","caption":"WP Engine"},"sameAs":["https:\/\/wpengine.com"]}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/wpengine.com\/resources\/wp-json\/wp\/v2\/posts\/144880","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpengine.com\/resources\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wpengine.com\/resources\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wpengine.com\/resources\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wpengine.com\/resources\/wp-json\/wp\/v2\/comments?post=144880"}],"version-history":[{"count":0,"href":"https:\/\/wpengine.com\/resources\/wp-json\/wp\/v2\/posts\/144880\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wpengine.com\/resources\/wp-json\/wp\/v2\/media\/144881"}],"wp:attachment":[{"href":"https:\/\/wpengine.com\/resources\/wp-json\/wp\/v2\/media?parent=144880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wpengine.com\/resources\/wp-json\/wp\/v2\/categories?post=144880"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wpengine.com\/resources\/wp-json\/wp\/v2\/tags?post=144880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}