1.上传文件压缩包( mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz)
下载地址:https://download.csdn.net/download/weixin_48133875/62508880
2.解压tar.xz
tar -xvJf mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz
3.修改文件名
[root@2dgrzxbs app]# mv mysql-8.0.26-linux-glibc2.12-x86_64 mysql
4.创建组和创建用户
[root@2dgrzxbs app]# groupadd mysql
[root@2dgrzxbs app]# useradd -r -g mysql mysql
5.在mysql目录下创建data文件夹
[root@2dgrzxbs mysql]# mkdir data
6.指定用户和组
[root@2dgrzxbs app]# chown -R mysql mysql/
[root@2dgrzxbs app]# chgrp -R mysql mysql/
7.初始化mysql
[root@2dgrzxbs app]# cd mysql
[root@2dgrzxbs mysql]# cd bin
[root@2dgrzxbs bin]# yum -y install numactl
8.显示mysql初始密码(图中是初始化密码)
[root@2dgrzxbs bin]#./mysqld --initialize --user=mysql --basedir=/app/mysql/
--datadir=/app/mysql/data/ --lc_messages_dir=/app/mysql/share --lc_messages=en_US
9.配置my.cnf(注意图中路径配置,如果后面socket,log-error路径报错,改正的方式,可以按照报错信息文件修改路径)
[root@2dgrzxbs app]#vi /etc/my.cnf
[mysqld]
basedir=/app/mysql/
datadir=/app/mysql/data/
socket=/路径/mysql.sock
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
10.设置开机自启
[root@2dgrzxbs bin]# cd /app/mysql/support-files/
[root@2dgrzxbs support-files]#cp mysql.server/etc/init.d/mysql
[root@2dgrzxbs support-files]# vi /etc/init.d/mysql
11.授权
[root@2dgrzxbs support-files]# chmod +x /etc/init.d/mysql
[root@2dgrzxbs support-files]# chkconfig --add mysql
12.服务指令
启动服务:service mysql start
停止服务:service mysql stop
重启服务:service mysql restart
查看服务:service mysql status
13.修改密码
[root@2dgrzxbs bin]# ./mysql -u root -p
mysql> alter user 'root'@'localhost' identified by '123456';
mysql> flush privileges;
14.远程连接(连接权限)
mysql> create user root@'%' identified by '123456';
mysql> grant all privileges on *.* to root@'%' with grant option;
mysql> flush privileges;
15.防火墙设置
防火墙状态 systemctl status firewalld
开启防火墙 systemctl start firewalld
关闭防火墙 systemctl stop firewalld
查询指定端口是否已开:firewall-cmd --query-port=端口/tcp
添加指定需要开放的端口:firewall-cmd --add-port=端口/tcp --permanent
重载入添加的端口:firewall-cmd --reload