{"id":151,"date":"2017-06-29T15:37:33","date_gmt":"2017-06-29T15:37:33","guid":{"rendered":"https:\/\/newdelhihosting.co.in\/blog\/?p=151"},"modified":"2017-07-04T12:50:42","modified_gmt":"2017-07-04T12:50:42","slug":"how-to-install-mysql-latest-version","status":"publish","type":"post","link":"https:\/\/www.newdelhihosting.co.in\/blog\/how-to-install-mysql-latest-version\/","title":{"rendered":"Steps to install latest version of mysql and php"},"content":{"rendered":"<p><strong>Install MYSQL5.7 follow below steps :- To install Php Go to &#8211;&gt;<a href=\"#myanchor\">Php Installation<\/a><\/strong><\/p>\n<p>First Check the version of OS<\/p>\n<pre>cat \/etc\/redhat-release\r\nCentOS release 6.9(Final)<\/pre>\n<p>Steps:-Download and add the following MySQL Yum repository<br \/>\n1)On RHEL\/CentOS 6<\/p>\n<pre>wget http:\/\/dev.mysql.com\/get\/mysql157-community-release-e16-7.noarch.rpm<\/pre>\n<p>2)Install Packages<\/p>\n<pre>yum localinstall mysql57-community-release-e16-7.noarch.rpm<\/pre>\n<p>3)Verify Mysql yum enabled<\/p>\n<pre>yum repolist enabled | grep \u201cmysql.*-community.*\u201d<\/pre>\n<p>4)Installing latest mysql version<\/p>\n<pre>yum install mysql-community-server<\/pre>\n<p><!--more--><\/p>\n<p>5)Service start<\/p>\n<pre>service mysqld starting<\/pre>\n<p>6)Service status<\/p>\n<pre>service mysqld status\r\nmysqld is running.....<\/pre>\n<p>7)Finally verify mysql version<\/p>\n<pre>mysql  --version\r\nmysqld ver 5.7.18 for linux on x86_64<\/pre>\n<p>8)Securing Mysql installation<br \/>\n<strong>Note:<\/strong>mysql version 5.7 generates temporary password in \/var\/log\/mysqld.log after installation<br \/>\nTo see the password:<\/p>\n<pre>grep \u2018temporary password\u2019 \/var\/log\/mysqld.log<\/pre>\n<p>Once know the password then run to set new sql password<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-252 alignleft\" src=\"https:\/\/newdelhihosting.co.in\/blog\/wp-content\/uploads\/2017\/06\/sql-1-300x198.png\" alt=\"\" width=\"284\" height=\"187\" srcset=\"https:\/\/www.newdelhihosting.co.in\/blog\/wp-content\/uploads\/2017\/06\/sql-1-300x198.png 300w, https:\/\/www.newdelhihosting.co.in\/blog\/wp-content\/uploads\/2017\/06\/sql-1.png 768w, https:\/\/www.newdelhihosting.co.in\/blog\/wp-content\/uploads\/2017\/06\/sql-1-250x165.png 250w\" sizes=\"(max-width: 284px) 100vw, 284px\" \/><br \/>\n<strong>mysql_secure_installation<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>9)Connecting to mysql server<\/p>\n<pre>mysql -u root -p<\/pre>\n<p>10)Updating Mysql with yum and successfully installed MySQL 5.7.9<\/p>\n<pre>yum update mysql-server<\/pre>\n<p><strong id=\"myanchor\">Install PHP7(latest version) by<\/strong><br \/>\nStep1:-<\/p>\n<pre>yum install php70w<\/pre>\n<p>Step2:-<\/p>\n<pre>yum install php-mysqlnd\"-to install PDO mysql extensions<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Install MYSQL5.7 follow below steps :- To install Php Go to &#8211;&gt;Php Installation First Check the version of OS cat \/etc\/redhat-release CentOS release 6.9(Final) Steps:-Download and add the following MySQL Yum repository 1)On RHEL\/CentOS 6 wget http:\/\/dev.mysql.com\/get\/mysql157-community-release-e16-7.noarch.rpm 2)Install Packages yum localinstall mysql57-community-release-e16-7.noarch.rpm 3)Verify Mysql yum enabled yum repolist enabled | grep \u201cmysql.*-community.*\u201d 4)Installing latest mysql&#8230;<\/p>\n","protected":false},"author":1,"featured_media":431,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[14],"tags":[],"class_list":["post-151","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vps-2"],"jetpack_featured_media_url":"https:\/\/www.newdelhihosting.co.in\/blog\/wp-content\/uploads\/2017\/06\/mysql-1.jpg","_links":{"self":[{"href":"https:\/\/www.newdelhihosting.co.in\/blog\/wp-json\/wp\/v2\/posts\/151"}],"collection":[{"href":"https:\/\/www.newdelhihosting.co.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.newdelhihosting.co.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.newdelhihosting.co.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.newdelhihosting.co.in\/blog\/wp-json\/wp\/v2\/comments?post=151"}],"version-history":[{"count":10,"href":"https:\/\/www.newdelhihosting.co.in\/blog\/wp-json\/wp\/v2\/posts\/151\/revisions"}],"predecessor-version":[{"id":390,"href":"https:\/\/www.newdelhihosting.co.in\/blog\/wp-json\/wp\/v2\/posts\/151\/revisions\/390"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.newdelhihosting.co.in\/blog\/wp-json\/wp\/v2\/media\/431"}],"wp:attachment":[{"href":"https:\/\/www.newdelhihosting.co.in\/blog\/wp-json\/wp\/v2\/media?parent=151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.newdelhihosting.co.in\/blog\/wp-json\/wp\/v2\/categories?post=151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.newdelhihosting.co.in\/blog\/wp-json\/wp\/v2\/tags?post=151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}