Usually when you try to install MySQL via yum, by default, the version that comes with your OS is always an old version (not the latest version available frommysql.com/downloads).
In order to have the latest version, you always needed to go to mysql.com/downloads and manually download and install MySQL packages right? Not anymore, MySQL recently released the MySQL YUM Repository.
Basically, it will allows you to install the latest GA version of MySQL Community Server, Workbench and Connector/ODBC.
In order to have the latest version, you always needed to go to mysql.com/downloads and manually download and install MySQL packages right? Not anymore, MySQL recently released the MySQL YUM Repository.
Basically, it will allows you to install the latest GA version of MySQL Community Server, Workbench and Connector/ODBC.
HOW TO INSTALL?
You can basically install it in 2 ways:
You can basically install it in 2 ways:
wget http://dev.mysql.com/get/mysql-community-release-el6-3.noarch.rpm/from/http://repo.mysql.com/ sudo yum localinstall -y mysql-community-release-el6-3.noarch.rpm
2. Manually adding a file under
Add the bellow content to a new file named
/etc/yum.repos.d/
folderAdd the bellow content to a new file named
mysql-community.repo
:[mysql-community] name=MySQL Community Server baseurl=URL enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Replace
EL6 (Centos6 / Redhat 6):
baseurl=URL
according to your OS:EL6 (Centos6 / Redhat 6):
baseurl=http://repo.mysql.com/yum/mysql-community/el/6/$basearch/
Fedore 18 and 19:
baseurl=http://repo.mysql.com/yum/mysql-community/fc/$releasever/$basearch/
Note that we have gpgcheck=1, if we use it as 1 in this install method, we will need to add the GnuPG key (see http://dev.mysql.com/doc/refman/5.6/en/checking-gpg-signature.html for more details).
INSTALLING PACKAGES:
Now that we have our repo enabled, it’s just a normal yum command to install the latest version of MySQL Community Server:
Now that we have our repo enabled, it’s just a normal yum command to install the latest version of MySQL Community Server:
yum install mysql-server
LISTING AVAILABLE PACKAGES:
To list the packages available in the yum repo, use the bellow command:
To list the packages available in the yum repo, use the bellow command:
sudo yum --disablerepo=\* --enablerepo=mysql-community list available Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile Available Packages mysql-community-client.x86_64 5.6.14-3.el6 mysql-community mysql-community-common.i686 5.6.14-3.el6 mysql-community mysql-community-common.x86_64 5.6.14-3.el6 mysql-community mysql-community-devel.i686 5.6.14-3.el6 mysql-community mysql-community-devel.x86_64 5.6.14-3.el6 mysql-community mysql-community-embedded.i686 5.6.14-3.el6 mysql-community mysql-community-embedded.x86_64 5.6.14-3.el6 mysql-community mysql-community-embedded-devel.i686 5.6.14-3.el6 mysql-community mysql-community-embedded-devel.x86_64 5.6.14-3.el6 mysql-community mysql-community-libs.i686 5.6.14-3.el6 mysql-community mysql-community-libs.x86_64 5.6.14-3.el6 mysql-community mysql-community-libs-compat.i686 5.6.14-3.el6 mysql-community mysql-community-libs-compat.x86_64 5.6.14-3.el6 mysql-community mysql-community-server.x86_64 5.6.14-3.el6 mysql-community mysql-community-test.x86_64 5.6.14-3.el6 mysql-community mysql-connector-odbc.x86_64 5.2.6-1.el6 mysql-community mysql-workbench-community.x86_64 6.0.7-4.el6 mysql-community
Remember, before change anything on a production server, test, test, test first