linux 安装mysql 80版本

133 阅读1分钟

一、安装

1.下载mysql源

wget dev.mysql.com/get/mysql80…

2.修改镜像文件 将镜像修改成aliyun的镜像

cd /etc/yum.repos.d 到这个目录下

vim CentOS-Base.repo 修改这个目录

[base] name=CentOS-releaseverBasemirrors.aliyun.combaseurl=http://mirrors.aliyun.com/centos/releasever - Base - mirrors.aliyun.com baseurl=http://mirrors.aliyun.com/centos/releasever/os/$basearch/ gpgcheck=1 gpgkey=mirrors.aliyun.com/centos/RPM-…

[updates] name=CentOS-releaseverUpdatesmirrors.aliyun.combaseurl=http://mirrors.aliyun.com/centos/releasever - Updates - mirrors.aliyun.com baseurl=http://mirrors.aliyun.com/centos/releasever/updates/$basearch/ gpgcheck=1 gpgkey=mirrors.aliyun.com/centos/RPM-…

[extras] name=CentOS-releaseverExtrasmirrors.aliyun.combaseurl=http://mirrors.aliyun.com/centos/releasever - Extras - mirrors.aliyun.com baseurl=http://mirrors.aliyun.com/centos/releasever/extras/$basearch/ gpgcheck=1 gpgkey=mirrors.aliyun.com/centos/RPM-…

[centosplus] name=CentOS-releaseverPlusmirrors.aliyun.combaseurl=http://mirrors.aliyun.com/centos/releasever - Plus - mirrors.aliyun.com baseurl=http://mirrors.aliyun.com/centos/releasever/centosplus/$basearch/ gpgcheck=1 enabled=0 gpgkey=mirrors.aliyun.com/centos/RPM-…

3.安装mysql源

yum localinstall -y mysql80-community-release-el7-4.noarch.rpm

4.查看安装效果

yum repolist enabled | grep mysql.*

image.png 字节数,不为0即成功

5.安装mysql服务器

yum install mysql-community-server  --nogpgcheck 跳过密匙验证

6.启动mysql服务

systemctl start mysqld.service

7.查看mysql运行服务

image.png 如图active表示成功启动

8.查看自己的初始密码 grep "password" /var/log/mysqld.log(刚开始的密码不是123456!!!!) 9.用初始密码登录,并修改自己的密码

登录 : mysql -uroot -p 修改密码: ALTER USER 'root'@'localhost' IDENTIFIED BY '!Think123456';

10.如果要设置简单的密码,先重置自己的密码,然后在运行下面的代码,再重新修改密码

set global validate_password.policy=LOW;

set global validate_password.length=4;

set global validate_password.mixed_case_count=0;

set global validate_password.number_count=0;

set global validate_password.special_char_count=0;

二、让本机连接上centors的数据库

1.开启3306端口外网访问权利

firewall-cmd --permanent --add-port=3306/tcp

2.刷新防火墙

firewall-cmd --reload

3.创建的用户必须要有访问的访问的权限

例如:create user 'user01' @'%' identified by 'user01';