file /usr/share/mysql/charsets/README from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts w...

本文介绍了解决在Linux系统上因已安装不同版本MySQL而导致的安装冲突问题的方法。通过检查和移除旧版本的MySQL库文件,确保新的MySQL版本能够成功安装。

1:也许之前的机器安装过Mysql,但是自己不知道,账号密码也忘记了,又执行安装操作,导致Mysql不兼容问题。Linux上安装MySQL时出现不兼容的解决办法,错误如下所示:

 1 [root@master package]# rpm -ivh MySQL-server-5.1.73-1.glibc23.i386.rpm 
 2 Preparing...                ########################################### [100%]
 3     file /usr/share/mysql/charsets/README from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
 4     file /usr/share/mysql/charsets/Index.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
 5     file /usr/share/mysql/charsets/armscii8.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
 6     file /usr/share/mysql/charsets/ascii.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
 7     file /usr/share/mysql/charsets/cp1250.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
 8     file /usr/share/mysql/charsets/cp1251.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
 9     file /usr/share/mysql/charsets/cp1256.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
10     file /usr/share/mysql/charsets/cp1257.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
11     file /usr/share/mysql/charsets/cp850.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
12     file /usr/share/mysql/charsets/cp852.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
13     file /usr/share/mysql/charsets/cp866.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
14     file /usr/share/mysql/charsets/dec8.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
15     file /usr/share/mysql/charsets/geostd8.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
16     file /usr/share/mysql/charsets/greek.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
17     file /usr/share/mysql/charsets/hebrew.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
18     file /usr/share/mysql/charsets/hp8.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
19     file /usr/share/mysql/charsets/keybcs2.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
20     file /usr/share/mysql/charsets/koi8r.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
21     file /usr/share/mysql/charsets/koi8u.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
22     file /usr/share/mysql/charsets/latin1.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
23     file /usr/share/mysql/charsets/latin2.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
24     file /usr/share/mysql/charsets/latin5.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
25     file /usr/share/mysql/charsets/latin7.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
26     file /usr/share/mysql/charsets/macce.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
27     file /usr/share/mysql/charsets/macroman.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
28     file /usr/share/mysql/charsets/swe7.xml from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
29     file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
30     file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
31     file /usr/share/mysql/dutch/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
32     file /usr/share/mysql/english/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
33     file /usr/share/mysql/estonian/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
34     file /usr/share/mysql/french/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
35     file /usr/share/mysql/german/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
36     file /usr/share/mysql/greek/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
37     file /usr/share/mysql/hungarian/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
38     file /usr/share/mysql/italian/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
39     file /usr/share/mysql/japanese/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
40     file /usr/share/mysql/korean/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
41     file /usr/share/mysql/norwegian-ny/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
42     file /usr/share/mysql/norwegian/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
43     file /usr/share/mysql/polish/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
44     file /usr/share/mysql/portuguese/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
45     file /usr/share/mysql/romanian/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
46     file /usr/share/mysql/russian/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
47     file /usr/share/mysql/serbian/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
48     file /usr/share/mysql/slovak/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
49     file /usr/share/mysql/spanish/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
50     file /usr/share/mysql/swedish/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
51     file /usr/share/mysql/ukrainian/errmsg.sys from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686

2:出现问题了,就解决呗,原因是系统已经安装了其他版本的mysql-libs包导致不兼容。

 可以使用命令查看yum list | grep mysql,查看之前安装的mysql的信息,如下所示:

 1 [root@master package]#  yum list | grep mysql
 2 Repository c6-media is listed more than once in the configuration
 3 mysql-libs.i686                             5.1.73-8.el6_8              @base   
 4 apr-util-mysql.i686                         1.3.9-3.el6_0.1             base    
 5 bacula-director-mysql.i686                  5.0.0-13.el6                base    
 6 bacula-storage-mysql.i686                   5.0.0-13.el6                base    
 7 dovecot-mysql.i686                          1:2.0.9-22.el6              base    
 8 freeradius-mysql.i686                       2.2.6-7.el6_9               updates 
 9 libdbi-dbd-mysql.i686                       0.8.3-5.1.el6               base    
