MariaDB adalah pengganti MySQL yang lagi banyak dibicarakan di seantro internet. Sekarang kita akan menginstall MariaDB di Fedora 18, buat sebuah file baru bernama MariaDB.repo di /etc/yum.repos.d/
nano /etc/yum.repos.d/MariaDB.repo
tambahkan baris dibawah ini kedalam MariaDB.repo
[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/5.5/fedora18-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1
Instalasi
Sebelum instalasi ini ada baiknya adana mem-backup data-data MySQL yang anda gunakan, karena MySQL akan di gantikan dengan MariaDB.
su -c "yum install MariaDB-client MariaDB-server -y"
Setelah instalasi MariaDB, langkah selanjutnya adalah membuat password untuk root
mysql_secure_installation
ikuti wizard yang muncul untuk menyelesaikan pembuatan password untuk root MariaDB, sekarang jalankan service MariaDB
sudo -c "/etc/init.d/mysql restart"
Error dan Cara Mengatasinya
Transaction Check Error: file /etc/my.cnf from install of MariaDB-common-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/charsets/Index.xml from install of MariaDB-common-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/czech/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/dutch/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/english/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/estonian/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/french/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/german/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/greek/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/hungarian/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/italian/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/japanese/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/korean/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/norwegian-ny/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/norwegian/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/polish/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/portuguese/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/romanian/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/russian/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/serbian/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/slovak/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/spanish/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/swedish/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 file /usr/share/mysql/ukrainian/errmsg.sys from install of MariaDB-server-5.5.29-1.x86_64 conflicts with file from package mysql-libs-5.5.29-1.fc18.x86_64 Error Summary -------------
error yang sama solusinya dengan yang diatas
error: Failed dependencies: libmysqlclient.so.18()(64bit) is needed by (installed) perl-DBD-MySQL-4.022-1.fc18.x86_64 libmysqlclient.so.18()(64bit) is needed by (installed) php-mysql-5.4.10-1.fc18.x86_64 libmysqlclient.so.18()(64bit) is needed by (installed) gambas3-gb-db-mysql-3.3.4-2.fc18.x86_64 libmysqlclient.so.18()(64bit) is needed by (installed) gammu-libs-1.26.1-9.fc18.x86_64 libmysqlclient.so.18()(64bit) is needed by (installed) gammu-1.26.1-9.fc18.x86_64 libmysqlclient.so.18()(64bit) is needed by (installed) python-gammu-1.26.1-9.fc18.x86_64 libmysqlclient.so.18()(64bit) is needed by (installed) gmyth-0.7.1-19.fc18.x86_64 libmysqlclient.so.18()(64bit) is needed by (installed) gstreamer-plugins-bad-free-extras-0.10.23-13.fc18.x86_64 libmysqlclient.so.18()(64bit) is needed by (installed) net-snmp-1:5.7.2-5.fc18.x86_64 libmysqlclient.so.18(libmysqlclient_16)(64bit) is needed by (installed) perl-DBD-MySQL-4.022-1.fc18.x86_64 libmysqlclient.so.18(libmysqlclient_16)(64bit) is needed by (installed) php-mysql-5.4.10-1.fc18.x86_64 libmysqlclient.so.18(libmysqlclient_16)(64bit) is needed by (installed) gambas3-gb-db-mysql-3.3.4-2.fc18.x86_64 libmysqlclient.so.18(libmysqlclient_16)(64bit) is needed by (installed) gammu-libs-1.26.1-9.fc18.x86_64 libmysqlclient.so.18(libmysqlclient_16)(64bit) is needed by (installed) gmyth-0.7.1-19.fc18.x86_64 libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) php-mysql-5.4.10-1.fc18.x86_64 mysql-libs is needed by (installed) net-snmp-1:5.7.2-5.fc18.x86_64
Cara untuk mengatasi error diatas adalah dengan menghapus mysql-libs
sudo -c "rpm -e --nodeps mysql-libs"