Linux里MySQL的安装

准备工作

关闭防火墙

# 停止firewall systemctl stop firewalld.service # 禁止开机自启 systemctl disable firewalld.service # 查看防火墙状态 systemctl status firewalld.service

修改主机名

xshell重新连接生效，图形操作界面重开终端生效

hostnamectl set-hostname master

vim /etc/hosts

# 修改最后一行内容 添加主机映射 192.168.111.100 master

配置静态IP

# 看看就好 # 停止NetworkManager服务 systemctl stop NetworkManager # 禁止开机自启 systemctl disable NetworkManager # 修改配置文件，配置静态ip (修改为自己的网络段) cd /etc/sysconfig/network-scripts vim ifcfg-ens33 TYPE=Ethernet PROXY_METHOD=none BROWSER_ONLY=no BOOTPROTO=none/static DEFROUTE=yes IPV4_FAILURE_FATAL=no IPV6INIT=yes IPV6_AUTOCONF=yes IPV6_DEFROUTE=yes IPV6_FAILURE_FATAL=no IPV6_ADDR_GEN_MODE=stable-privacy NAME=ens33 UUID=b9405edb-2c3b-411a-a638-36c489d43da1 DEVICE=ens33 ONBOOT=yes IPADDR=192.168.111.100 NETMASK=255.255.255.0 GATEWAY=192.168.111.2 DNS1=192.168.111.2

配置hosts IP与主机名映射关系

vim /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 master ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 master 192.168.111.100 master

配置windows下ip与主机名映射关系

C:\Windows\System32\drivers\etc

使用vscode打开host文件添加保存

192.168.111.100 master

配置第三方库

换源

参考https://developer.aliyun.com/mirror/centos?spm=a2c6h.13651102.0.0.3e221b115Ci1Y6

备份原有的源配置文件

mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup

从阿里官方网站下载对应系统版本的源配置文件

wget -O /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo

* 由于我们是非ECS用户，所以源配置文件中包含aliyuncs.com地址访问不了

* 故对其进行移除

sed -i -e '/mirrors.cloud.aliyuncs.com/d' -e '/mirrors.aliyuncs.com/d' /etc/yum.repos.d/CentOS-Base.repo

重新构建本地缓存

yum makecache

安装MySQL5.7

下载yum Repository

如果没有wget命令.使用yum install wget

wget -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

安装yum Repository

yum -y install mysql57-community-release-el7-10.noarch.rpm

使用yum安装mysql5.7

yum -y --nogpgcheck install mysql-community-server

查看安装的服务和库

x cd /usr/lib/systemd/systemll | grep mysql

cd /etc/yum.repos.d ll

卸载yum Repository

# 安装了yum Repository后,每次执行yum操作都会更新一遍,会导致运行的慢,用完之后删了 yum -y remove mysql57-community-release-el7-10.noarch

启动并配置MySQL

启动MySQL

# 查看服务状态 systemctl status mysqld/mysqld.service # 启动服务 systemctl start mysqld/mysqld.service # 开机自启 systemctl enable mysqld/mysqld.service

获取临时密码

grep "password" /var/log/mysqld.log

登录MySQL

# XXX为复制的密码,不要手敲临时密码,使用复制的单行的密码 mysql -uroot -pXXX

关闭密码复杂验证

mysql命令行中执行

set global validate_password_policy=0; set global validate_password_length=1;

设置登录密码

alter user user() identified by "123456";

开放root用户远程登录

# 切换至mysql数据库 use mysql; # 修改权限 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; # 刷新权限 flush privileges; # 退出 exit; / quit;

修改MySQL编码

查看数据库默认编码

show variables like "%char%";

编辑配置文件： vim /etc/my.cnf

[client] default-character-set=utf8mb4 [mysqld] character-set-server=utf8mb4 collation-server=utf8mb4_general_ci

重启MySQL服务

systemctl restart mysqld

登录并查看MySQL编码

mysql -uroot -p123456

show variables like "%char%";

卸载MySQL

删除依赖包

# 查找mysql相关安装包 rpm -qa | grep -i mysql # 对mysql相关的包进行删除 yum remove mysql-community mysql-community-server mysql-community-libs mysql-community-common

清理文件

find / -name mysql rm -rf filename