10 mod_auth_mysql.i686                         1:3.0.0-11.el6_0.1          base    
11 mysql.i686                                  5.1.73-8.el6_8              base    
12 mysql-bench.i686                            5.1.73-8.el6_8              base    
13 mysql-connector-java.noarch                 1:5.1.17-6.el6              base    
14 mysql-connector-odbc.i686                   5.1.5r1144-7.el6            base    
15 mysql-devel.i686                            5.1.73-8.el6_8              base    
16 mysql-embedded.i686                         5.1.73-8.el6_8              base    
17 mysql-embedded-devel.i686                   5.1.73-8.el6_8              base    
18 mysql-server.i686                           5.1.73-8.el6_8              base    
19 mysql-test.i686                             5.1.73-8.el6_8              base    
20 pcp-pmda-mysql.i686                         3.10.9-9.el6                base    
21 php-mysql.i686                              5.3.3-49.el6                base    
22 qt-mysql.i686                               1:4.6.2-28.el6_5            base    
23 rsyslog-mysql.i686                          5.8.10-10.el6_6             base    
24 rsyslog7-mysql.i686                         7.4.10-7.el6                base   

3:将之前的mysql的lib包删除了即可,删除mysql-libs:

  1 [root@master package]# yum remove mysql-libs
  2 Loaded plugins: fastestmirror, refresh-packagekit, security
  3 Setting up Remove Process
  4 Resolving Dependencies
  5 --> Running transaction check
  6 ---> Package mysql-libs.i686 0:5.1.73-8.el6_8 will be erased
  7 --> Processing Dependency: libmysqlclient.so.16 for package: 2:postfix-2.6.6-8.el6.i686
  8 --> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: 2:postfix-2.6.6-8.el6.i686
  9 --> Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-8.el6.i686
 10 --> Running transaction check
 11 ---> Package postfix.i686 2:2.6.6-8.el6 will be erased
 12 --> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-16.el6_8.2.i686
 13 --> Running transaction check
 14 ---> Package cronie.i686 0:1.4.4-16.el6_8.2 will be erased
 15 --> Processing Dependency: cronie = 1.4.4-16.el6_8.2 for package: cronie-anacron-1.4.4-16.el6_8.2.i686
 16 --> Running transaction check
 17 ---> Package cronie-anacron.i686 0:1.4.4-16.el6_8.2 will be erased
 18 --> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch
 19 --> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-33.el6.i686
 20 --> Restarting Dependency Resolution with new changes.
 21 --> Running transaction check
 22 ---> Package crontabs.noarch 0:1.10-33.el6 will be erased
 23 ---> Package sysstat.i686 0:9.0.4-33.el6 will be erased
 24 --> Finished Dependency Resolution
 25 
 26 Dependencies Resolved
 27 
 28 ===============================================================================================================================================================================================
 29  Package                                  Arch                             Version                                      Repository                                                        Size
 30 ===============================================================================================================================================================================================
 31 Removing:
 32  mysql-libs                               i686                             5.1.73-8.el6_8                               @base                                                            3.9 M
 33 Removing for dependencies:
 34  cronie                                   i686                             1.4.4-16.el6_8.2                             @base                                                            169 k
 35  cronie-anacron                           i686                             1.4.4-16.el6_8.2                             @base                                                             38 k
 36  crontabs                                 noarch                           1.10-33.el6                                  @anaconda-CentOS-201303020136.i386/6.4                           2.4 k
 37  postfix                                  i686                             2:2.6.6-8.el6                                @base                                                            9.4 M
 38  sysstat                                  i686                             9.0.4-33.el6                                 @base                                                            804 k
 39 
 40 Transaction Summary
 41 ===============================================================================================================================================================================================
 42 Remove        6 Package(s)
 43 
 44 Installed size: 14 M
 45 Is this ok [y/N]: y
 46 Downloading Packages:
 47 Running rpm_check_debug
 48 Running Transaction Test
 49 Transaction Test Succeeded
 50 Running Transaction
 51 Repository c6-media is listed more than once in the configuration
 52   Erasing    : sysstat-9.0.4-33.el6.i686                                                                                                                                                   1/6 
 53   Erasing    : cronie-anacron-1.4.4-16.el6_8.2.i686                                                                                                                                        2/6 
 54   Erasing    : crontabs-1.10-33.el6.noarch                                                                                                                                                 3/6 
 55   Erasing    : cronie-1.4.4-16.el6_8.2.i686                                                                                                                                                4/6 
 56   Erasing    : 2:postfix-2.6.6-8.el6.i686                                                                                                                                                  5/6 
 57   Erasing    : mysql-libs-5.1.73-8.el6_8.i686                                                                                                                                              6/6 
 58 warning:    erase unlink of /usr/share/mysql/ukrainian/errmsg.sys failed: No such file or directory
 59 warning:    erase unlink of /usr/share/mysql/ukrainian failed: No such file or directory
 60 warning:    erase unlink of /usr/share/mysql/swedish/errmsg.sys failed: No such file or directory
 61 warning:    erase unlink of /usr/share/mysql/swedish failed: No such file or directory
 62 warning:    erase unlink of /usr/share/mysql/spanish/errmsg.sys failed: No such file or directory
 63 warning:    erase unlink of /usr/share/mysql/spanish failed: No such file or directory
 64 warning:    erase unlink of /usr/share/mysql/slovak/errmsg.sys failed: No such file or directory
 65 warning:    erase unlink of /usr/share/mysql/slovak failed: No such file or directory
 66 warning:    erase unlink of /usr/share/mysql/serbian/errmsg.sys failed: No such file or directory
 67 warning:    erase unlink of /usr/share/mysql/serbian failed: No such file or directory
 68 warning:    erase unlink of /usr/share/mysql/russian/errmsg.sys failed: No such file or directory
 69 warning:    erase unlink of /usr/share/mysql/russian failed: No such file or directory
 70 warning:    erase unlink of /usr/share/mysql/romanian/errmsg.sys failed: No such file or directory
 71 warning:    erase unlink of /usr/share/mysql/romanian failed: No such file or directory
 72 warning:    erase unlink of /usr/share/mysql/portuguese/errmsg.sys failed: No such file or directory
 73 warning:    erase unlink of /usr/share/mysql/portuguese failed: No such file or directory
 74 warning:    erase unlink of /usr/share/mysql/polish/errmsg.sys failed: No such file or directory
 75 warning:    erase unlink of /usr/share/mysql/polish failed: No such file or directory
 76 warning:    erase unlink of /usr/share/mysql/norwegian/errmsg.sys failed: No such file or directory
 77 warning:    erase unlink of /usr/share/mysql/norwegian-ny/errmsg.sys failed: No such file or directory
 78 warning:    erase unlink of /usr/share/mysql/norwegian-ny failed: No such file or directory
 79 warning:    erase unlink of /usr/share/mysql/norwegian failed: No such file or directory
 80 warning:    erase unlink of /usr/share/mysql/korean/errmsg.sys failed: No such file or directory
 81 warning:    erase unlink of /usr/share/mysql/korean failed: No such file or directory
 82 warning:    erase unlink of /usr/share/mysql/japanese/errmsg.sys failed: No such file or directory
 83 warning:    erase unlink of /usr/share/mysql/japanese failed: No such file or directory
 84 warning:    erase unlink of /usr/share/mysql/italian/errmsg.sys failed: No such file or directory
 85 warning:    erase unlink of /usr/share/mysql/italian failed: No such file or directory
 86 warning:    erase unlink of /usr/share/mysql/hungarian/errmsg.sys failed: No such file or directory
 87 warning:    erase unlink of /usr/share/mysql/hungarian failed: No such file or directory
 88 warning:    erase unlink of /usr/share/mysql/greek/errmsg.sys failed: No such file or directory
 89 warning:    erase unlink of /usr/share/mysql/greek failed: No such file or directory
 90 warning:    erase unlink of /usr/share/mysql/german/errmsg.sys failed: No such file or directory
 91 warning:    erase unlink of /usr/share/mysql/german failed: No such file or directory
 92 warning:    erase unlink of /usr/share/mysql/french/errmsg.sys failed: No such file or directory
 93 warning:    erase unlink of /usr/share/mysql/french failed: No such file or directory
 94 warning:    erase unlink of /usr/share/mysql/estonian/errmsg.sys failed: No such file or directory
 95 warning:    erase unlink of /usr/share/mysql/estonian failed: No such file or directory
 96 warning:    erase unlink of /usr/share/mysql/english/errmsg.sys failed: No such file or directory
 97 warning:    erase unlink of /usr/share/mysql/english failed: No such file or directory
 98 warning:    erase unlink of /usr/share/mysql/dutch/errmsg.sys failed: No such file or directory
 99 warning:    erase unlink of /usr/share/mysql/dutch failed: No such file or directory
