标签：lib 二进制 MySQL5.7 部署 usr mysql var -- local

MySQL5.7二进制部署❄️⛄☃️

准备工作：

卸载系统中的mariadb

rpm -qa | grep mariadb
yum remove mariadb

1.下载二进制安装包

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.39-linux-glibc2.12-x86_64.tar.gz

安装依赖

 yum -y install libaio

2.解压安装

tar -xvf mysql-5.7.39-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
cd /usr/local
mv mysql-5.7.39-linux-glibc2.12-x86_64/  mysql

3.创建mysql用户及组

grouadd mysql
useradd -r -g mysql -s /sbin/nologin mysql

4.创建mysql数据目录

mkdir /var/lib/mysql
chown -R mysql:mysql /var/lib/mysql
mkdir /var/log/mysql
chown -R mysql:mysql /var/log/mysql
mkdir /var/run/mysql
chown -R mysql:mysql /var/run/mysql

5.创建mysql配置文件

vim /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
user=mysql
port=3306
[mysqld_safe]
log-error=/var/log/mysql/mysql.log
pid-file=/var/run/mysql/mysql.pid

6.初始化mysql

/usr/local/mysql/bin/mysqld  --defaults-file=/etc/my.cnf --initialize --user=mysql

==使用--initialize参数，则会生成临时密码==2022-12-06T07:28:42.142154Z 1 [Note] A temporary password is generated for root@localhost: %NwqJp,7Tu2g

==使用--initialize-insecure参数，可以直接登录mysql，无需密码。==

7.使用system管理服务

vim /usr/lib/systemd/system/mysql.service
[Unit]
Description=mysql
After=network.target remote-fs.target nss-lookup.target
[Service]
Type=forking
ExecStart=/usr/local/mysql/support-files/mysql.server start
ExecReload=/usr/local/mysql/support-files/mysql.server restart
ExecStop=/usr/local/mysql/support-files/mysql.server stop
PrivateTmp=true
[Install]
WantedBy=multi-user.target

8.开机自启mysql

systemctl daemon-reload
systemctl enable --now mysql

9.配置mysql环境变量

vim /etc/profile
export PATH=$PATH:/usr/local/mysql/bin
source /etc/profile

10.登录mysql并修改密码

使用--initialize-insecure参数初始化时，可以直接登录
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
解决方法：
ln -s /var/lib/mysql/mysql.sock  /tmp/mysql.sock

mysql> alter user 'root'@'localhost' IDENTIFIED BY '123456';
mysql> flush privileges;

 

标签：lib,二进制,MySQL5.7,部署,usr,mysql,var,--,local
From： https://www.cnblogs.com/haoee/p/16955514.html