centos7 64 bit安装mysql8。
下载
官方下载地址：https://dev.mysql.com/downloads/file/?id=487211
文件名：mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar
解压后文件列表：
1
2
3
4
5
6
7
8
| mysql-community-client-8.0.16-2.el7.x86_64.rpm
mysql-community-common-8.0.16-2.el7.x86_64.rpm
mysql-community-devel-8.0.16-2.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.16-2.el7.x86_64.rpm
mysql-community-libs-8.0.16-2.el7.x86_64.rpm
mysql-community-libs-compat-8.0.16-2.el7.x86_64.rpm
mysql-community-server-8.0.16-2.el7.x86_64.rpm
mysql-community-test-8.0.16-2.el7.x86_64.rpm
|
安装
依次安装：
1
2
3
4
| rpm -ivh mysql-community-common-8.0.16-2.el7.x86_64.rpm
rpm -ivh mysql-community-libs-*
rpm -ivh mysql-community-client-8.0.16-2.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.16-2.el7.x86_64.rpm
|
启动或停止服务：
1
2
| service mysqld start
service mysqld stop
|
默认会创建2个目录：/var/lib/mysql/、/var/lib/mysql-files/，如不存在，可手动创建。
配置文件：/etc/my.cnf。
修改初始密码：
grep ‘temporary password’ /var/log/mysqld.log
数据库使用记录：
本地默认连接：
mysql -uroot -p123456
指定IP和端口：
mysql -uroot -pTest..123 -h222.84.250.173 -P3306
卸载
搜索安装的软件包：
1
2
3
4
5
6
| # rpm -qa | grep mysql
mysql-community-common-8.0.16-2.el7.x86_64
mysql-community-libs-compat-8.0.16-2.el7.x86_64
mysql-community-server-8.0.16-2.el7.x86_64
mysql-community-libs-8.0.16-2.el7.x86_64
mysql-community-client-8.0.16-2.el7.x86_64
|
卸载：
1
2
3
4
5
| yum remove mysql-community-common-8.0.16-2.el7.x86_64 \
mysql-community-libs-compat-8.0.16-2.el7.x86_64 \
mysql-community-server-8.0.16-2.el7.x86_64 \
mysql-community-libs-8.0.16-2.el7.x86_64 \
mysql-community-client-8.0.16-2.el7.x86_64
|
问题及解决
问题1
提示：
1
2
3
4
5
| # rpm -ivh mysql-community-libs-compat-8.0.16-2.el7.x86_64.rpm
警告：mysql-community-libs-compat-8.0.16-2.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
错误：依赖检测失败：
mysql-community-libs(x86-64) >= 8.0.11 被 mysql-community-libs-compat-8.0.16-2.el7.x86_64 需要
mariadb-libs 被 mysql-community-libs-compat-8.0.16-2.el7.x86_64 取代
|
原因：mysql与MariaDB冲突。
解决：删除之，yum -y remove mariadb-libs.x86_64
问题2
提示：
1
2
3
4
5
6
7
| rpm -ivh mysql-community-server-8.0.16-2.el7.x86_64.rpm
警告：mysql-community-server-8.0.16-2.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
错误：依赖检测失败：
/usr/bin/perl 被 mysql-community-server-8.0.16-2.el7.x86_64 需要
net-tools 被 mysql-community-server-8.0.16-2.el7.x86_64 需要
perl(Getopt::Long) 被 mysql-community-server-8.0.16-2.el7.x86_64 需要
perl(strict) 被 mysql-community-server-8.0.16-2.el7.x86_64 需要
|
原因：未安装依赖库。
解决：安装之。
1
2
| yum install perl
yum install net-tools
|
