【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 TYPEEthernet PROXY_METHODnone BROWSER_ONLYno BOOTPROTOnone/static DEFROUTEyes IPV4_FAILURE_FATALno IPV6INITyes IPV6_AUTOCONFyes IPV6_DEFROUTEyes IPV6_FAILURE_FATALno IPV6_ADDR_GEN_MODEstable-privacy NAMEens33 UUIDb9405edb-2c3b-411a-a638-36c489d43da1 DEVICEens33 ONBOOTyes IPADDR192.168.111.100 NETMASK255.255.255.0 GATEWAY192.168.111.2 DNS1192.168.111.2配置hosts IP与主机名映射关系vim /etc/hosts127.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?spma2c6h.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 wgetwget -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm安装yum Repositoryyum -y install mysql57-community-release-el7-10.noarch.rpm使用yum安装mysql5.7yum -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_policy0; set global validate_password_length1;设置登录密码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-setutf8mb4 [mysqld] character-set-serverutf8mb4 collation-serverutf8mb4_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