結局、CentOS7はいろいろと練れていないところが多すぎる気がする。
もっとバージョンが上がって落ち着きまでは、手を出しちゃいけないんだろうな。
というわけで、CentOS6.5に戻って、MariaDBのインストール作業を行う。
これからMySQLからMariaDBへ移行が進むらしいけれど、どんなものなのやら。
まず、既存のMySQLのパッケージの有無を調べる。
[root@centos6 hogehoge]# rpm -qa | grep mysql
mysql-libs-5.1.73-3.el6_5.x86_64
mysql-5.1.73-3.el6_5.x86_64
mysql-devel-5.1.73-3.el6_5.x86_64
これはデフォルトでインストールされているパッケージだね。
じゃ、これを削除する。
[root@centos6 hogehoge]# yum remove mysql*
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.1.73-3.el6_5 will be erased
---> Package mysql-devel.x86_64 0:5.1.73-3.el6_5 will be erased
---> Package mysql-libs.x86_64 0:5.1.73-3.el6_5 will be erased
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Running transaction check
---> Package postfix.x86_64 2:2.6.6-6.el6_5 will be erased
--> Processing Dependency: /usr/sbin/sendmail for package: redhat-lsb-core-4.0-7.el6.centos.x86_64
--> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-12.el6.x86_64
--> Running transaction check
---> Package cronie.x86_64 0:1.4.4-12.el6 will be erased
--> Processing Dependency: cronie = 1.4.4-12.el6 for package: cronie-anacron-1.4.4-12.el6.x86_64
---> Package redhat-lsb-core.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0 for package: redhat-lsb-printing-4.0-7.el6.centos.x86_64
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0-7.el6.centos for package: redhat-lsb-4.0-7.el6.centos.x86_64
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0 for package: redhat-lsb-graphics-4.0-7.el6.centos.x86_64
--> Running transaction check
---> Package cronie-anacron.x86_64 0:1.4.4-12.el6 will be erased
---> Package redhat-lsb.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: redhat-lsb(x86-64) = 4.0-7.el6.centos for package: redhat-lsb-compat-4.0-7.el6.centos.x86_64
---> Package redhat-lsb-graphics.x86_64 0:4.0-7.el6.centos will be erased
---> Package redhat-lsb-printing.x86_64 0:4.0-7.el6.centos will be erased
--> Running transaction check
---> Package redhat-lsb-compat.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch
--> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-22.el6.x86_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package crontabs.noarch 0:1.10-33.el6 will be erased
---> Package sysstat.x86_64 0:9.0.4-22.el6 will be erased
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Removing:
mysql x86_64 5.1.73-3.el6_5 @updates 2.4 M
mysql-devel
x86_64 5.1.73-3.el6_5 @updates 388 k
mysql-libs
x86_64 5.1.73-3.el6_5 @updates 4.0 M
Removing for dependencies:
cronie x86_64 1.4.4-12.el6 @anaconda-CentOS-201311272149.x86_64/6.5 174 k
cronie-anacron
x86_64 1.4.4-12.el6 @anaconda-CentOS-201311272149.x86_64/6.5 43 k
crontabs
noarch 1.10-33.el6 @anaconda-CentOS-201311272149.x86_64/6.5 2.4 k
postfix x86_64 2:2.6.6-6.el6_5 @updates 9.7 M
redhat-lsb
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0
redhat-lsb-compat
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0
redhat-lsb-core
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 22 k
redhat-lsb-graphics
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0
redhat-lsb-printing
x86_64 4.0-7.el6.centos @anaconda-CentOS-201311272149.x86_64/6.5 0.0
sysstat x86_64 9.0.4-22.el6 @anaconda-CentOS-201311272149.x86_64/6.5 824 k
Transaction Summary
================================================================================
Remove 13 Package(s)
Installed size: 18 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Erasing : redhat-lsb-compat-4.0-7.el6.centos.x86_64 1/13
Erasing : redhat-lsb-4.0-7.el6.centos.x86_64 2/13
Erasing : mysql-devel-5.1.73-3.el6_5.x86_64 3/13
Erasing : redhat-lsb-graphics-4.0-7.el6.centos.x86_64 4/13
Erasing : redhat-lsb-printing-4.0-7.el6.centos.x86_64 5/13
Erasing : redhat-lsb-core-4.0-7.el6.centos.x86_64 6/13
Erasing : mysql-5.1.73-3.el6_5.x86_64 7/13
/var/tmp/rpm-tmp.OHPbrg: line 1: lsb_release: コマンドが見つかりません
Erasing : sysstat-9.0.4-22.el6.x86_64 8/13
Erasing : crontabs-1.10-33.el6.noarch 9/13
Erasing : cronie-anacron-1.4.4-12.el6.x86_64 10/13
Erasing : cronie-1.4.4-12.el6.x86_64 11/13
Erasing : 2:postfix-2.6.6-6.el6_5.x86_64 12/13
Erasing : mysql-libs-5.1.73-3.el6_5.x86_64 13/13
Verifying : mysql-devel-5.1.73-3.el6_5.x86_64 1/13
Verifying : redhat-lsb-printing-4.0-7.el6.centos.x86_64 2/13
Verifying : cronie-anacron-1.4.4-12.el6.x86_64 3/13
Verifying : redhat-lsb-core-4.0-7.el6.centos.x86_64 4/13
Verifying : mysql-libs-5.1.73-3.el6_5.x86_64 5/13
Verifying : redhat-lsb-4.0-7.el6.centos.x86_64 6/13
Verifying : mysql-5.1.73-3.el6_5.x86_64 7/13
Verifying : crontabs-1.10-33.el6.noarch 8/13
Verifying : redhat-lsb-compat-4.0-7.el6.centos.x86_64 9/13
Verifying : sysstat-9.0.4-22.el6.x86_64 10/13
Verifying : cronie-1.4.4-12.el6.x86_64 11/13
Verifying : 2:postfix-2.6.6-6.el6_5.x86_64 12/13
Verifying : redhat-lsb-graphics-4.0-7.el6.centos.x86_64 13/13
Removed:
mysql.x86_64 0:5.1.73-3.el6_5 mysql-devel.x86_64 0:5.1.73-3.el6_5
mysql-libs.x86_64 0:5.1.73-3.el6_5
Dependency Removed:
cronie.x86_64 0:1.4.4-12.el6
cronie-anacron.x86_64 0:1.4.4-12.el6
crontabs.noarch 0:1.10-33.el6
postfix.x86_64 2:2.6.6-6.el6_5
redhat-lsb.x86_64 0:4.0-7.el6.centos
redhat-lsb-compat.x86_64 0:4.0-7.el6.centos
redhat-lsb-core.x86_64 0:4.0-7.el6.centos
redhat-lsb-graphics.x86_64 0:4.0-7.el6.centos
redhat-lsb-printing.x86_64 0:4.0-7.el6.centos
sysstat.x86_64 0:9.0.4-22.el6
Complete!
[root@centos6 hogehoge]# rpm -qa | grep mysql
[root@centos6 hogehoge]#
きれいさっぱりなくなりました。
で、MariaDBのインストールに取りかかる。
まず最初に、RPG-GPG-KEYを追加する
[root@centos6 hogehoge]# sudo rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
次に、リポジトリを追加作業を実施。
今回はバージョン10.0.12にトライ!
[root@centos6 hogehoge]# vi /etc/yum.repos.d/MariaDB.repo
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0.12/centos6-x86
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
enabled=1
リポジトリの追加作業が終わったら、インストールを実行。
[root@centos6 hogehoge]# yum install MariaDB-devel MariaDB-client MariaDB-server
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
mariadb | 1.9 kB 00:00
mariadb/primary_db | 18 kB 00:00
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.i686 0:10.0.12-1.el6 will be installed
--> Processing Dependency: MariaDB-common for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libtinfo.so.5 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libcrypt.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libdl.so.2(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libcrypt.so.1(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: ld-linux.so.2 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.3.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.3.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libaio.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: librt.so.1(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libstdc++.so.6 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: librt.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libdl.so.2 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libaio.so.1(LIBAIO_0.4) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libstdc++.so.6(GLIBCXX_3.4) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libaio.so.1(LIBAIO_0.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libncurses.so.5 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: ld-linux.so.2(GLIBC_2.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libcrypto.so.10 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libstdc++.so.6(CXXABI_1.3) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.0) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libdl.so.2(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libssl.so.10 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libz.so.1 for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libm.so.6(GLIBC_2.2) for package: MariaDB-client-10.0.12-1.el6.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1) for package: MariaDB-client-10.0.12-1.el6.i686
---> Package MariaDB-devel.i686 0:10.0.12-1.el6 will be installed
---> Package MariaDB-server.i686 0:10.0.12-1.el6 will be installed
--> Processing Dependency: libpam.so.0(LIBPAM_1.0) for package: MariaDB-server-10.0.12-1.el6.i686
--> Processing Dependency: libpam.so.0 for package: MariaDB-server-10.0.12-1.el6.i686
--> Running transaction check
---> Package MariaDB-common.i686 0:10.0.12-1.el6 will be installed
--> Processing Dependency: MariaDB-compat for package: MariaDB-common-10.0.12-1.el6.i686
---> Package glibc.i686 0:2.12-1.132.el6_5.2 will be installed
--> Processing Dependency: libfreebl3.so(NSSRAWHASH_3.12.3) for package: glibc-2.12-1.132.el6_5.2.i686
--> Processing Dependency: libfreebl3.so for package: glibc-2.12-1.132.el6_5.2.i686
---> Package libaio.i686 0:0.3.107-10.el6 will be installed
---> Package libstdc++.i686 0:4.4.7-4.el6 will be installed
--> Processing Dependency: libgcc_s.so.1(GLIBC_2.0) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1(GCC_4.2.0) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1(GCC_3.3) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1(GCC_3.0) for package: libstdc++-4.4.7-4.el6.i686
--> Processing Dependency: libgcc_s.so.1 for package: libstdc++-4.4.7-4.el6.i686
---> Package ncurses-libs.i686 0:5.7-3.20090208.el6 will be installed
---> Package openssl.i686 0:1.0.1e-16.el6_5.14 will be installed
--> Processing Dependency: libkrb5.so.3(krb5_3_MIT) for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libkrb5.so.3 for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libk5crypto.so.3(k5crypto_3_MIT) for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libk5crypto.so.3 for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libgssapi_krb5.so.2 for package: openssl-1.0.1e-16.el6_5.14.i686
--> Processing Dependency: libcom_err.so.2 for package: openssl-1.0.1e-16.el6_5.14.i686
---> Package pam.i686 0:1.1.1-17.el6 will be installed
--> Processing Dependency: libselinux.so.1 for package: pam-1.1.1-17.el6.i686
--> Processing Dependency: libdb-4.7.so for package: pam-1.1.1-17.el6.i686
--> Processing Dependency: libcrack.so.2 for package: pam-1.1.1-17.el6.i686
--> Processing Dependency: libaudit.so.1 for package: pam-1.1.1-17.el6.i686
---> Package zlib.i686 0:1.2.3-29.el6 will be installed
--> Running transaction check
---> Package MariaDB-compat.i686 0:10.0.12-1.el6 will be installed
---> Package audit-libs.i686 0:2.2-4.el6_5 will be installed
---> Package cracklib.i686 0:2.8.16-4.el6 will be installed
---> Package db4.i686 0:4.7.25-18.el6_4 will be installed
---> Package krb5-libs.i686 0:1.10.3-15.el6_5.1 will be installed
--> Processing Dependency: libkeyutils.so.1(KEYUTILS_0.3) for package: krb5-libs-1.10.3-15.el6_5.1.i686
--> Processing Dependency: libkeyutils.so.1 for package: krb5-libs-1.10.3-15.el6_5.1.i686
---> Package libcom_err.i686 0:1.41.12-18.el6 will be installed
---> Package libgcc.i686 0:4.4.7-4.el6 will be installed
---> Package libselinux.i686 0:2.0.94-5.3.el6_4.1 will be installed
---> Package nss-softokn-freebl.i686 0:3.14.3-10.el6_5 will be installed
--> Running transaction check
---> Package keyutils-libs.i686 0:1.4-4.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
MariaDB-client i686 10.0.12-1.el6 mariadb 11 M
MariaDB-devel i686 10.0.12-1.el6 mariadb 6.4 M
MariaDB-server i686 10.0.12-1.el6 mariadb 40 M
Installing for dependencies:
MariaDB-common i686 10.0.12-1.el6 mariadb 23 k
MariaDB-compat i686 10.0.12-1.el6 mariadb 2.6 M
audit-libs i686 2.2-4.el6_5 updates 61 k
cracklib i686 2.8.16-4.el6 base 70 k
db4 i686 4.7.25-18.el6_4 base 580 k
glibc i686 2.12-1.132.el6_5.2 updates 4.3 M
keyutils-libs i686 1.4-4.el6 base 20 k
krb5-libs i686 1.10.3-15.el6_5.1 updates 769 k
libaio i686 0.3.107-10.el6 base 21 k
libcom_err i686 1.41.12-18.el6 base 37 k
libgcc i686 4.4.7-4.el6 base 112 k
libselinux i686 2.0.94-5.3.el6_4.1 base 108 k
libstdc++ i686 4.4.7-4.el6 base 300 k
ncurses-libs i686 5.7-3.20090208.el6 base 251 k
nss-softokn-freebl i686 3.14.3-10.el6_5 updates 147 k
openssl i686 1.0.1e-16.el6_5.14 updates 1.5 M
pam i686 1.1.1-17.el6 base 659 k
zlib i686 1.2.3-29.el6 base 73 k
Transaction Summary
================================================================================
Install 21 Package(s)
Total download size: 69 M
Installed size: 264 M
Is this ok [y/N]: y
Downloading Packages:
(1/21): MariaDB-10.0.12-centos6-i686-client.rpm | 11 MB 00:23
(2/21): MariaDB-10.0.12-centos6-i686-common.rpm | 23 kB 00:00
(3/21): MariaDB-10.0.12-centos6-i686-compat.rpm | 2.6 MB 00:07
(4/21): MariaDB-10.0.12-centos6-i686-devel.rpm | 6.4 MB 00:28
(5/21): MariaDB-10.0.12-centos6-i686-server.rpm | 40 MB 03:40
(6/21): audit-libs-2.2-4.el6_5.i686.rpm | 61 kB 00:00
(7/21): cracklib-2.8.16-4.el6.i686.rpm | 70 kB 00:00
(8/21): db4-4.7.25-18.el6_4.i686.rpm | 580 kB 00:01
(9/21): glibc-2.12-1.132.el6_5.2.i686.rpm | 4.3 MB 00:10
(10/21): keyutils-libs-1.4-4.el6.i686.rpm | 20 kB 00:00
(11/21): krb5-libs-1.10.3-15.el6_5.1.i686.rpm | 769 kB 00:02
(12/21): libaio-0.3.107-10.el6.i686.rpm | 21 kB 00:00
(13/21): libcom_err-1.41.12-18.el6.i686.rpm | 37 kB 00:00
(14/21): libgcc-4.4.7-4.el6.i686.rpm | 112 kB 00:00
(15/21): libselinux-2.0.94-5.3.el6_4.1.i686.rpm | 108 kB 00:00
(16/21): libstdc++-4.4.7-4.el6.i686.rpm | 300 kB 00:00
(17/21): ncurses-libs-5.7-3.20090208.el6.i686.rpm | 251 kB 00:00
(18/21): nss-softokn-freebl-3.14.3-10.el6_5.i686.rpm | 147 kB 00:00
(19/21): openssl-1.0.1e-16.el6_5.14.i686.rpm | 1.5 MB 00:04
(20/21): pam-1.1.1-17.el6.i686.rpm | 659 kB 00:02
(21/21): zlib-1.2.3-29.el6.i686.rpm | 73 kB 00:00
--------------------------------------------------------------------------------
Total 228 kB/s | 69 MB 05:07
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : libgcc-4.4.7-4.el6.i686 1/21
Installing : glibc-2.12-1.132.el6_5.2.i686 2/21
Installing : nss-softokn-freebl-3.14.3-10.el6_5.i686 3/21
Installing : zlib-1.2.3-29.el6.i686 4/21
Installing : libstdc++-4.4.7-4.el6.i686 5/21
Installing : libselinux-2.0.94-5.3.el6_4.1.i686 6/21
Installing : libcom_err-1.41.12-18.el6.i686 7/21
Installing : libaio-0.3.107-10.el6.i686 8/21
Installing : MariaDB-compat-10.0.12-1.el6.i686 9/21
Installing : MariaDB-common-10.0.12-1.el6.i686 10/21
Installing : cracklib-2.8.16-4.el6.i686 11/21
Installing : keyutils-libs-1.4-4.el6.i686 12/21
Installing : krb5-libs-1.10.3-15.el6_5.1.i686 13/21
Installing : openssl-1.0.1e-16.el6_5.14.i686 14/21
Installing : audit-libs-2.2-4.el6_5.i686 15/21
Installing : ncurses-libs-5.7-3.20090208.el6.i686 16/21
Installing : MariaDB-client-10.0.12-1.el6.i686 17/21
Installing : db4-4.7.25-18.el6_4.i686 18/21
Installing : MariaDB-devel-10.0.12-1.el6.i686 19/21
Installing : pam-1.1.1-17.el6.i686 20/21
Installing : MariaDB-server-10.0.12-1.el6.i686 21/21
chown: cannot access `/var/lib/mysql': そのようなファイルやディレクトリはありません
140720 20:42:53 [Note] InnoDB: Using mutexes to ref count buffer pool pages
140720 20:42:53 [Note] InnoDB: The InnoDB memory heap is disabled
140720 20:42:53 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
140720 20:42:53 [Note] InnoDB: Compressed tables use zlib 1.2.3
140720 20:42:53 [Note] InnoDB: Using Linux native AIO
140720 20:42:53 [Note] InnoDB: Not using CPU crc32 instructions
140720 20:42:53 [Note] InnoDB: Initializing buffer pool, size = 128.0M
140720 20:42:53 [Note] InnoDB: Completed initialization of buffer pool
140720 20:42:53 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
140720 20:42:53 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
140720 20:42:53 [Note] InnoDB: Database physically writes the file full: wait...
140720 20:42:53 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
140720 20:42:54 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
140720 20:42:54 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
140720 20:42:54 [Warning] InnoDB: New log files created, LSN=45781
140720 20:42:54 [Note] InnoDB: Doublewrite buffer not found: creating new
140720 20:42:54 [Note] InnoDB: Doublewrite buffer created
140720 20:42:54 [Note] InnoDB: 128 rollback segment(s) are active.
140720 20:42:54 [Warning] InnoDB: Creating foreign key constraint system tables.
140720 20:42:54 [Note] InnoDB: Foreign key constraint system tables created
140720 20:42:54 [Note] InnoDB: Creating tablespace and datafile system tables.
140720 20:42:54 [Note] InnoDB: Tablespace and datafile system tables created.
140720 20:42:54 [Note] InnoDB: Waiting for purge to start
140720 20:42:54 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.17-65.0 started; log sequence number 0
140720 20:42:55 [Note] InnoDB: FTS optimize thread exiting.
140720 20:42:55 [Note] InnoDB: Starting shutdown...
140720 20:42:57 [Note] InnoDB: Shutdown completed; log sequence number 1616697
140720 20:42:57 [Note] InnoDB: Using mutexes to ref count buffer pool pages
140720 20:42:57 [Note] InnoDB: The InnoDB memory heap is disabled
140720 20:42:57 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
140720 20:42:57 [Note] InnoDB: Compressed tables use zlib 1.2.3
140720 20:42:57 [Note] InnoDB: Using Linux native AIO
140720 20:42:57 [Note] InnoDB: Not using CPU crc32 instructions
140720 20:42:57 [Note] InnoDB: Initializing buffer pool, size = 128.0M
140720 20:42:57 [Note] InnoDB: Completed initialization of buffer pool
140720 20:42:57 [Note] InnoDB: Highest supported file format is Barracuda.
140720 20:42:57 [Note] InnoDB: 128 rollback segment(s) are active.
140720 20:42:57 [Note] InnoDB: Waiting for purge to start
140720 20:42:57 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.17-65.0 started; log sequence number 1616697
140720 20:42:57 [Note] InnoDB: FTS optimize thread exiting.
140720 20:42:57 [Note] InnoDB: Starting shutdown...
140720 20:42:59 [Note] InnoDB: Shutdown completed; log sequence number 1616707
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:
'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h centos6.5 password 'new-password'
Alternatively you can run:
'/usr/bin/mysql_secure_installation'
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.
Please report any problems at http://mariadb.org/jira
The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from
SkySQL Ab. You can contact us about this at sales@skysql.com.
Alternatively consider joining our community based development effort:
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
Verifying : cracklib-2.8.16-4.el6.i686 1/21
Verifying : libstdc++-4.4.7-4.el6.i686 2/21
Verifying : MariaDB-client-10.0.12-1.el6.i686 3/21
Verifying : MariaDB-common-10.0.12-1.el6.i686 4/21
Verifying : libselinux-2.0.94-5.3.el6_4.1.i686 5/21
Verifying : libcom_err-1.41.12-18.el6.i686 6/21
Verifying : nss-softokn-freebl-3.14.3-10.el6_5.i686 7/21
Verifying : MariaDB-devel-10.0.12-1.el6.i686 8/21
Verifying : keyutils-libs-1.4-4.el6.i686 9/21
Verifying : libgcc-4.4.7-4.el6.i686 10/21
Verifying : audit-libs-2.2-4.el6_5.i686 11/21
Verifying : ncurses-libs-5.7-3.20090208.el6.i686 12/21
Verifying : libaio-0.3.107-10.el6.i686 13/21
Verifying : MariaDB-server-10.0.12-1.el6.i686 14/21
Verifying : MariaDB-compat-10.0.12-1.el6.i686 15/21
Verifying : pam-1.1.1-17.el6.i686 16/21
Verifying : db4-4.7.25-18.el6_4.i686 17/21
Verifying : openssl-1.0.1e-16.el6_5.14.i686 18/21
Verifying : krb5-libs-1.10.3-15.el6_5.1.i686 19/21
Verifying : glibc-2.12-1.132.el6_5.2.i686 20/21
Verifying : zlib-1.2.3-29.el6.i686 21/21
Installed:
MariaDB-client.i686 0:10.0.12-1.el6 MariaDB-devel.i686 0:10.0.12-1.el6
MariaDB-server.i686 0:10.0.12-1.el6
Dependency Installed:
MariaDB-common.i686 0:10.0.12-1.el6
MariaDB-compat.i686 0:10.0.12-1.el6
audit-libs.i686 0:2.2-4.el6_5
cracklib.i686 0:2.8.16-4.el6
db4.i686 0:4.7.25-18.el6_4
glibc.i686 0:2.12-1.132.el6_5.2
keyutils-libs.i686 0:1.4-4.el6
krb5-libs.i686 0:1.10.3-15.el6_5.1
libaio.i686 0:0.3.107-10.el6
libcom_err.i686 0:1.41.12-18.el6
libgcc.i686 0:4.4.7-4.el6
libselinux.i686 0:2.0.94-5.3.el6_4.1
libstdc++.i686 0:4.4.7-4.el6
ncurses-libs.i686 0:5.7-3.20090208.el6
nss-softokn-freebl.i686 0:3.14.3-10.el6_5
openssl.i686 0:1.0.1e-16.el6_5.14
pam.i686 0:1.1.1-17.el6
zlib.i686 0:1.2.3-29.el6
Complete!
で、MariaDB関連のインストールは終わったらしい。
バージョンを確認してみると。
[root@centos6 /]# mysqld --version
mysqld Ver 10.0.12-MariaDB for Linux on i686 (MariaDB Server)
MySQLでありながらMariaDBという、この気持ち悪さはなんなんだ!? (^^;
で、MariaDBを起動させる。
[root@centos6 /]# sudo service mysql start
Starting MySQL. SUCCESS!
ついでに、CentOS6.5起動時にMariaDBを自動起動するためのまじないも。
[root@centos6 /]# sudo chkconfig mysql on
じゃ、動作確認してみますか.
[hogehoge@centos6 ~]$ mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.0.12-MariaDB MariaDB Server
Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
rootのパスワードを変更しておこう。
MariaDB [(none)]> SET PASSWORD for root@localhost=PASSWORD('hogehoge');
Query OK, 0 rows affected (0.04 sec)
これでrootのパスワードが設定された。
MariaDBのインストールはここまで。
0 件のコメント:
コメントを投稿