1.创建安装目录
mkdir /mysql
2.进入安装目录
cd /data
3.下载5.7.24的tar包
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
4.解压
tar -xvzf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
5.修改文件夹名
mv mysql-5.7.24-linux-glibc2.12-x86_64 mysql
6.查看是否存在mysql残留,并进行清除
查看包:rpm -qa|grep -i mysql
清除包:rpm -ev 残余包名 --nodeps
查看路径:find / -name mysql
清除路径:rm -rf 路径
7.创建用户和用户组
groupadd mysql
useradd -r -g mysql mysql
8.root用户下执行初始化,这里会生成一个初始的临时密码,需要记录下来
./mysqld --initialize --user=mysql --basedir=/data/mysql/ --datadir=/data/mysql/data/ --lc_messages_dir=/data/mysql/share --lc_messages=en_US
9.编辑my.cnf
vim /etc/my.cnf
10.添加内容
[mysqld] basedir=/data/mysql/ datadir=/data/mysql/data/ socket=/data/mysql/data/mysql.sock [client] port=3306 socket=/data/mysql/data/mysql.sock
11.创建systemd管理项
vim /usr/lib/systemd/system/mysqld.service
12.写入system配置
[Unit] Description=MySQL Server Documentation=mysqld Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html After=network.target After=syslog.target [Install] WantedBy=multi-user.target [Service] User=mysql Group=mysql ExecStart=/data/mysql/bin/mysqld --defaults-file=/etc/my.cnf LimitNOFILE = 5000
13.重读systemd
systemctl daemon-reload
14.启动mysql,查看启动状态,并设置开机自启
systemctl start mysqld.service systemctl status mysqld.service systemctl enable mysqld.service
15.设置mysql远程访问,输入之前生成的临时密码
./mysql -uroot -p
16.修改临时密码
ALTER USER USER() IDENTIFIED BY '123456';
17.设置root远程访问
use mysql GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; FLUSH PRIVILEGES;