CentOS5.5にMySQL5.1をyumでインストールする方法
# yum --enablerepo=remi,epel update mysql* Loaded plugins: downloadonly Setting up Update Process Resolving Dependencies --> Running transaction check ---> Package mysql.x86_64 0:5.1.54-1.el5.remi set to be updated --> Processing Dependency: mysql-libs = 5.1.54-1.el5.remi for package: mysql --> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: mysql --> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: mysql --> Processing Dependency: libmysqlclient.so.16()(64bit) for package: mysql --> Processing Dependency: libmysqlclient_r.so.16()(64bit) for package: mysql ---> Package mysql-devel.x86_64 0:5.1.54-1.el5.remi set to be updated --> Running transaction check ---> Package mysql-libs.x86_64 0:5.1.54-1.el5.remi set to be updated --> Finished Dependency Resolution Dependencies Resolved ======================================================================================= Package Arch Version Repository Size ======================================================================================= Updating: mysql x86_64 5.1.54-1.el5.remi remi 1.1 M mysql-devel x86_64 5.1.54-1.el5.remi remi 121 k Installing for dependencies: mysql-libs x86_64 5.1.54-1.el5.remi remi 1.7 M Transaction Summary ======================================================================================= Install 1 Package(s) Upgrade 2 Package(s) Total size: 2.9 M Is this ok [y/N]: y Downloading Packages: Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Check Error: file /etc/my.cnf from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/charsets/Index.xml from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/charsets/cp1250.xml from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/czech/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/danish/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/dutch/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/english/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/estonian/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/french/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/german/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/greek/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/hungarian/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/italian/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/japanese/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/korean/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/norwegian-ny/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/norwegian/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/polish/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/portuguese/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/romanian/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/russian/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/serbian/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/slovak/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/spanish/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/swedish/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/mysql/ukrainian/errmsg.sys from install of mysql-libs-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/man/man1/my_print_defaults.1.gz from install of mysql-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/man/man1/mysql.1.gz from install of mysql-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/man/man1/mysql_config.1.gz from install of mysql-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/man/man1/mysql_find_rows.1.gz from install of mysql-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/man/man1/mysql_waitpid.1.gz from install of mysql-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/man/man1/mysqlaccess.1.gz from install of mysql-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/man/man1/mysqladmin.1.gz from install of mysql-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/man/man1/mysqldump.1.gz from install of mysql-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 file /usr/share/man/man1/mysqlshow.1.gz from install of mysql-5.1.54-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-4.el5_5.4.i386 Error Summary -------------
コンフリクトしていますな。何が入っているか見てましょう。
# rpm -qa | grep mysql mysql-5.0.77-4.el5_5.4 mysql-5.0.77-4.el5_5.4 mysql-devel-5.0.77-4.el5_5.4 mysql-devel-5.0.77-4.el5_5.4
5.0.7がデフォルトで入っています。
これを削除して新しいバージョンをインストールしましょう。
# yum remove mysql Loaded plugins: downloadonly Setting up Remove Process Resolving Dependencies --> Running transaction check ---> Package mysql.i386 0:5.0.77-4.el5_5.4 set to be erased --> Processing Dependency: libmysqlclient.so.15 for package: mysql-devel --> Processing Dependency: libmysqlclient_r.so.15 for package: mysql-devel --> Processing Dependency: mysql = 5.0.77-4.el5_5.4 for package: mysql-devel --> Processing Dependency: mysql = 5.0.77-4.el5_5.4 for package: mysql-devel ---> Package mysql.x86_64 0:5.0.77-4.el5_5.4 set to be erased --> Running transaction check ---> Package mysql-devel.i386 0:5.0.77-4.el5_5.4 set to be erased ---> Package mysql-devel.x86_64 0:5.0.77-4.el5_5.4 set to be erased --> Finished Dependency Resolution Dependencies Resolved ======================================================================================= Package Arch Version Repository Size ======================================================================================= Removing: mysql i386 5.0.77-4.el5_5.4 installed 7.9 M mysql x86_64 5.0.77-4.el5_5.4 installed 8.1 M Removing for dependencies: mysql-devel i386 5.0.77-4.el5_5.4 installed 5.6 M mysql-devel x86_64 5.0.77-4.el5_5.4 installed 6.3 M Transaction Summary ======================================================================================= Remove 4 Package(s) Reinstall 0 Package(s) Downgrade 0 Package(s) Is this ok [y/N]: y Downloading Packages: Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Erasing : mysql 1/4 Erasing : mysql-devel 2/4 Erasing : mysql-devel 3/4 Erasing : mysql 4/4 Removed: mysql.i386 0:5.0.77-4.el5_5.4 mysql.x86_64 0:5.0.77-4.el5_5.4 Dependency Removed: mysql-devel.i386 0:5.0.77-4.el5_5.4 mysql-devel.x86_64 0:5.0.77-4.el5_5.4 Complete!
# yum --enablerepo=remi,epel install mysql Loaded plugins: downloadonly remi | 2.6 kB 00:00 Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package mysql.i386 0:5.0.77-4.el5_5.4 set to be updated ---> Package mysql.x86_64 0:5.1.54-1.el5.remi set to be updated --> Processing Dependency: mysql-libs = 5.1.54-1.el5.remi for package: mysql --> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: mysql --> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: mysql --> Processing Dependency: libmysqlclient.so.16()(64bit) for package: mysql --> Processing Dependency: libmysqlclient_r.so.16()(64bit) for package: mysql --> Running transaction check ---> Package mysql-libs.x86_64 0:5.1.54-1.el5.remi set to be updated --> Finished Dependency Resolution Dependencies Resolved ======================================================================================= Package Arch Version Repository Size ======================================================================================= Installing: mysql i386 5.0.77-4.el5_5.4 updates 4.8 M mysql x86_64 5.1.54-1.el5.remi remi 1.1 M Installing for dependencies: mysql-libs x86_64 5.1.54-1.el5.remi remi 1.7 M Transaction Summary ======================================================================================= Install 3 Package(s) Upgrade 0 Package(s) Total size: 7.5 M Total download size: 4.8 M Is this ok [y/N]: y Downloading Packages: mysql-5.0.77-4.el5_5.4.i386.rpm | 4.8 MB 00:00 Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction WARNING : This MySQL RPM is not an official Fedora/Redhat build and it overrides the official one. Don't file bugs on Fedora Project nor Redhat. Use dedicated forums http://forums.famillecollet.com/ Installing : mysql-libs 1/3 Installing : mysql 2/3 Installing : mysql 3/3 Installed: mysql.i386 0:5.0.77-4.el5_5.4 mysql.x86_64 0:5.1.54-1.el5.remi Dependency Installed: mysql-libs.x86_64 0:5.1.54-1.el5.remi Complete! [root@web src]# yum --enablerepo=remi,epel install mysql-devel Loaded plugins: downloadonly Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package mysql-devel.i386 0:5.0.77-4.el5_5.4 set to be updated ---> Package mysql-devel.x86_64 0:5.1.54-1.el5.remi set to be updated --> Finished Dependency Resolution Dependencies Resolved ======================================================================================= Package Arch Version Repository Size ======================================================================================= Installing: mysql-devel i386 5.0.77-4.el5_5.4 updates 2.4 M mysql-devel x86_64 5.1.54-1.el5.remi remi 121 k Transaction Summary ======================================================================================= Install 2 Package(s) Upgrade 0 Package(s) Total size: 2.6 M Total download size: 2.4 M Is this ok [y/N]: y Downloading Packages: mysql-devel-5.0.77-4.el5_5.4.i386.rpm | 2.4 MB 00:00 Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing : mysql-devel 1/2 Installing : mysql-devel 2/2 Installed: mysql-devel.i386 0:5.0.77-4.el5_5.4 mysql-devel.x86_64 0:5.1.54-1.el5.remi Complete!
成功です。
おまけ
# yum --enablerepo=remi,epel install php-mysql Loaded plugins: downloadonly Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package php-mysql.x86_64 0:5.3.4-1.el5.remi set to be updated --> Processing Dependency: php-pdo for package: php-mysql --> Running transaction check ---> Package php-pdo.x86_64 0:5.3.4-1.el5.remi set to be updated --> Finished Dependency Resolution Dependencies Resolved ======================================================================================= Package Arch Version Repository Size ======================================================================================= Installing: php-mysql x86_64 5.3.4-1.el5.remi remi 157 k Installing for dependencies: php-pdo x86_64 5.3.4-1.el5.remi remi 116 k Transaction Summary ======================================================================================= Install 2 Package(s) Upgrade 0 Package(s) Total size: 272 k Is this ok [y/N]: y Downloading Packages: Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing : php-pdo 1/2 Installing : php-mysql 2/2 Installed: php-mysql.x86_64 0:5.3.4-1.el5.remi Dependency Installed: php-pdo.x86_64 0:5.3.4-1.el5.remi Complete!
mysql-server
すぐにpython等でMySQLに接続したい場合等は、mysql-serverもいれておきましょう。
# yum --enablerepo=epel,remi install mysql-server Loaded plugins: downloadonly Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package mysql-server.x86_64 0:5.1.54-1.el5.remi set to be updated --> Processing Dependency: perl-DBD-MySQL for package: mysql-server --> Running transaction check ---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: perl-DBD-MySQL --> Processing Dependency: libmysqlclient.so.15()(64bit) for package: perl-DBD-MySQL --> Running transaction check ---> Package mysqlclient15.x86_64 0:5.0.67-1.el5.remi set to be updated --> Finished Dependency Resolution Dependencies Resolved ============================================================================================ Package Arch Version Repository Size ============================================================================================ Installing: mysql-server x86_64 5.1.54-1.el5.remi remi 11 M Installing for dependencies: mysqlclient15 x86_64 5.0.67-1.el5.remi remi 1.3 M perl-DBD-MySQL x86_64 3.0007-2.el5 base 148 k Transaction Summary ============================================================================================ Install 3 Package(s) Upgrade 0 Package(s) Total download size: 12 M Is this ok [y/N]: y Downloading Packages: (1/3): perl-DBD-MySQL-3.0007-2.el5.x86_64.rpm | 148 kB 00:00 (2/3): mysqlclient15-5.0.67-1.el5.remi.x86_64.rpm | 1.3 MB 00:03 (3/3): mysql-server-5.1.54-1.el5.remi.x86_64.rpm | 11 MB 00:08 -------------------------------------------------------------------------------------------- Total 888 kB/s | 12 MB 00:13 Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing : mysqlclient15 1/3 Installing : perl-DBD-MySQL 2/3 Installing : mysql-server 3/3 Installed: mysql-server.x86_64 0:5.1.54-1.el5.remi Dependency Installed: mysqlclient15.x86_64 0:5.0.67-1.el5.remi perl-DBD-MySQL.x86_64 0:3.0007-2.el5 Complete!