Install MySQL Server Community Edition on Fedora 20

Install MySQL Server Community Edition on Fedora 20

Today we are going to go through the process of installing MySQL Server Community Edition on Fedora 20.  You could of course simply use MariaDB, but this will focus on the Community Edition.

Install the MySQL Repository

We will need to install the MySQL Community Repository, the MySQL project hosts an RPM file with the repository.  First lets look at the repositories that I have already.

# yum repolist
Loaded plugins: langpacks, refresh-packagekit
repo id repo name status
adobe-flashplayer Adobe Flash Player - x86_64 2
fedora/20/x86_64 Fedora 20 - x86_64 38,597
google-chrome Google Chrome - x86_64 3
oracle-virtualbox/20/x86_64 Oracle VirtualBox - x86_64 10
rpmfusion-free/20/x86_64 RPM Fusion for Fedora 20 - Free 468
rpmfusion-free-updates/20/x86_64 RPM Fusion for Fedora 20 - Free - Updates 464
rpmfusion-nonfree/20/x86_64 RPM Fusion for Fedora 20 - Nonfree 203
rpmfusion-nonfree-updates/20/x86_64 RPM Fusion for Fedora 20 - Nonfree - Updates 299
updates/20/x86_64 Fedora 20 - x86_64 - Updates 17,616
repolist: 57,662

Now lets install the release file.  Keep in mind, you can do a separate wget or curl to download the file, or you can use the command as I have.  As of the time of this writing there are also repositories for Fedora 18 and 19 and Enterprise Linux 5, 6 and 7 (beta).  Though the only procedures I have validated are the Fedora 20, they should all work the same.

# yum localinstall http://dev.mysql.com/get/mysql-community-release-fc20-5.noarch.rpm

Now lets compare our new repositories to our old and we will see it has added 3 repositories, mysql56-community, mysql-tools-community and mysql-connectors-community

# yum repolist
Loaded plugins: langpacks, refresh-packagekit
repo id repo name status
adobe-flashplayer Adobe Flash Player - x86_64 2
fedora/20/x86_64 Fedora 20 - x86_64 38,597
google-chrome Google Chrome - x86_64 3
mysql-connectors-community/20/x86_64 MySQL Connectors Community 14
mysql-tools-community/20/x86_64 MySQL Tools Community 8
mysql56-community/20/x86_64 MySQL 5.6 Community Server 57
oracle-virtualbox/20/x86_64 Oracle VirtualBox - x86_64 10
rpmfusion-free/20/x86_64 RPM Fusion for Fedora 20 - Free 468
rpmfusion-free-updates/20/x86_64 RPM Fusion for Fedora 20 - Free - Updates 464
rpmfusion-nonfree/20/x86_64 RPM Fusion for Fedora 20 - Nonfree 203
rpmfusion-nonfree-updates/20/x86_64 RPM Fusion for Fedora 20 - Nonfree - Updates 299
updates/20/x86_64 Fedora 20 - x86_64 - Updates 17,616
repolist: 57,741

Install MySQL Server Community

Now that we have the repository we can use yum list to determine what version is available.

# yum list mysql-community-server
Loaded plugins: langpacks, refresh-packagekit
Available Packages
mysql-community-server.x86_64 5.6.19-1.fc20 mysql56-community

Then we can do a yum install to actually perform the install.

# yum install mysql-community-server

Enable the MySQL Server Software

Now we will set the mysqld service to start on reboot.

# systemctl enable mysqld
ln -s '/usr/lib/systemd/system/mysqld.service' '/etc/systemd/system/mysql.service'
ln -s '/usr/lib/systemd/system/mysqld.service' '/etc/systemd/system/multi-user.target.wants/mysqld.service'

Now manually start the mysqld service.  For a development environment, I also added bind-address=127.0.0.1 to /etc/my.cnf under the [mysqld] section.

# service mysqld start
Redirecting to /bin/systemctl start mysqld.service

Install MySQL Workbench Community

Now that we have the repository enabled we can also install additional software such as MySQL Workbench.

# yum install mysql-workbench