1、下载二进制安装文件,并解压至/usr/local/mysql-8.0.17,创建相关目录及文件
tar -zxf mysql-8.0.17-el7-x86_64.tar.gz -C /usr/local mv /usr/local/mysql-8.0.17-el7-x86_64.tar.gz /usr/local/mysql-8.0.17 mkdir -p /opt/datas/mysql/data mkdir -p /opt/datas/mysql/log mkdir /usr/local/mysql-8.0.17/conf touch /usr/local/mysql-8.0.17/conf/my.cnf
2、修改my.cnf文件
[mysqld] port=3306 datadir=/opt/datas/mysql/data log-error=/opt/datas/mysql/log/mysqld.log user=mysql [client] socket=/opt/datas/mysql/mysql.socket
3、添加mysql用户,及添加相应的目录权限
groupadd mysql useradd -s /sbin/nologin -M -g mysql mysql chown -R mysql:mysql /usr/local/mysql-8.0.17 echo "" > /opt/datas/mysql/log/mysqld.log chown -R mysql:mysql /opt/datas/mysql
4、将mysql的bin目录添加到环境变量中
echo "export PATH=$PATH:/usr/local/mysql-8.0.17/bin" >> /etc/profile source /etc/profile
5、初始化mysql
mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql-8.0.17 --datadir=/opt/datas/mysql/data
6、启用mysql
mysqld_safe --defaults-file=/usr/local/mysql-8.0.17/conf/my.cnf &
7、设置root密码
use mysql ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123'; update user set host ='%' where user='root'; flush prileges;
8、关闭mysql
mysqladmin shutdown
9、添加mysql服务及设置自启动
添加文件 vim /etc/systemd/system/mysqld.service
[Unit] Description=MySQL Server 8.0.17 Documentation=man:mysqld(8) 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=/usr/local/mysql-8.0.17/bin/mysqld --defaults-file=/usr/local/mysql-8.0.17/conf/my.cnf LimitNOFILE = 5000
开启自启动
systemctl enable mysqld
启动服务
systemctl start mysqld
10、更改防火墙设置,允许mysql远程访问
firewall-cmd --zone=public --add-port=3306/tcp --permanent firewall-cmd --reload
吾生也有涯,而知也无涯。以有涯随无涯,殆己。