{"id":54037,"date":"2019-12-18T12:00:02","date_gmt":"2019-12-18T18:00:02","guid":{"rendered":"https:\/\/blog.cpanel.com\/?p=54037"},"modified":"2019-12-18T12:00:02","modified_gmt":"2019-12-18T18:00:02","slug":"upcoming-mysql-changes","status":"publish","type":"post","link":"https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/","title":{"rendered":"Upcoming MySQL Changes"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"UpcomingMySQLChanges-AutomaticMySQL5.5to5.7Update\">Automatic MySQL 5.5 to 5.7 Update<\/h2>\n\n\n\n<p>In continuing with the&nbsp;<a href=\"https:\/\/cpanel.net\/up-next\/\">Up Next&nbsp;<\/a>initiative, we are planning to automatically update a selection of servers that are running cPanel &amp; WHM Version 78 and using MySQL 5.5 to MySQL 5.7. This update is planned in the first quarter of 2020.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"UpcomingMySQLChanges-WhyaresomeserversautomaticallyupgradingtoMySQL5.7?\">Why are some servers automatically upgrading to MySQL 5.7?<\/h3>\n\n\n\n<p>Those servers running cPanel &amp; WHM Version 78 cannot upgrade beyond this version if they currently have MySQL 5.5 installed. MySQL 5.5 moved into &#8220;End of Life&#8221; status on December 3rd, 2018. cPanel will no longer provide support for systems running MySQL 5.5 after the automatic update. Those servers that do not upgrade to MySQL 5.6 or newer are at risk of not receiving essential patches to security vulnerabilities and running into compatibility issues with other software components. These servers will also miss out on added features and security updates in the newer supported cPanel &amp; WHM versions.&nbsp;<\/p>\n\n\n\n<p>We are updating selected servers from MySQL 5.5 to 5.7, because version 5.6 will reach EOL in October 2020 and version 5.7 offers significant performance enhancements as well as active support. If you would like to use MySQL 5.6 instead, you can upgrade your servers ahead of this automatic update. System Administrators can choose to update to 5.6 ahead of this automatic update instead; however, they should be advised of the impending EOL status change.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"UpcomingMySQLChanges-HowdoIknowifI'maffected?\">How do I know if I&#8217;m affected?<\/h3>\n\n\n\n<p>Servers running cPanel &amp; WHM Version 78 and MySQL 5.5 locally that do not have any existing databases may be automatically updated. We are currently evaluating the expansion of this auto-update to include servers having databases; however, that process has not been finalized. To stay up-to-date on updates such as these, we recommend signing up for our&nbsp;<a href=\"https:\/\/signup.e2ma.net\/signup\/1909802\/1890811\/\">Product Update<\/a>&nbsp;mailing list.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"UpcomingMySQLChanges-Whatarethepotentialissues?\">What are the potential issues?<\/h3>\n\n\n\n<p><em>Note: we&nbsp;<\/em><strong><em>strongly recommend<\/em>&nbsp;<\/strong><em>updating MySQL as soon as possible, and not waiting for the automatic update. Taking early action can help prevent problems from arising, such as incompatibility or corruption of the installation.<\/em><\/p>\n\n\n\n<p>As with any software upgrade, there are potential cases where your MySQL installation itself can become corrupted after the automatic update has completed. Please report any issues that you may experience.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"UpcomingMySQLChanges-CanIdothismyself?\">Can I do this myself?<\/h3>\n\n\n\n<p>We encourage server owners to undertake the update process themselves in advance of the automatic update. You can update your MySQL installation by&nbsp;<a href=\"https:\/\/documentation.cpanel.net\/display\/84Docs\/MySQL+or+MariaDB+Upgrade\">following the steps on our Documentation website<\/a>.<\/p>\n\n\n\n<p>If you require assistance with any issues as a result of this update, you can find a<a href=\"https:\/\/go.cpanel.net\/hireasysadmin\">&nbsp;list of SafeAdmin certified system administrators here.&nbsp;<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What else should I know?<\/h2>\n\n\n\n<p>If you have any questions or want to discuss this upgrade process further, please reach out to us directly via our official&nbsp;<a href=\"https:\/\/go.cpanel.net\/slack\">Slack<\/a>&nbsp;and&nbsp;<a href=\"https:\/\/go.cpanel.net\/discord\">Discord<\/a>&nbsp;channels, our official&nbsp;<a href=\"https:\/\/reddit.com\/r\/cpanel\">subreddit<\/a>, or the cPanel&nbsp;<a href=\"https:\/\/forums.cpanel.net\/\">Forums<\/a>. Make sure you keep tabs on the ongoing&nbsp;<a href=\"https:\/\/cpanel.net\/up-next\/\">Up Next<\/a>&nbsp;process!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are planning to automatically update some servers from MySQL 5.5 to MySQL 5.7. This will affect servers that do not have databases and are running cPanel &#038; WHM Version 78.<\/p>\n","protected":false},"author":77,"featured_media":65293,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[49],"tags":[2257,89,549,2261,1941,773,2265,201],"class_list":["post-54037","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-products","tag-automatic-update","tag-cpanel","tag-mysql","tag-mysql-5-5","tag-mysql-5-7","tag-update","tag-version-78","tag-whm"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Upcoming MySQL Changes | cPanel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upcoming MySQL Changes | cPanel\" \/>\n<meta property=\"og:description\" content=\"We are planning to automatically update some servers from MySQL 5.5 to MySQL 5.7. This will affect servers that do not have databases and are running cPanel &amp; WHM Version 78.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/\" \/>\n<meta property=\"og:site_name\" content=\"cPanel\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/cpanel\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-18T18:00:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devel.www.cpanel.net\/wp-content\/uploads\/2019\/12\/MySQL_Blog.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"475\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"cPanel Community\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cPanel\" \/>\n<meta name=\"twitter:site\" content=\"@cPanel\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"cPanel Community\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/\",\"url\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/\",\"name\":\"Upcoming MySQL Changes | cPanel\",\"isPartOf\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/#website\"},\"datePublished\":\"2019-12-18T18:00:02+00:00\",\"dateModified\":\"2019-12-18T18:00:02+00:00\",\"author\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8\"},\"breadcrumb\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/devel.www.cpanel.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upcoming MySQL Changes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#website\",\"url\":\"https:\/\/devel.www.cpanel.net\/\",\"name\":\"cPanel\",\"description\":\"Hosting Platform of Choices\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/devel.www.cpanel.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8\",\"name\":\"cPanel Community\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g\",\"caption\":\"cPanel Community\"},\"description\":\"The web hosting industry's most reliable management solution since 1997. With our first-class support and rich feature set, it's easy to see why our customers and partners make cPanel &amp; WHM their hosting platform of choice. For more information, visit cPanel.net.\",\"sameAs\":[\"https:\/\/cpanel.net\"],\"url\":\"https:\/\/devel.www.cpanel.net\/blog\/author\/cpadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Upcoming MySQL Changes | cPanel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/","og_locale":"en_US","og_type":"article","og_title":"Upcoming MySQL Changes | cPanel","og_description":"We are planning to automatically update some servers from MySQL 5.5 to MySQL 5.7. This will affect servers that do not have databases and are running cPanel & WHM Version 78.","og_url":"https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/","og_site_name":"cPanel","article_publisher":"https:\/\/www.facebook.com\/cpanel\/","article_published_time":"2019-12-18T18:00:02+00:00","og_image":[{"width":1200,"height":475,"url":"https:\/\/devel.www.cpanel.net\/wp-content\/uploads\/2019\/12\/MySQL_Blog.png","type":"image\/png"}],"author":"cPanel Community","twitter_card":"summary_large_image","twitter_creator":"@cPanel","twitter_site":"@cPanel","twitter_misc":{"Written by":"cPanel Community","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/","url":"https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/","name":"Upcoming MySQL Changes | cPanel","isPartOf":{"@id":"https:\/\/devel.www.cpanel.net\/#website"},"datePublished":"2019-12-18T18:00:02+00:00","dateModified":"2019-12-18T18:00:02+00:00","author":{"@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8"},"breadcrumb":{"@id":"https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/devel.www.cpanel.net\/blog\/products\/upcoming-mysql-changes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devel.www.cpanel.net\/"},{"@type":"ListItem","position":2,"name":"Upcoming MySQL Changes"}]},{"@type":"WebSite","@id":"https:\/\/devel.www.cpanel.net\/#website","url":"https:\/\/devel.www.cpanel.net\/","name":"cPanel","description":"Hosting Platform of Choices","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devel.www.cpanel.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8","name":"cPanel Community","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g","caption":"cPanel Community"},"description":"The web hosting industry's most reliable management solution since 1997. With our first-class support and rich feature set, it's easy to see why our customers and partners make cPanel &amp; WHM their hosting platform of choice. For more information, visit cPanel.net.","sameAs":["https:\/\/cpanel.net"],"url":"https:\/\/devel.www.cpanel.net\/blog\/author\/cpadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts\/54037"}],"collection":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/comments?post=54037"}],"version-history":[{"count":0,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts\/54037\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/media\/65293"}],"wp:attachment":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/media?parent=54037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/categories?post=54037"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/tags?post=54037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}