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