admin管理员组文章数量:1609966
centos7 RPM方式安装MySQL5.7
1、下载Linux对应的RPM包,CentOS7对应的RPM包,如下:[root@node04 soft]# unzip mysql-5.7-centos7.zip
Archive: mysql-5.7-centos7.zip
extracting: mysql-commercial-client-5.7.16-1.1.el7.x86_64.rpm
extracting: mysql-commercial-embedded-5.7.16-1.1.el7.x86_64.rpm
extracting: mysql-commercial-common-5.7.16-1.1.el7.x86_64.rpm
extracting: mysql-commercial-libs-compat-5.7.16-1.1.el7.x86_64.rpm
extracting: mysql-commercial-embedded-compat-5.7.16-1.1.el7.x86_64.rpm
extracting: mysql-commercial-devel-5.7.16-1.1.el7.x86_64.rpm
extracting: mysql-commercial-server-5.7.16-1.1.el7.x86_64.rpm
extracting: mysql-commercial-test-5.7.16-1.1.el7.x86_64.rpm
extracting: mysql-commercial-embedded-devel-5.7.16-1.1.el7.x86_64.rpm
extracting: mysql-commercial-libs-5.7.16-1.1.el7.x86_64.rpm
extracting: README.txt
2、检查MySQL及相关RPM包,是否安装,如果有安装,则移除(rpm –e 名称)[root@node04 soft]#rpm -qa | grep -i mariadb-*
[root@node04 soft]# rpm -e mariadb-libs
否则有可能报错:
[root@node04 soft]# rpm -ivh mysql-commercial-libs-5.7.16-1.1.el7.x86_64.rpm
warning: mysql-commercial-libs-5.7.16-1.1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
mysql-commercial-common(x86-64) >= 5.7.9 is needed by mysql-commercial-libs-5.7.16-1.1.el7.x86_64
mariadb-libs is obsoleted by mysql-commercial-libs-5.7.16-1.1.el7.x86_64
3、安装MySQL,安装有顺序[root@node04 soft]# rpm -ivh mysql-commercial-common-5.7.16-1.1.el7.x86_64.rpm
warning: mysql-commercial-common-5.7.16-1.1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-commercial-common-5.7.16-1.################################# [100%]
[root@node04 soft]# rpm -ivh --force mysql-commercial-libs-5.7.16-1.1.el7.x86_64.rpm
warning: mysql-commercial-libs-5.7.16-1.1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-commercial-libs-5.7.16-1.1.################################# [100%]
[root@node04 soft]# rpm -ivh mysql-commercial-client-5.7.16-1.1.el7.x86_64.rpm
warning: mysql-commercial-client-5.7.16-1.1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-commercial-client-5.7.16-1.################################# [100%]
测试预安装提示如下:
[root@node04 soft]# rpm -ivh --test mysql-commercial-server-5.7.16-1.1.el7.x86_64.rpm
warning: mysql-commercial-server-5.7.16-1.1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
net-tools is needed by mysql-commercial-server-5.7.16-1.1.el7.x86_64
注:需要依赖net-tools组件
[root@node04 soft]# yum install net-tools
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos.ustc.edu
* epel: mirror01.idc.hinet
* extras: centos.ustc.edu
* updates: centos.ustc.edu
Resolving Dependencies
--> Running transaction check
---> Package net-tools.x86_64 0:2.0-0.17.20131004git.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
==============================================================================================================================
Package Arch Version Repository Size
==============================================================================================================================
Installing:
net-tools x86_64 2.0-0.17.20131004git.el7 base 304 k
Transaction Summary
==============================================================================================================================
Install 1 Package
Total download size: 304 k
Installed size: 917 k
Is this ok [y/d/N]: y
Downloading packages:
net-tools-2.0-0.17.20131004git.el7.x86_64.rpm | 304 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows:
2:postfix-2.10.1-6.el7.x86_64 has missing requires of libmysqlclient.so.18()(64bit)
2:postfix-2.10.1-6.el7.x86_64 has missing requires of libmysqlclient.so.18(libmysqlclient_18)(64bit)
Installing : net-tools-2.0-0.17.20131004git.el7.x86_64 1/1
Verifying : net-tools-2.0-0.17.20131004git.el7.x86_64 1/1
Installed:
net-tools.x86_64 0:2.0-0.17.20131004git.el7
Complete!
[root@node04 soft]# rpm -ivh --test mysql-commercial-server-5.7.16-1.1.el7.x86_64.rpm
warning: mysql-commercial-server-5.7.16-1.1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
[root@node04 soft]# rpm -ivh mysql-commercial-server-5.7.16-1.1.el7.x86_64.rpm
warning: mysql-commercial-server-5.7.16-1.1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-commercial-server-5.7.16-1.################################# [100%]
4、备份myf,重新初始化数据库,注意mysql5.7版本初始化会随机生成一个root登录的随机密码[root@node04 sbin]#cp /etc/myf /etc/myf.bak
[root@node04 sbin]# /usr/sbin/mysqld --initialize --user=mysql --basedir=/data --datadir=/data
2016-11-18T05:49:59.052988Z 1 [Note] A temporary password is generated for root@localhost: T=_GTj2Wroxm (root本地登录随机密码)
5、启动服务,修改root密码[root@node04 sbin]# systemctl start mysqld.service
mysql> alter user 'root'@'localhost' identified by '12345678';
Query OK, 0 rows affected (0.00 sec)
6、安装后目录位置和内容
MySQL安装后涉及的目录如下:
目录目录中的内容
/usr/bin客户端程序和脚本
/usr/sbinMysqld服务器
/var/lib/mysql数据库的日志文件
/usr/share/info信息格式手册
/usr/share/manUnix 手册页
/usr/include/mysql包括 (标题) 的文件
/usr/lib/mysqlmysql的lib包
/usr/share/mysql杂项的支持文件,包括错误消息) 字符设置的文件,示例配置文件,SQL 数据库安装
/usr/share/sql-bench基准
默认字符集为:utf8_general_cimysql> show variables like '%collation%';
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | utf8_general_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.01 sec)
版权声明:本文标题:rpm 安装mysql的顺序_centos7 RPM方式安装MySQL5.7 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://www.elefans.com/dongtai/1728587327a1165043.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论