100 warning:    erase unlink of /usr/share/mysql/danish/errmsg.sys failed: No such file or directory
101 warning:    erase unlink of /usr/share/mysql/danish failed: No such file or directory
102 warning:    erase unlink of /usr/share/mysql/czech/errmsg.sys failed: No such file or directory
103 warning:    erase unlink of /usr/share/mysql/czech failed: No such file or directory
104 warning:    erase unlink of /usr/share/mysql/charsets/swe7.xml failed: No such file or directory
105 warning:    erase unlink of /usr/share/mysql/charsets/macroman.xml failed: No such file or directory
106 warning:    erase unlink of /usr/share/mysql/charsets/macce.xml failed: No such file or directory
107 warning:    erase unlink of /usr/share/mysql/charsets/latin7.xml failed: No such file or directory
108 warning:    erase unlink of /usr/share/mysql/charsets/latin5.xml failed: No such file or directory
109 warning:    erase unlink of /usr/share/mysql/charsets/latin2.xml failed: No such file or directory
110 warning:    erase unlink of /usr/share/mysql/charsets/latin1.xml failed: No such file or directory
111 warning:    erase unlink of /usr/share/mysql/charsets/koi8u.xml failed: No such file or directory
112 warning:    erase unlink of /usr/share/mysql/charsets/koi8r.xml failed: No such file or directory
113 warning:    erase unlink of /usr/share/mysql/charsets/keybcs2.xml failed: No such file or directory
114 warning:    erase unlink of /usr/share/mysql/charsets/hp8.xml failed: No such file or directory
115 warning:    erase unlink of /usr/share/mysql/charsets/hebrew.xml failed: No such file or directory
116 warning:    erase unlink of /usr/share/mysql/charsets/greek.xml failed: No such file or directory
117 warning:    erase unlink of /usr/share/mysql/charsets/geostd8.xml failed: No such file or directory
118 warning:    erase unlink of /usr/share/mysql/charsets/dec8.xml failed: No such file or directory
119 warning:    erase unlink of /usr/share/mysql/charsets/cp866.xml failed: No such file or directory
120 warning:    erase unlink of /usr/share/mysql/charsets/cp852.xml failed: No such file or directory
121 warning:    erase unlink of /usr/share/mysql/charsets/cp850.xml failed: No such file or directory
122 warning:    erase unlink of /usr/share/mysql/charsets/cp1257.xml failed: No such file or directory
123 warning:    erase unlink of /usr/share/mysql/charsets/cp1256.xml failed: No such file or directory
124 warning:    erase unlink of /usr/share/mysql/charsets/cp1251.xml failed: No such file or directory
125 warning:    erase unlink of /usr/share/mysql/charsets/cp1250.xml failed: No such file or directory
126 warning:    erase unlink of /usr/share/mysql/charsets/ascii.xml failed: No such file or directory
127 warning:    erase unlink of /usr/share/mysql/charsets/armscii8.xml failed: No such file or directory
128 warning:    erase unlink of /usr/share/mysql/charsets/README failed: No such file or directory
129 warning:    erase unlink of /usr/share/mysql/charsets/Index.xml failed: No such file or directory
130 warning:    erase unlink of /usr/share/mysql/charsets failed: No such file or directory
131 warning:    erase unlink of /usr/share/mysql failed: No such file or directory
132 warning:    erase unlink of /usr/lib/mysql/libmysqlclient_r.so.16.0.0 failed: No such file or directory
133 warning:    erase unlink of /usr/lib/mysql/libmysqlclient_r.so.16 failed: No such file or directory
134 warning:    erase unlink of /usr/lib/mysql/libmysqlclient.so.16.0.0 failed: No such file or directory
135 warning:    erase unlink of /usr/lib/mysql/libmysqlclient.so.16 failed: No such file or directory
136 warning:    erase unlink of /usr/lib/mysql failed: No such file or directory
137   Verifying  : crontabs-1.10-33.el6.noarch                                                                                                                                                 1/6 
138   Verifying  : sysstat-9.0.4-33.el6.i686                                                                                                                                                   2/6 
139   Verifying  : mysql-libs-5.1.73-8.el6_8.i686                                                                                                                                              3/6 
140   Verifying  : cronie-1.4.4-16.el6_8.2.i686                                                                                                                                                4/6 
141   Verifying  : cronie-anacron-1.4.4-16.el6_8.2.i686                                                                                                                                        5/6 
142   Verifying  : 2:postfix-2.6.6-8.el6.i686                                                                                                                                                  6/6 
143 
144 Removed:
145   mysql-libs.i686 0:5.1.73-8.el6_8                                                                                                                                                             
146 
147 Dependency Removed:
148   cronie.i686 0:1.4.4-16.el6_8.2        cronie-anacron.i686 0:1.4.4-16.el6_8.2        crontabs.noarch 0:1.10-33.el6        postfix.i686 2:2.6.6-8.el6        sysstat.i686 0:9.0.4-33.el6       
149 
150 Complete!
151 [root@master package]# 

