https://community.cloudera.com/t5/Archives-of-Support-Questions/upgrade-mysql-5-6-x-to-mysql-5-6-30-5-6-31/m-p/136268#M31755 <P>Thanks Deepesh for your immense response.</P> Tue, 14 Jun 2016 16:25:06 GMT testsaran09 2016-06-14T16:25:06Z https://community.cloudera.com/t5/Archives-of-Support-Questions/upgrade-mysql-5-6-x-to-mysql-5-6-30-5-6-31/m-p/136266#M31753 <P>We are using HDP2.2. stack and by default mysql 5.6.x has been bundled. The security team assessment report shows that there are vulnerabilities in mysql 5.6 and the remedy of the issue could be upgrade mysql 5.6.30 or above. I am not sure how to upgrade mysql alone in HDP 2.2 and would be good if any one have such experience of upgrading mysql 5.6.x to 5.6.30 or above. Please reply. </P> Fri, 16 Sep 2022 10:25:04 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/upgrade-mysql-5-6-x-to-mysql-5-6-30-5-6-31/m-p/136266#M31753 testsaran09 2022-09-16T10:25:04Z https://community.cloudera.com/t5/Archives-of-Support-Questions/upgrade-mysql-5-6-x-to-mysql-5-6-30-5-6-31/m-p/136267#M31754 <P>You should take a database dump of the various backend stores like Hive, Oozie, Ranger before the upgrade, see instructions <A href="https://docs.hortonworks.com/HDPDocuments/Ambari-2.1.2.1/bk_upgrading_Ambari/content/_perform_backups_mamiu.html">here</A>. This way after upgrade of MySQL if you run into issues you still have your backup database dumps.</P> Tue, 14 Jun 2016 12:37:20 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/upgrade-mysql-5-6-x-to-mysql-5-6-30-5-6-31/m-p/136267#M31754 deepesh1 2016-06-14T12:37:20Z https://community.cloudera.com/t5/Archives-of-Support-Questions/upgrade-mysql-5-6-x-to-mysql-5-6-30-5-6-31/m-p/136268#M31755 <P>Thanks Deepesh for your immense response.</P> Tue, 14 Jun 2016 16:25:06 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/upgrade-mysql-5-6-x-to-mysql-5-6-30-5-6-31/m-p/136268#M31755 testsaran09 2016-06-14T16:25:06Z