MySQL安装与配置

MySQL安装与配置

1、YUM方式安装MySQL

系统资源及组件规划：

节点名称	系统名称	CPU/内存	网卡	磁盘	IP地址	OS
MySQL	mysql	2C/4G	ens33	64G	192.168.0.10	CentOS7

安装基本软件：

yum -y install vim lrzsz wget net-tools bash-completion yum-utils

设置NTP：

yum -y install chrony

systemctl start chronyd
systemctl enable chronyd
systemctl status chronyd

chronyc sources

设置SELinux、防火墙：

systemctl stop firewalld
systemctl disable firewalld
setenforce 0
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config

设置YUM源：

wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

yum -y install mysql80-community-release-el7-3.noarch.rpm

yum repolist enabled | grep "mysql.*-community.*"
yum-config-manager --disable mysql80-community
yum-config-manager --enable mysql57-community
yum repolist enabled | grep "mysql.*-community.*"

安装MySQL：

yum -y install mysql-community-server

启动MySQL，并设置自启动：

systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld

登录MySQL并设置密码：

grep 'temporary password' /var/log/mysqld.log
mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED BY 'PassWord5.7!';

2、二进制方式安装MySQL

系统资源及组件规划：

节点名称	系统名称	CPU/内存	网卡	磁盘	IP地址	OS
MySQL	mysql	2C/4G	ens33	64G	192.168.0.10	CentOS7

安装基本软件：

yum -y install vim lrzsz wget net-tools bash-completion

设置NTP：

yum -y install chrony

systemctl start chronyd
systemctl enable chronyd
systemctl status chronyd

chronyc sources

设置SELinux、防火墙：

systemctl stop firewalld
systemctl disable firewalld
setenforce 0
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config

创建MySQL用户和组：

groupadd mysql
useradd -r -g mysql -s /bin/false mysql

下载并解压缩MySQL安装包：

下载地址：https://downloads.mysql.com/archives/community/

tar -zxf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.31-linux-glibc2.12-x86_64 /usr/local/mysql

设置环境变量：

echo PATH=$PATH:/usr/local/mysql/bin/ >> /etc/profile
source /etc/profile

创建MySQL数据及日志目录：

mkdir /usr/local/mysql/data
mkdir /usr/local/mysql/logs

设置MySQL目录属主、属组及权限：

chown -R mysql:mysql /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql/data
chown -R mysql:mysql /usr/local/mysql/logs

修改MySQL配置文件：

cat > /etc/my.cnf << EOF
[mysqld]
user=mysql
symbolic-links=0
socket=/tmp/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
pid-file=/usr/local/mysql/mysqld.pid
log-error=/usr/local/mysql/logs/mysqld.log
EOF

初始化MySQL：

mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

配置systemd管理MySQL：

cat > /usr/lib/systemd/system/mysqld.service << EOF

[Unit]
Description=MySQL Server
Documentation=man:mysqld
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=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
EOF

启动MySQL，并设置自启动：

systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld

登录MySQL并设置密码：

grep 'temporary password' /usr/local/mysql/logs/mysqld.log
mysql -u root -p

ALTER USER 'root'@'localhost' IDENTIFIED BY 'PassWord5.7!';