- 下载Mysql5.7
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz
tar -zxvf jdk-8u321-linux-x64.tar.gz
tar -zxvf mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz
rm -rf mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.37-linux-glibc2.12-x86_64 /usr/local/mysql
- 创建数据目录并赋权限
mkdir mysql
groupadd mysql && useradd -r -g mysql mysql
chown mysql:mysql -R /data/mysql
- 修改配置文件
vim /etc/my.cnf
[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysql
socket=/data/mysql/mysql.sock
character_set_server=utf8mb4
explicit_defaults_for_timestamp=true
symbolic-links=0
log-error=/data/mysql/mysql.log
pid-file=/data/mysql/mysql.pid
- 初始化(密码在最后一行中)
cd /usr/local/mysql/bin
yum install -y libaio numactl
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql --initialize
tail -1 /data/mysql/mysql.log
2022-03-10T07:59:19.612476Z 1 [Note] A temporary password is generated for root@localhost: Dprirkmhy5/t
- 启动mysql
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
service mysql start
- 登录mysql
/usr/local/mysql/bin/mysql -u root -h 127.0.0.1 -p
- 修改密码
mysql> SET PASSWORD = PASSWORD('123456');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)