This how-to guide is to install or upgrade your MySQL version on RHEL/CentOS 6-5 and Fedora 18,17/16/15/14/13/12 using Remi repository via YUM utility. But before moving into further steps let’s understand little bit about MySQL.
What is MySQL?
MySQL is an open source free relational database management system (RDBMS) released under GNU (General Public License). It is used to run multiple databases on any single server by providing multi-user access to each created database.
Step 1: Installing Remi Repository
Firstly, we need to install the Remi repository on your selected Linux distributions.
For Fedora 18-12
## Install Remi Repository on Fedora 17, 16, 15 rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm rpm -Uvh http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm ## Fedora 18 ## rpm -Uvh http://rpms.famillecollet.com/remi-release-18.rpm ## Fedora 17 ## rpm -Uvh http://rpms.famillecollet.com/remi-release-17.rpm ## Fedora 16 ## rpm -Uvh http://rpms.famillecollet.com/remi-release-16.rpm ## Fedora 15 ## rpm -Uvh http://rpms.famillecollet.com/remi-release-15.rpm ## Fedora 14 ## rpm -Uvh http://rpms.famillecollet.com/remi-release-14.rpm ## Fedora 13 ## rpm -Uvh http://rpms.famillecollet.com/remi-release-13.rpm ## Fedora 12 ## rpm -Uvh http://rpms.famillecollet.com/remi-release-12.rpm
For RHEL/CentOS 6-5
## Install Remi Repository on RHEL/CentOS 6.7-6.0 ## rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-7.noarch.rpm rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm ## Install Remi Repository on RHEL/CentOS 5.4-5.0 ## rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
Step 2. Checking MySQL 5.5.30 Availability
After, installing Remi repository on your system, then look for MySQL latest version using –enablerepo=remi switch option.
# yum --enablerepo=remi list mysql mysql-server
Available Packages mysql.i686 5.5.30-1.el6.remi remi mysql-server.i686 5.5.30-1.el6.remi remi
Step 3: Updating or Installing MySQL 5.5.30
Once you see the latest MySQL version is available for installation, then follow below steps to update or install MySQL 5.5.30.
# yum --enablerepo=remi install mysql mysql-server
Step 4: Starting/Stopping MySQL Server
Follow the below command to start/stop of the MySQL service.
# /etc/init.d/mysqld start # /etc/init.d/mysqld stop # /etc/init.d/mysqld status
Step 5: Connecting to MySQL Server
Connecting to newly installed MySQL server by providing username and password. If you haven’t yet set any password for your MySQL installation the simply hit enter.
# mysql -u root -p
[root@twiki ~]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 1052 Server version: 5.5.30 MySQL Community Server (GPL) by Remi Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. mysql>
That’s it, you’ve successfully installed MySQL 5.5.30 on your system. If you’re having any trouble installing feel free to use our comment section for solutions.
Latest posts by Ravi Saive (see all)
- CentOS 6.5 Released – Upgrade from CentOS 6.x to CentOS 6.5 - December 2, 2013
- Upgrade Linux Mint 15 (Olivia) to Linux Mint 16 (Petra) - December 1, 2013
- How to Get Root and User SSH Login Email Alerts - November 28, 2013
Linux Services & Free WordPress Setup
Our post is simply ‘DIY’ aka ‘Do It Yourself, still you may find difficulties and want us to help you out. We offer wide range of Linux and Web Hosting Solutions at fair minimum rates. Please submit your orders by Clicking Here.