1.去mysql官网下载安装包,然后解压
tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar
解压完后会有以下包
mysql-community-embedded-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
mysql-community-devel-5.7.28-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-5.7.28-1.el7.x86_64.rpm
mysql-community-test-5.7.28-1.el7.x86_64.rpm
mysql-community-common-5.7.28-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.28-1.el7.x86_64.rpm
mysql-community-client-5.7.28-1.el7.x86_64.rpm
mysql-community-server-5.7.28-1.el7.x86_64.rpm
2.rpm安装
rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm
3.启动mysql服务
查看mysql服务状态:service mysqld status --启动状态会显示running
启动mysql服务:service mysqld start
4.修改密码
a.通过:grep password /var/log/mysqld.log 可以查看临时密码。
A temporary password is generated for root@localhost:xxxxx
b.登录mysql
mysql -uroot -p
c.修改密码
mysql> set password = password("你的新密码");
5.开启远程连接,root是你的账户,访问root账户密码是123456,就是你设置root的密码。
**以下方式是给任意IP授权,如果是公网机器请考虑安全性**
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
6.防火墙看下时候开通3306端口
======================== 几个坑 ============================
坑一: 安装common时候报很多conflicts with file from package mariadb-libs-1:5.5.60-1.el7_5.x86_64这种依赖错误mariadb-libs,这个时候我们先用 rpm -qa|grep mariadb 查询一下
mariadb-5.5.60-1.el7_5.x86_64
mariadb-devel-5.5.60-1.el7_5.x86_64
mariadb-libs-5.5.60-1.el7_5.x86_64 --我们需要卸载掉这个,防止依赖冲突
卸载mariadb-libs,然后重新安装
rpm -e mariadb-libs-1:5.5.60-1.el7_5.x86_64 --nodeps
坑二: 安装client和server过程中如果报一下错误可以在安装命令结尾加上:–nodeps --force 忽略掉依赖检查
warning: mysql-community-client-5.7.28-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
mariadb is obsoleted by mysql-community-client-5.7.28-1.el7.x86_64
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm --nodeps --force
warning: mysql-community-server-5.7.28-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
file /usr/bin/my_print_defaults from install of mysql-community-server-5.7.28-1.el7.x86_64 conflicts with file from package mariadb-1:5.5.60-1.el7_5.x86_64
file /usr/share/man/man1/my_print_defaults.1.gz from install of mysql-community-server-5.7.28-1.el7.x86_64 conflicts with file from package mariadb-1:5.5.60-1.el7_5.x86_64
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm --force --nodeps
坑三: 在进行密码重设的时候报
Your password does not satisfy the current policy requirements
表示不符合密码强度策略
mysql> set global validate_password_policy=LOW; --设置为LOW只验证密码长度
mysql> set global validate_password_length=6; --密码长度验证设置为6位
mysql> set password = password('123456'); --这样就可以了