【Linux环境下MySQL 5.7的完整安装与配置指南】
Linux里MySQL的安装
准备工作
关闭防火墙
# 停止firewall systemctl stop firewalld.service # 禁止开机自启 systemctl disable firewalld.service # 查看防火墙状态 systemctl status firewalld.service修改主机名
xshell重新连接生效，图形操作界面重开终端生效
hostnamectl set-hostname mastervim /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 mysqlcd /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 -p123456show 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