4:然后开始安装你的mysql,在linux操作系统上面:http://www.cnblogs.com/biehongli/p/7693598.html

5:以上方法,亲测可以,下面是更暴力卸载的,看着好像方便些,未测:https://www.cnblogs.com/angelasp/p/4301446.html

停更......

2017-12-09 23:43:43

Transaction check error: file /usr/share/mysql/charsets/Index.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/README from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/armscii8.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/ascii.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/cp1250.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/cp1251.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/cp1256.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/cp1257.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/cp850.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/cp852.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/cp866.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/dec8.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/geostd8.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/greek.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/hebrew.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/hp8.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/keybcs2.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/koi8r.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/koi8u.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/latin1.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/latin2.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/latin5.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/latin7.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/macce.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/macroman.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /usr/share/mysql/charsets/swe7.xml from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.18-1.el5.x86_64 file /etc/my.cnf from install of MariaDB-common-10.5.26-1.el7.centos.x86_64 conflicts with file from package mysql-community-server-5.7.18-1.el5.x86_64 错误概要 -------------
最新发布
06-07
<think>我们面临的问题有两个关键点:1.MariaDB-common10.5.26和mysql-community-common5.7.18之间的文件冲突。2.libmysqlclient.so.18依赖缺失。根据引用[3]和[5],文件冲突通常是因为系统中同时存在MariaDB和MySQL的包,而它们提供了相同的文件(例如:/usr/share/mysql/charsets/Index.xml等)。同时,引用[1][2][3]表明postfix等软件包依赖于libmysqlclient.so.18,而这个库通常由mariadb-libs或mysql-community-libs提供。解决方案的核心思路:1.移除导致冲突的包(可能是旧版本的mariadb-libs或mysql-community-libs),然后安装一个统一提供所需依赖的包。2.确保安装的库能够提供libmysqlclient.so.18。由于引用[5]提到在CentOS7上安装MySQL5.7时遇到与mariadb-libs的冲突,并成功解决,我们可以参考类似方法。步骤如下:步骤1:移除现有的冲突包首先,我们需要移除系统中已经存在的mariadb-libs和mysql-community-libs(或相关的冲突包):```bashsudoyumremovemariadb-libsmysql-community-libs```注意:移除mariadb-libs可能会影响postfix等依赖它的软件。因此,我们需要在移除后立即安装一个替代的库来提供所需的依赖。步骤2:安装MySQL官方的共享库根据引用[5],我们可以通过安装mysql-community-common和mysql-community-libs来提供所需的文件。这些包可以从MySQL官方YUM仓库或本地RPM包安装。如果还没有配置MySQL官方YUM仓库,请先配置(参考:https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/)然后安装:```bashsudoyuminstallmysql-community-commonmysql-community-libs```步骤3:验证libmysqlclient.so.18是否存在安装完成后,检查动态库:```bashldconfig-p|greplibmysqlclient.so.18```如果输出中包含libmysqlclient.so.18,则表明已经成功安装。步骤4:重新安装受影响的软件包(如postfix)由于我们移除了mariadb-libs,可能会导致postfix等软件被移除(如引用[3]所示)。现在我们需要重新安装它们:```bashsudoyuminstallpostfix```步骤5:处理RPM数据库警告如果在安装过程中出现类似引用[4]中的警告(Warning:RPMDBalteredoutsideofyum.),我们可以尝试重建RPM数据库:```bashsudorpm--rebuilddb```如果问题仍然存在,可以尝试:```bashsudoyumcleanallsudoyumupdate```步骤6:如果上述步骤失败(例如,安装mysql-community-libs后仍然没有libmysqlclient.so.18),则可以考虑安装MariaDB的共享库由于一些系统软件(如postfix)可能对MariaDB的兼容性更好,我们也可以选择使用MariaDB的库:```bashsudoyumremovemysql-community-libssudoyuminstallmariadb-libs```但要注意,这样可能会再次引起与mysql-community-common的冲突。因此,我们需要确保整个系统统一使用MariaDB或MySQL的库,避免混合安装。总结:优先尝试安装MySQL官方库,如果不行再换用MariaDB的库。同时保持整个数据库客户端库的一致性。以下是一个详细的步骤指南:方案A(推荐使用MySQL官方库):1.移除冲突的包:`sudoyumremovemariadb-libs`2.安装MySQL官方仓库(如果未安装)3.安装mysql-community-libs:`sudoyuminstallmysql-community-libs`4.安装postfix:`sudoyuminstallpostfix`方案B(使用MariaDB库):1.移除mysql-community相关的包:`sudoyumremovemysql-community-commonmysql-community-libs`2.安装mariadb-libs:`sudoyuminstallmariadb-libs`3.确保postfix已安装:`sudoyuminstallpostfix`注意:方案B中,mysql-community-common可能会被自动移除(因为冲突),如果系统中需要同时安装MySQL和MariaDB的库,则可能需要寻找其他方法(如使用容器或虚拟环境)来隔离。由于引用[5]中提到,在移除mariadb-libs后成功安装了MySQL,因此我们优先推荐方案A。但是,请根据实际需求选择。如果方案A在安装mysql-community-libs时提示需要依赖mysql-community-common,则同时安装这两个包:```bashsudoyuminstallmysql-community-commonmysql-community-libs```最后,运行`yumcheck`来验证是否有包依赖问题:```bashsudoyumcheck```如果输出为“没有找到已标记的包”,则表明问题已解决。如果仍有问题,请提供具体的错误信息以进一步分析。相关问题:1.如何配置MySQL的官方YUM仓库?2.在CentOS7中,如何解决多个软件包之间的文件冲突?3.如何检查RPM包的依赖关系?4.在移除mariadb-libs后,如何修复被同时移除的系统包(如postfix)?5.如何确定系统中安装的MySQL或MariaDB的库版本?请根据实际遇到的问题选择具体的方案。</think> ### 解决 MariaDB 和 MySQL 文件冲突及依赖缺失问题 您面临两个核心问题: 1. **文件冲突**:MariaDB-common 10.5.26 与 mysql-community-common 5.7.18 的文件冲突 2. **依赖缺失**:postfix 等软件包缺少 `libmysqlclient.so.18` 以下是逐步解决方案: --- ### 🛠 1. **彻底移除冲突包(关键步骤)** ```bash sudo yum remove mariadb\* mysql-community\* -y sudo rpm -e --nodeps mariadb-libs 2>/dev/null sudo rm -rf /var/lib/mysql sudo rm -rf /usr/lib64/mysql ``` 此操作清除所有冲突包残余,避免后续安装时出现文件重叠[^5]。 --- ### 📦 2. **选择性安装 MySQL 社区版共享库** 安装提供 `libmysqlclient.so.18` 的兼容库: ```bash sudo yum install \ https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm \ mysql-community-libs-compat-5.7 -y ``` 验证安装: ```bash rpm -ql mysql-community-libs-compat-5.7 | grep libmysqlclient.so.18 ldconfig -p | grep libmysqlclient.so.18 # 应返回库路径 ``` --- ### 🔧 3. **解决 RPM 数据库警告** 处理 `Warning: RPMDB altered outside of yum` 错误: ```bash sudo rpm --rebuilddb # 重建 RPM 数据库 sudo yum clean all sudo yum makecache fast ``` --- ### ⚙️ 4. **重新安装所需软件包** ```bash sudo yum reinstall postfix -y sudo yum install perl-DBD-MySQL -y # 解决引用[4]的兼容问题 ``` --- ### ✔️ 5. **最终验证** ```bash yum check # 应无错误 rpm -q postfix # 确认版本 ldd /usr/sbin/postfix | grep libmysqlclient # 检查依赖解析 ``` --- ### 备选方案:统一使用 MariaDB 如果必须保留 MariaDB: ```bash # 步骤1后执行 sudo yum install MariaDB-shared -y # 提供 libmysqlclient.so.18[^3] sudo alternatives --set libmysqlclient.so.18 \ /usr/lib64/mysql/libmysqlclient.so.18.0.0 sudo yum reinstall postfix -y ``` --- ### 关键注意事项 1. **混合安装风险**:MySQL 和 MariaDB 客户端库**不能共存**,必须选择其一[^5] 2. **库文件路径**:`libmysqlclient.so.18` 标准路径: - MySQL:`/usr/lib64/mysql/libmysqlclient.so.18` - MariaDB:`/usr/lib64/libmysqlclient.so.18` 3. **版本兼容**:MySQL 5.7 库兼容 MariaDB 10.2+ 的软件 > 📌 **故障点总结**:错误通常源于同时安装 `mariadb-libs` 和 `mysql-community-libs` 导致文件冲突,解决核心是**彻底清除后统一安装**单一数据库栈。 --- ###
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值