{"id":7814,"date":"2024-02-14T07:56:57","date_gmt":"2024-02-14T07:56:57","guid":{"rendered":"https:\/\/www.webhi.com\/how-to\/?p=7814"},"modified":"2024-02-14T08:00:45","modified_gmt":"2024-02-14T08:00:45","slug":"upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux","status":"publish","type":"post","link":"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/","title":{"rendered":"Upgrading MySQL 5.7 to 8.0 on CentOS\/RHEL"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2024\/02\/mysql_upgrade_en.jpg\" alt=\"upgrade update mysql version 5.7 to version 8\" class=\"wp-image-7826\" srcset=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2024\/02\/mysql_upgrade_en.jpg 1200w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2024\/02\/mysql_upgrade_en-300x169.jpg 300w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2024\/02\/mysql_upgrade_en-1024x576.jpg 1024w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2024\/02\/mysql_upgrade_en-768x432.jpg 768w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2024\/02\/mysql_upgrade_en-150x84.jpg 150w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/figure>\n\n\n\n<p>Upgrading major versions of MySQL can be a complex process due to potential compatibility issues and configuration changes between versions. In this tutorial, we will walk through the full process of upgrading from MySQL 5.7 to 8.0 on CentOS\/RHEL 7\/8 servers.<\/p>\n\n\n\n<p>The key steps we will cover are:<\/p>\n\n\n\n<ul>\n<li>Preparing for the upgrade by backing up data and validating config<\/li>\n\n\n\n<li>Installing the new MySQL 8.0 repositories<\/li>\n\n\n\n<li>Stopping and removing the old MySQL 5.7 packages<\/li>\n\n\n\n<li>Installing the new MySQL 8.0 packages<\/li>\n\n\n\n<li>Starting MySQL 8.0 and running post-installation steps<\/li>\n\n\n\n<li>Validating the upgrade and making any needed configuration changes<\/li>\n<\/ul>\n\n\n\n<p>Following this process will help ensure a smooth and successful upgrade to MySQL 8.0.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"prerequisites\">Prerequisites<\/h2>\n\n\n\n<p>Before starting the upgrade process, make sure your system meets the following prerequisites:<\/p>\n\n\n\n<ul>\n<li>CentOS\/RHEL 7 or 8 operating system<\/li>\n\n\n\n<li>Existing installation of MySQL 5.7 from default CentOS\/RHEL repos<\/li>\n\n\n\n<li>All important MySQL data has been backed up<\/li>\n\n\n\n<li>You have a maintenance window to take MySQL offline during the upgrade<\/li>\n\n\n\n<li>You have root or sudo privileges on the server to install software<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-1---backup-and-prepare\">Step 1 &#8211; Backup and Prepare<\/h2>\n\n\n\n<p>To avoid any data loss, it is crucial to make backups before starting the upgrade process. Here are the key backup steps:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"backup-mysql-data\">Backup MySQL Data<\/h3>\n\n\n\n<p>Use mysqldump to create logical backups of all databases:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysqldump --all-databases --routines --events &gt; mysql_backup.sql<\/code><\/pre>\n\n\n\n<p>Store this backup file in a safe location off the server.<\/p>\n\n\n\n<p>You can also take binary backups like file system snapshots or LVM snapshots as additional protection.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"review-and-backup-configuration\">Review and Backup Configuration<\/h3>\n\n\n\n<p>The main MySQL config files that may need updates after the upgrade are:<\/p>\n\n\n\n<ul>\n<li>\/etc\/my.cnf &#8211; The main MySQL config file<\/li>\n\n\n\n<li>\/etc\/my.cnf.d\/ &#8211; Contains config snippets that override my.cnf<\/li>\n\n\n\n<li>\/var\/lib\/mysql\/ &#8211; Contains database files<\/li>\n<\/ul>\n\n\n\n<p>Review these files and back them up to a safe location. Pay particular attention to any custom settings like log file paths, memory allocation, etc.<\/p>\n\n\n\n<p>After the upgrade, we will need to merge any needed custom configs back into the new files.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"record-all-mysql-users\">Record All MySQL Users<\/h3>\n\n\n\n<p>The upgrade could potential affect user accounts and permissions. Capture a list of all current users by running:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SELECT User, Host FROM mysql.user;<\/code><\/pre>\n\n\n\n<p>This will let you recreate or fix any users if necessary after the upgrade.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"test-and-validate-replication-if-used\">Test and Validate Replication (if used)<\/h3>\n\n\n\n<p>If using MySQL replication, make sure replication is healthy and all servers are fully in sync before starting the upgrade.<\/p>\n\n\n\n<p>Perform some test writes and reads on the master and slaves to validate. Resolve any replication issues before proceeding.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-2---install-mysql-80-repos\">Step 2 &#8211; Install MySQL 8.0 Repos<\/h2>\n\n\n\n<p>Now we are ready to setup the new MySQL 8.0 repositories. This will let us install the latest MySQL 8.0 releases using yum.<\/p>\n\n\n\n<p>First install the MySQL GPG key:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ rpm --import https:\/\/repo.mysql.com\/RPM-GPG-KEY-mysql-2023<\/code><\/pre>\n\n\n\n<p>This allows RPM packages from MySQL to be authenticated.<\/p>\n\n\n\n<p>Next install the MySQL community repo package:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ yum install https:\/\/repo.mysql.com\/mysql80-community-release-el7-3.noarch.rpm<\/code><\/pre>\n\n\n\n<p>This will setup the MySQL 8.0 yum repo configuration.<\/p>\n\n\n\n<p>Refresh your repo data:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ yum makecache<\/code><\/pre>\n\n\n\n<p>Your CentOS\/RHEL system can now install MySQL 8.0.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-3---stop-mysql-57-and-remove-packages\">Step 3 &#8211; Stop MySQL 5.7 and Remove Packages<\/h2>\n\n\n\n<p>Now we need to properly stop MySQL 5.7 and remove the old package files.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"stop-mysql-service\">Stop MySQL Service<\/h3>\n\n\n\n<p>Stop the MySQL service:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ systemctl stop mysqld.service<\/code><\/pre>\n\n\n\n<p>Verify it shut down properly:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ systemctl status mysqld.service<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"remove-old-mysql-packages\">Remove Old MySQL Packages<\/h3>\n\n\n\n<p>Next use yum to remove just the MySQL 5.7 packages:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ yum remove mysql-community-client-5.7* mysql-community-common-5.7* mysql-community-libs-5.7* mysql-community-server-5.7* <\/code><\/pre>\n\n\n\n<p>This will leave config files in place, which we will clean up later.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-4---install-mysql-80\">Step 4 &#8211; Install MySQL 8.0<\/h2>\n\n\n\n<p>With the old version removed, we can now install MySQL 8.0:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ yum install mysql-community-server<\/code><\/pre>\n\n\n\n<p>This will pull in the latest MySQL 8.0 server, client, common libraries, and tools.<\/p>\n\n\n\n<p>When the install finishes, MySQL 8.0 is now in place but not fully configured yet.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-5---start-mysql-80-and-run-mysql_upgrade\">Step 5 &#8211; Start MySQL 8.0 and Run mysql_upgrade<\/h2>\n\n\n\n<p>The next steps are to start MySQL 8.0 and run mysql_upgrade to make any needed changes for the new version.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"start-mysql\">Start MySQL<\/h3>\n\n\n\n<p>Start the new MySQL 8.0 service:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ systemctl start mysqld.service<\/code><\/pre>\n\n\n\n<p>Verify it started successfully:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ systemctl status mysqld.service<\/code><\/pre>\n\n\n\n<p>The service should be running and you can now connect to it locally.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"run-mysql_upgrade\">Run mysql_upgrade<\/h3>\n\n\n\n<p>The mysql_upgrade tool will check your databases and make any needed adjustments like changing the data dictionary format. This is a key part of the upgrade process.<\/p>\n\n\n\n<p>Connect to MySQL and run it:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysql_upgrade -u root -p <\/code><\/pre>\n\n\n\n<p>Enter your root password when prompted. This will run through any updates needed to your data for 8.0 compatibility.<\/p>\n\n\n\n<p>When it finishes run this to verify the data dictionary is updated:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SHOW VARIABLES LIKE 'dd_version';<\/code><\/pre>\n\n\n\n<p>It should show a value like &#8216;2&#8217; for MySQL 8.0.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"review-error-log\">Review Error Log<\/h3>\n\n\n\n<p>Check over the last MySQL error log at \/var\/log\/mysqld.log for any issues reported during startup or mysql_upgrade.<\/p>\n\n\n\n<p>Resolve any errors before continuing.<\/p>\n\n\n\n<p>At this point MySQL 8.0 should be running successfully.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-6---update-configuration-files\">Step 6 &#8211; Update Configuration Files<\/h2>\n\n\n\n<p>Next we need to update any configuration files and settings for MySQL 8.0.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"update-mycnf\">Update my.cnf<\/h3>\n\n\n\n<p>The main my.cnf file is likely outdated and missing new 8.0 specific options.<\/p>\n\n\n\n<p>Create a new default version:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysqld --initialize --user=mysql --basedir=\/usr --datadir=\/var\/lib\/mysql<\/code><\/pre>\n\n\n\n<p>This will generate a new my.cnf under \/var\/lib\/mysql with 8.0 defaults.<\/p>\n\n\n\n<p>Copy it to \/etc replacing the old file:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ cp \/var\/lib\/mysql\/my.cnf \/etc\/my.cnf<\/code><\/pre>\n\n\n\n<p>Open up this new \/etc\/my.cnf file and re-apply any custom settings you previously had, such as:<\/p>\n\n\n\n<ul>\n<li>Custom memory and engine settings<\/li>\n\n\n\n<li>Replication settings<\/li>\n\n\n\n<li>Any other customizations<\/li>\n<\/ul>\n\n\n\n<p>Save the updated file when finished.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"update-app-armor-settings\">Update App Armor Settings<\/h3>\n\n\n\n<p>If using AppArmor security, it needs updated settings for MySQL 8.0:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ aa-disable \/etc\/apparmor.d\/usr.sbin.mysqld<\/code><\/pre>\n\n\n\n<p>Then update it:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ echo \"alias \/etc\/apparmor.d\/usr.sbin.mysqld -&gt; \/etc\/apparmor.d\/disable\/\" | tee -a \/etc\/apparmor.d\/usr.sbin.mysqld<\/code><\/pre>\n\n\n\n<p>This disables the old AppArmor rules and will use the defaults.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"restart-mysql-and-validate-config\">Restart MySQL and Validate Config<\/h3>\n\n\n\n<p>Restart MySQL to load the new my.cnf settings:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ systemctl restart mysqld.service<\/code><\/pre>\n\n\n\n<p>Check that custom settings have applied correctly:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SHOW VARIABLES;<\/code><\/pre>\n\n\n\n<p>Verify your memory, storage engine, and other settings are as expected.<\/p>\n\n\n\n<p>Also check that:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SELECT @@global.innodb_default_row_format;<\/code><\/pre>\n\n\n\n<p>Shows &#8216;dynamic&#8217; which is required for MySQL 8.0.<\/p>\n\n\n\n<p>Adjust my.cnf further if any settings did not apply correctly.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-7---create-new-user-accounts\">Step 7 &#8211; Create New User Accounts<\/h2>\n\n\n\n<p>If you had any custom user accounts in MySQL 5.7, they will need recreated in 8.0.<\/p>\n\n\n\n<p>Check the list of users you captured earlier, and recreate each account using new CREATE USER syntax:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\"># Create app user\nmysql&gt; CREATE USER 'myapp'@'localhost' IDENTIFIED BY 'password'; \n\n# Grant permissions \nmysql&gt; GRANT SELECT,INSERT,UPDATE,DELETE ON myapp.* TO 'myapp'@'localhost';<\/code><\/pre>\n\n\n\n<p>Test connecting with each recreated user to validate permissions are working.<\/p>\n\n\n\n<p>You may also want to force password expiration with:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; ALTER USER 'user'@'host' PASSWORD EXPIRE;<\/code><\/pre>\n\n\n\n<p>This will require users to reset their password on first login.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-8---cleanup-old-installation\">Step 8 &#8211; Cleanup Old Installation<\/h2>\n\n\n\n<p>Once the upgrade is complete, we can remove any remaining artifacts from the old MySQL 5.7 installation:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"remove-log-files\">Remove Log Files<\/h3>\n\n\n\n<p>Clear out old log files from 5.7:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ rm \/var\/log\/mysqld.log*<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"remove-config-files\">Remove Config Files<\/h3>\n\n\n\n<p>Remove any old unused 5.7 config files:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ rm \/etc\/my.cnf.d\/*mysql57*<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"remove-data-directories\">Remove Data Directories<\/h3>\n\n\n\n<p>If not reusing existing data dirs, remove the 5.7 data directory:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ rm -rf \/var\/lib\/mysql57<\/code><\/pre>\n\n\n\n<p>This helps eliminate any confusion over multiple data directories.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"restart-and-monitor-mysql\">Restart and Monitor MySQL<\/h3>\n\n\n\n<p>Restart MySQL one last time:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ systemctl restart mysqld.service <\/code><\/pre>\n\n\n\n<p>Monitor logs and performance for a while to ensure stable behavior.<\/p>\n\n\n\n<p>The upgrade to 8.0 is now fully complete!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"conclusion\">Conclusion<\/h2>\n\n\n\n<p>Upgrading from MySQL 5.7 to 8.0 involves careful planning, preparation, and testing. The key steps are:<\/p>\n\n\n\n<ul>\n<li>Backup all data and validate the existing install<\/li>\n\n\n\n<li>Install the new MySQL 8.0 repositories<\/li>\n\n\n\n<li>Stop and remove older 5.7 packages<\/li>\n\n\n\n<li>Install MySQL 8.0 releases<\/li>\n\n\n\n<li>Run mysql_upgrade to update system databases<\/li>\n\n\n\n<li>Update configuration files like my.cnf<\/li>\n\n\n\n<li>Recreate user accounts and rerun tests<\/li>\n\n\n\n<li>Cleanup old install artifacts and logs<\/li>\n<\/ul>\n\n\n\n<p>Following this process methodically helps avoid issues and ensure a smooth transition to the latest MySQL version. Testing thoroughly validates that applications have compatibility with new behaviors.<\/p>\n\n\n\n<p>Your MySQL infrastructure is now upgraded with the latest features and improvements in MySQL 8.0!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Upgrading major versions of MySQL can be a complex process due to potential compatibility issues and configuration changes between versions. In this tutorial, we will walk through the full process of upgrading from MySQL 5.7 to 8.0 on CentOS\/RHEL 7\/8 servers. The key steps we will cover are: Following this process will help ensure a ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[57,69],"tags":[],"yoast_head":"\n<title>Upgrading MySQL 5.7 to 8.0 on CentOS\/RHEL - WebHi Tutorials &amp; Documentations<\/title>\n<meta name=\"description\" content=\"Learn the full procedure for upgrading from MySQL 5.7 to 8.0 on CentOS\/RHEL servers. Follow these steps for a smooth transition to the latest MySQL version.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrading MySQL 5.7 to 8.0 on CentOS\/RHEL - WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"og:description\" content=\"Learn the full procedure for upgrading from MySQL 5.7 to 8.0 on CentOS\/RHEL servers. Follow these steps for a smooth transition to the latest MySQL version.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webhi.technology\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-14T07:56:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-14T08:00:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2024\/02\/mysql_upgrade_en.jpg\" \/>\n<meta name=\"author\" content=\"webhi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:site\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webhi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/\"},\"author\":{\"name\":\"webhi\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\"},\"headline\":\"Upgrading MySQL 5.7 to 8.0 on CentOS\/RHEL\",\"datePublished\":\"2024-02-14T07:56:57+00:00\",\"dateModified\":\"2024-02-14T08:00:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/\"},\"wordCount\":1167,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"articleSection\":[\"Databases\",\"Linux system administration\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/\",\"name\":\"Upgrading MySQL 5.7 to 8.0 on CentOS\/RHEL - WebHi Tutorials &amp; Documentations\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\"},\"datePublished\":\"2024-02-14T07:56:57+00:00\",\"dateModified\":\"2024-02-14T08:00:45+00:00\",\"description\":\"Learn the full procedure for upgrading from MySQL 5.7 to 8.0 on CentOS\/RHEL servers. Follow these steps for a smooth transition to the latest MySQL version.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.webhi.com\/how-to\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrading MySQL 5.7 to 8.0 on CentOS\/RHEL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"name\":\"WebHi Tutorials &amp; Documentations\",\"description\":\"System administration and knowledge base\",\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\",\"name\":\"WebHi Technology\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"width\":288,\"height\":95,\"caption\":\"WebHi Technology\"},\"image\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webhi.technology\",\"https:\/\/twitter.com\/WebHiTechnology\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\",\"name\":\"webhi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1782424353\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1782424353\",\"caption\":\"webhi\"},\"sameAs\":[\"https:\/\/www.webhi.com\/how-to\"],\"url\":\"https:\/\/www.webhi.com\/how-to\/author\/webhi\/\"}]}<\/script>\n","yoast_head_json":{"title":"Upgrading MySQL 5.7 to 8.0 on CentOS\/RHEL - WebHi Tutorials &amp; Documentations","description":"Learn the full procedure for upgrading from MySQL 5.7 to 8.0 on CentOS\/RHEL servers. Follow these steps for a smooth transition to the latest MySQL version.","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:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/","og_locale":"en_US","og_type":"article","og_title":"Upgrading MySQL 5.7 to 8.0 on CentOS\/RHEL - WebHi Tutorials &amp; Documentations","og_description":"Learn the full procedure for upgrading from MySQL 5.7 to 8.0 on CentOS\/RHEL servers. Follow these steps for a smooth transition to the latest MySQL version.","og_url":"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/","og_site_name":"WebHi Tutorials &amp; Documentations","article_publisher":"https:\/\/www.facebook.com\/webhi.technology","article_published_time":"2024-02-14T07:56:57+00:00","article_modified_time":"2024-02-14T08:00:45+00:00","og_image":[{"url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2024\/02\/mysql_upgrade_en.jpg"}],"author":"webhi","twitter_card":"summary_large_image","twitter_creator":"@WebHiTechnology","twitter_site":"@WebHiTechnology","twitter_misc":{"Written by":"webhi","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/#article","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/"},"author":{"name":"webhi","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54"},"headline":"Upgrading MySQL 5.7 to 8.0 on CentOS\/RHEL","datePublished":"2024-02-14T07:56:57+00:00","dateModified":"2024-02-14T08:00:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/"},"wordCount":1167,"commentCount":0,"publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"articleSection":["Databases","Linux system administration"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/","url":"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/","name":"Upgrading MySQL 5.7 to 8.0 on CentOS\/RHEL - WebHi Tutorials &amp; Documentations","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/#website"},"datePublished":"2024-02-14T07:56:57+00:00","dateModified":"2024-02-14T08:00:45+00:00","description":"Learn the full procedure for upgrading from MySQL 5.7 to 8.0 on CentOS\/RHEL servers. Follow these steps for a smooth transition to the latest MySQL version.","breadcrumb":{"@id":"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhi.com\/how-to\/upgrade-mysql-5-7-8-0-centos-rhel-8-7-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhi.com\/how-to\/"},{"@type":"ListItem","position":2,"name":"Upgrading MySQL 5.7 to 8.0 on CentOS\/RHEL"}]},{"@type":"WebSite","@id":"https:\/\/www.webhi.com\/how-to\/#website","url":"https:\/\/www.webhi.com\/how-to\/","name":"WebHi Tutorials &amp; Documentations","description":"System administration and knowledge base","publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webhi.com\/how-to\/#organization","name":"WebHi Technology","url":"https:\/\/www.webhi.com\/how-to\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","contentUrl":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","width":288,"height":95,"caption":"WebHi Technology"},"image":{"@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webhi.technology","https:\/\/twitter.com\/WebHiTechnology"]},{"@type":"Person","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54","name":"webhi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/","url":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1782424353","contentUrl":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1782424353","caption":"webhi"},"sameAs":["https:\/\/www.webhi.com\/how-to"],"url":"https:\/\/www.webhi.com\/how-to\/author\/webhi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/7814"}],"collection":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/comments?post=7814"}],"version-history":[{"count":5,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/7814\/revisions"}],"predecessor-version":[{"id":7836,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/7814\/revisions\/7836"}],"wp:attachment":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/media?parent=7814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/categories?post=7814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/tags?post=7814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}