asynchresp
7/5/2018 - 7:41 AM

Installing mysql 5.7 on centos 6

Installing mysql 5.7 on centos 6

Installing mysql 5.7 on centos 6

1. download yum repo
	wget http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm

2. install yum repo
	yum -y localinstall mysql57-community-release-el6-7.noarch.rpm

3. verify yum repo
	yum repolist enabled | grep "mysql.*-community.*"

3a. to enable/disable a particular release
# yum-config-manager --disable mysql57-community
# yum-config-manager --enable mysql56-community


4. install 
	yum -y install mysql-community-server
	service mysqld start
	service mysqld status
	mysql --version


5. securing the installation
	grep 'temporary password' /var/log/mysqld.log
	mysql_secure_installation --> follow the prompts
		remove anonymouse users
		disallow root remote login


6. Enjoy
	mysql -u root -p 12345


Useful links:
http://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html
http://www.tecmint.com/install-latest-mysql-on-rhel-centos-and-fedora/