安装MySQL - MySQL

#安装
>##方式一：YUM源安装
>####可参考：[官方教程](https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/#repo-qg-yum-fresh-install "官方教程")
---
>####1.下载并安装MySQL官方的 Yum Repository
	wget http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
	rpm -Uvh mysql57-community-release-el7-10.noarch.rpm
	#安装密钥
	rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
	
>####2.安装mysql
	yum -y install mysql-community-server
>####3.启动mysql并设置开机自启动
	systemctl start mysqld.service
	systemctl enable mysqld.service
>####4.查看初始密码
	grep 'temporary password' /var/log/mysqld.log
>####5.进入mysql,并修改初始密码
	mysql -uroot -p
	set global validate_password_policy=0;  #修改安全等级，如果密码不通过复杂度检测的话
	ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';

---
>##方式二：二进制包安装
>####1.下载二进制包
	wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz
>####2.解压并迁移
	tar -zxvf mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz
	mv mysql-5.7.29-linux-glibc2.12-x86_64 /usr/local/mysql
>####3.增加用户和用户组
	groupadd mysql
	useradd -r -g mysql mysql
>####4.创建相关目录
	mkdir -p /data/mysql/mysql_3306
	mkdir -p /data/mysql/mysql_3306/{data,log,tmp}
>####5.更改目录权限
	chown -R mysql:mysql /data/mysql
	chown -R mysql:mysql /usr/local/mysql
>####6.添加环境变量
	echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
	source /etc/profile
>####7.配置my.cnf
>####[my.cnf下载网址](http://nginx.frp.bao-server.club:22080/KODExplorer/index.php?share/fileDownload&user=100&sid=QvxqmzZc "my.cnf下载网址")
	vim /etc/my.cnf 			#配置相关信息
>####8.初始化数据库
	/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/mysql_3306/data
	#注意：记住初始化的root密码
>####9.开启启动
	cp mysql.server /etc/init.d/mysql
	vim /etc/init.d/mysql 
	#修改basedir = '' 修改datadir = '',修改成对应路径
	chkconfig --add mysql
	chkconfig --list
	#手动启动方法
	/etc/init.d/mysql start
	
>####10.启动mysql并设置开机自启动
	/etc/init.d/mysql start
	/etc/init.d/mysql status
	service mysql start
	
>####11.查看初始密码
	grep 'temporary password' /var/log/mysqld.log
>####12.进入mysql,并修改初始密码
	mysql -uroot -p
	set global validate_password_policy=0;  #修改安全等级，如果密码不通过复杂度检测的话
	ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';

#多实例安装
>####1.下载二进制包
	wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz
>####2.解压并迁移
	tar -zxvf mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz
	mv mysql-5.7.29-linux-glibc2.12-x86_64 /usr/local/mysql
>####3.增加用户和用户组
	groupadd mysql
	useradd -r -g mysql mysql
>####4.创建相关目录
	mkdir -p /data/mysql/{mysql_3306，mysql_3307}
	mkdir -p /data/mysql/mysql_3306/{data，log，tmp}
	mkdir -p /data/mysql/mysql_3307/{data，log，tmp}
>####5.更改目录权限
	chown -R mysql:mysql /data/mysql
	chown -R mysql:mysql /usr/local/mysql
>####6.添加环境变量
	echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
	source /etc/profile
>####7.配置my.cnf
>####[单实例my.cnf下载网址](http://nginx.frp.bao-server.club:22080/KODExplorer/index.php?share/file&user=100&sid=FsMiUGgv "单实例my.cnf下载网址")
>####[多实例my.cnf下载网址](http://nginx.frp.bao-server.club:22080/KODExplorer/index.php?share/file&user=100&sid=zEdXmS2h "多实例my.cnf下载网址")
	vim /etc/my.cnf 			#配置相关信息
>####8.初始化数据库
	/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql --datadir/data/mysql/mysql_3306/data
	#其余实例初始化如上类似，只需修改3306
>####9.查看、启动、停止
>####查看
	/usr/local/mysql/support-files/mysqld_multi.server report 3306			#如查一个，后加实例号
>####启动
	/usr/local/mysql/support-files/mysqld_multi.serve start 3306
>####停止
	/usr/local/mysql/support-files/mysqld_multi.serve stop 3306
>####10.查看初始密码
	grep 'temporary password' /var/log/mysqld.log
>####11.进入mysql,并修改初始密码
	mysql -uroot -p
	ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';