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<br /> Loaded plugins: langpacks, refresh-packagekit<br /> repo id repo name status<br /> adobe-flashplayer Adobe Flash Player - x86_64 2<br /> fedora/20/x86_64 Fedora 20 - x86_64 38,597<br /> google-chrome Google Chrome - x86_64 3<br /> oracle-virtualbox/20/x86_64 Oracle VirtualBox - x86_64 10<br /> rpmfusion-free/20/x86_64 RPM Fusion for Fedora 20 - Free 468<br /> rpmfusion-free-updates/20/x86_64 RPM Fusion for Fedora 20 - Free - Updates 464<br /> rpmfusion-nonfree/20/x86_64 RPM Fusion for Fedora 20 - Nonfree 203<br /> rpmfusion-nonfree-updates/20/x86_64 RPM Fusion for Fedora 20 - Nonfree - Updates 299<br /> updates/20/x86_64 Fedora 20 - x86_64 - Updates 17,616<br /> 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<br /> Loaded plugins: langpacks, refresh-packagekit<br /> repo id repo name status<br /> adobe-flashplayer Adobe Flash Player - x86_64 2<br /> fedora/20/x86_64 Fedora 20 - x86_64 38,597<br /> google-chrome Google Chrome - x86_64 3<br /> mysql-connectors-community/20/x86_64 MySQL Connectors Community 14<br /> mysql-tools-community/20/x86_64 MySQL Tools Community 8<br /> mysql56-community/20/x86_64 MySQL 5.6 Community Server 57<br /> oracle-virtualbox/20/x86_64 Oracle VirtualBox - x86_64 10<br /> rpmfusion-free/20/x86_64 RPM Fusion for Fedora 20 - Free 468<br /> rpmfusion-free-updates/20/x86_64 RPM Fusion for Fedora 20 - Free - Updates 464<br /> rpmfusion-nonfree/20/x86_64 RPM Fusion for Fedora 20 - Nonfree 203<br /> rpmfusion-nonfree-updates/20/x86_64 RPM Fusion for Fedora 20 - Nonfree - Updates 299<br /> updates/20/x86_64 Fedora 20 - x86_64 - Updates 17,616<br /> 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<br /> Loaded plugins: langpacks, refresh-packagekit<br /> Available Packages<br /> 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<br /> ln -s '/usr/lib/systemd/system/mysqld.service' '/etc/systemd/system/mysql.service'<br /> 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<br /> 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