mysql-5.7.39-tar包部署

版本选择下载地址：https://downloads.mysql.com/archives/community/

1、#检查是否安装过mysql或Mariadb--执行卸载

rpm -qa | grep mysql |xargs rpm -e --nodeps
rpm -qa | grep mariadb |xargs rpm -e --nodeps
userdel -r mysql
#查找mysql的安装路径逐一删除
find / -name mysql

2、上传解压安装包，创建mysql账号

groupadd mysql
useradd -g mysql -d /data/mysql mysql
mkdir -p /data/mysql/{data,log} && touch /data/mysql/log/err.log
tar -zxvf mysql-5.7.39-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.39-linux-glibc2.12-x86_64/* /data/mysql

3、创建配置文件my.cnf

cat << EOF >/etc/my.cnf
[mysqld]
basedir = /data/mysql
datadir = /data/mysql/data
log-error=/data/mysql/log/err.log
port = 3306
#最大连接数
max_connections = 5000
#最大错误连接数
max_connect_errors = 1000
#启用二进制日志-主从使用
#log-bin=mysql-bin
#主从使用
#server-id=1
#批量插入sql语句大小限制-默认4M
max_allowed_packet=128M
character_set_server=utf8
init_connect='SET NAMES utf8'
#忽略同步表
#replicate-wild-ignore-table=mysql.*
#replicate-wild-ignore-table=sys.*
[client]
default-character-set=utf8
EOF

4、初始化mysql

chown -R mysql:mysql /data/mysql/data  /data/mysql/log
chmod -R 755 /data/mysql/data
cd /data/mysql
./bin/mysqld --user=mysql --basedir=/data/mysql --datadir=/data/mysql/data --initialize

5、添加开机启动

cd support-files/
sed -i s#^basedir=#basedir=/data/mysql#g mysql.server
sed -i s#^datadir=#datadir=/data/mysql/data#g mysql.server
cp /data/mysql/support-files/mysql.server /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
cat << EOF >>/etc/profile
PATH=$PATH/data/mysql/bin
EOF
source /etc/profile
systemctl start mysqld

6、进入mysql配置相关项

#默认密码为冒号后字符串
grep 'temporary password' /data/mysql/log/err.log
mysql -uroot -p
set password=password('新密码');
use mysql;
update user set host='%' where user='root';
GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '设置的密码' WITH GRANT OPTION;
FLUSH PRIVILEGES;
\q
systemctl restart mysqld

#不进入mysql执行--快捷方式！！！
mysql -uroot -p`grep root@localhost  /data/mysql/log/err.log | awk -F:\  '{print $2}'`  --connect-expired-password  -e "set password=password('system@123');"
mysql -uroot -psystem@123 -e "use mysql;update user set host='%' where user='root';"
mysql -uroot -psystem@123 -e "use mysql;GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'system@123' WITH GRANT OPTION;"
mysql -uroot -psystem@123 -e "FLUSH PRIVILEGES;"
systemctl restart mysqld