Mysql5.7安装和基础配置

Mysql安装和基础配置

1. mysql官网

   https://downloads.mysql.com/archives/community/

2. 安装环境

   部署ip	部署软件	开放端口
   192.168.199.10	mysql-5.7.26	3306

3. 依赖环境安装

   yum install -y cmake make gcc gcc-c++ wget ncurses-devel cmake make perl ncurses-devel openssl-devel bison-devel libaio libaio-devel lrzsz

4. mysql安装

   tar -zxf mysql-5.7.26-linux-glibc2.12-x86_6ndad4.tar.gz
   mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql5.7
   echo 'export  PATH=/usr/local/mysql5.7/bin:$PATH' >> /etc/profile
   source /etc/profile
   # 切换到普通用户
   echo 'export  PATH=/usr/local/mysql5.7/bin:$PATH' >> ~/.bashrc
   # root用户
   echo 'export  PATH=/usr/local/mysql5.7/bin:$PATH' >> ~/.bashrc
   userdel mysql
   useradd -M -s /sbin/nologin  mysql
   mkdir -pv  /data/{temp,log,data}
   chown -R mysql:mysql /data
   # 初始化数据库，并对目录进行重新授权，如果系统已经存在/etc/my.cnf文件，此步会执行失败，需要将此文件暂时移除后再进行初始化，初始化中的错误不用理会。
   mysqld --initialize-insecure --datadir=/data/data --user=mysql
   chown -R mysql:mysql /data
   完成以上初始化后，检查/datadir/data/目录，是否生成数据库的相关必备的数据库，包括mysql、performance_schema、sys
   

5. 基础配置

   vim /etc/my.cnf
   
   [mysqld]
   basedir=/usr/local/mysql5.7
   user=mysql
   port=3306
   datadir=/data/data
   log-error=/data/log/err.log
   pid-file=/data/temp/mysqld.pid
   socket=/data/temp/mysqld.sock
   symbolic-links=0
   [client]
   socket=/data/temp/mysqld.sock
   default-character-set=utf8
   

6. 配置启动脚本

   vim /usr/lib/systemd/system/mysqld.service
   
   [Unit]
   Description=MySQL Server
   Documentation=man:mysqld(8)
   Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
   After=network.target
   After=syslog.target
   [Install]
   WantedBy=multi-user.target
   [Service]
   User=mysql
   Group=mysql
   Type=forking
   #按实际修改
   PIDFile=/data/temp/mysqld.pid
   
   chmod 644 /usr/lib/systemd/system/mysqld.service
   

7. 开机自启动设置

   # 加入开机启动
   systemctl daemon-reload
   systemctl enable mysqld
   # 查看开机是否启动成功
   systemctl is-enabled mysqld
   # 启动服务
   systemctl start mysqld
   # 停止服务
   systemctl stop mysqld
   

8. 防火墙开放端口

   firewall-cmd --zone=public --add-port=3306/tcp --permanent
   firewall-cmd --reload
   setenforce 0
   

9. mysql密码修改及权限配置

   # 创建普通用户并授权
   	create user 'test'@'%' identified by 'test@2021';
   	create user 'test'@'localhost' identified by 'test@2021';
   	grant all on test.* to test@'%' identified by 'test@2021';
   	grant all on test.* to test@'localhost' identified by 'test@2021';
   	flush privileges;
   # root用户授权
   	grant all on *.* to root@'%' identified by '123456';
   	grant all on *.* to root@'localhost' identified by '123456';
   	flush privileges;