Linux平台(CentOS 6.5) RPM包方式安装 Mysql 5.7

柔情只为你懂 2024-04-17 23:51 31阅读 0赞

在 Mysql 官网下载 RPM 的 bundle 包并解压。  
  
\[root@localhost mysql5.7\]\# tar xvf mysql-5.7.12-1.el6.x86\_64.rpm-bundle.tar

单独安装 Server 包，报依赖关系的错误。  
  
\[root@T400-kelong software\]\# rpm -ivh mysql-community-server-5.7.10-1.el6.x86\_64.rpm   
warning: mysql-community-server-5.7.10-1.el6.x86\_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY  
**error: Failed dependencies:**  
mysql-community-client(x86-64) = 5.7.10-1.el6 is needed by mysql-community-server-5.7.10-1.el6.x86\_64  
mysql-community-common(x86-64) = 5.7.10-1.el6 is needed by mysql-community-server-5.7.10-1.el6.x86\_64  
  
将所需的包添加上，依然报错，缺少另外一个包。  
  
\[root@T400-kelong software\]\# rpm -ivh mysql-community-server-5.7.10-1.el6.x86\_64.rpm mysql-community-common-5.7.10-1.el6.x86\_64.rpm mysql-community-client-5.7.10-1.el6.x86\_64.rpm   
warning: mysql-community-server-5.7.10-1.el6.x86\_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY  
**error: Failed dependencies:**  
mysql-community-libs(x86-64) = 5.7.10-1.el6 is needed by mysql-community-client-5.7.10-1.el6.x86\_64

将所需的包添加上，继续报错，和系统自带的 5.1 版本冲突。  
  
\[root@T400-kelong software\]\# rpm -ivh mysql-community-server-5.7.10-1.el6.x86\_64.rpm mysql-community-common-5.7.10-1.el6.x86\_64.rpm mysql-community-client-5.7.10-1.el6.x86\_64.rpm mysql-community-libs-5.7.10-1.el6.x86\_64.rpm   
warning: mysql-community-server-5.7.10-1.el6.x86\_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY  
Preparing...                \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
**file /usr/share/mysql/czech/errmsg.sys from install of mysql-community-common-5.7.10-1.el6.x86\_64 conflicts with file from package mysql-libs-5.1.73-5.el6\_6.x86\_64**  
file /usr/share/mysql/danish/errmsg.sys from install of mysql-community-common-5.7.10-1.el6.x86\_64 conflicts with file from package mysql-libs-5.1.73-5.el6\_6.x86\_64

卸载掉报错的mysql 5.1安装包  
  
\[root@T400-kelong software\]\# yum remove mysql-libs-5.1.73-5.el6\_6.x86\_64  
Loaded plugins: fastestmirror, refresh-packagekit, security  
Setting up Remove Process  
Resolving Dependencies  
There are unfinished transactions remaining. You might consider running yum-complete-transaction first to finish them.  
\--> Running transaction check  
\---> Package mysql-libs.x86\_64 0:5.1.73-5.el6\_6 will be erased  
\--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86\_64  
\--> Processing Dependency: libmysqlclient.so.16(libmysqlclient\_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86\_64  
\--> Running transaction check  
\---> Package perl-DBD-MySQL.x86\_64 0:4.013-3.el6 will be erased  
\--> Finished Dependency Resolution  
  
Dependencies Resolved  
  
=============================================================================================================================================================  
 Package                                  Arch                             Version                                     Repository                       Size  
=============================================================================================================================================================  
Removing:  
 mysql-libs                               x86\_64                           5.1.73-5.el6\_6                              @base                           4.0 M  
Removing for dependencies:  
 perl-DBD-MySQL                           x86\_64                           4.013-3.el6                                 @base                           338 k  
  
Transaction Summary  
=============================================================================================================================================================  
Remove        2 Package(s)  
  
Installed size: 4.4 M  
Is this ok \[y/N\]: y

**安装 RPM 包**  
  
\[root@T400-kelong software\]\# rpm -ivh mysql-community-server-5.7.10-1.el6.x86\_64.rpm mysql-community-common-5.7.10-1.el6.x86\_64.rpm mysql-community-client-5.7.10-1.el6.x86\_64.rpm mysql-community-libs-5.7.10-1.el6.x86\_64.rpm   
warning: mysql-community-server-5.7.10-1.el6.x86\_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY  
Preparing...                \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]  
   1:mysql-community-common \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[ 25%\]  
   2:mysql-community-libs   \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[ 50%\]  
   3:mysql-community-client \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[ 75%\]  
   4:mysql-community-server \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]

**启动数据库。**  
  
\[root@T400-kelong sbin\]\# service mysqld start  
初始化 MySQL 数据库：                                      \[确定\]  
正在启动 mysqld：                                          \[确定\]  
\[root@T400-kelong sbin\]\# service mysqld status  
mysqld (pid  4782) 正在运行...

\[root@T400-kelong sbin\]\# ps -ef|grep mysql  
root      4586     1  0 21:11 pts/1    00:00:00 /bin/sh /usr/bin/mysqld\_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql  
mysql     4782  4586  2 21:11 pts/1    00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock  
root      4847  3857  0 21:11 pts/1    00:00:00 grep mysql

**使用临时密码登录到 ROOT 用户** **，更改 ROOT 密码。**  
  
grep 'temporary password' /var/log/mysql/mysqld.log  
  
\[root@T400-kelong sbin\]\# mysql -uroot -p  
Enter password:   
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 4  
Server version: 5.7.10  
  
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.  
  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
  
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.

mysql> **alter user 'root'@'localhost' identified by 'System\#2013';**  
Query OK, 0 rows affected (0.00 sec)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-1994769/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-1994769/