概述

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

安装环境
部署ip部署软件开放端口
192.168.199.10mysql8.03306

安装部署

依赖环境安装
yum install -y cmake make gcc gcc-c++ wget ncurses-devel cmake make perl ncurses-devel openssl-devel bison-devel libaio libaio-devel lrzsz
mysql安装
# 创建mysql用户
userdel mysql
useradd -M -s /sbin/nologin  mysql
# 查询是否有mariadb
rpm -qa | grep mariadb
# 卸载mariadb相关软件
rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps
# 安装mysql
mkdir -pv  /data/mysql8.0/{temp,logs,data}
tar zxf mysql-8.0.22-el7-x86_64.tar.gz
mv mysql-8.0.22-el7-x86_64 /data/mysql8.0
chown -R mysql:mysql /data/mysql8.0/
# 设置环境变量
echo 'export  PATH=/data/mysql8.0/bin:$PATH' >> /etc/profile
# 切换到普通用户
echo 'export  PATH=/data/mysql8.0/bin:$PATH' >> ~/.bashrc
# root用户
echo 'export  PATH=/data/mysql8.0/bin:$PATH' >> ~/.bashrc
source /etc/profile
基础配置
vim /etc/my.cnf

[mysqld]
port=3306
basedir=/data/mysql8.0
datadir=/data/mysql8.0/data
log-error=/data/mysql8.0/logs/mysql.log
socket=/tmp/mysql.sock
event_scheduler=ON
slow_query_log = ON
slow_query_log_file = /data/mysql8.0/logs/mysql-slow.log
long_query_time = 1
innodb_buffer_pool_size = 6G
default-authentication-plugin=mysql_native_password
server-id=10
log-bin=/data/mysql8.0/logs/mysql-bin
max_connect_errors=1000
log-error=/data/mysql8.0/logs/mysql.log
pid-file=/data/mysql8.0/data/mysql.pid

[client]
#设置客户端编码
default-character-set=utf8

# mysql初始化
mysqld --initialize --user=mysql --basedir=/data/mysql8.0 --datadir=/data/mysql8.0/data/
# mysql初始化后密码查看
cat /data/mysql8.0/logs/mysql.log | grep password
A2UYhWak*Blk
配置启动脚本
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
ExecStart=/data/mysql8.0/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 65536
LimitNPROC = 65536
开机自启设置
# 加入开机启动
systemctl daemon-reload
systemctl enable mysqld
# 查看开机是否启动成功
systemctl is-enabled mysqld
# 启动服务
systemctl start mysqld
# 停止服务
systemctl stop mysqld
防火墙开放端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
setenforce 0
mysql密码修改及权限配置
# 修改root密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test@2021';
# 给root远程访问权限
update mysql.user set host='%' where user='root';
# 刷新权限
flush privileges;
# 创建普通用户并授权
create user 'test'@'localhost' identified by 'test@2021';
create user 'test'@'%' identified by 'test@2021';
grant all privileges on test01.* to 'test'@'%' with grant option;
grant all privileges on test01.* to 'test'@'localhost' with grant option;
# 刷新权限
flush privileges;
END

本文标题:Mysql8.0源码安装和基础配置

本文作者:王某人

本文链接:https://www.ym68.cc/mysql/202109216.html

版权声明:转载或者引用本文内容请注明来源及原作者,本文著作权归作者 (王某人) 所有。

除非另有说明,本作品采用知识共享署名-非商业性使用-相同方式共享 4.0 国际许可协议

最后修改:2021 年 10 月 09 日
如果觉得我的文章对你有用,请随意赞赏