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