#1系统体验设置
[root@stu ~]# vi ~/.nashrc
export PS1='\[\e[32m\][\[\e[35m\]\u\[\e[m\]@\[\e[36m\]\h \[\e[31m\]\W\[\e[32m\]]\[\e[36m\]\$\[\e[m\] '
[root@stu ~]# hostnamectl set-hostname stu
[root@stu ~]# bash
#2关闭selinux并删除系统默认自带的mariadb
[root@stu ~]# getenforce
Enforcing
[root@stu ~]# setenforce 0
[root@stu ~]# getenforce
disabled
[root@stu ~]# vi etc/selinux/config
SELINUX=disabled
[root@stu ~]# rpm -qa mariadb-libs
[root@stu ~]# rpm -e --nodeps mariadb-libs
error: package mariadb-libs is not installed
[root@stu ~]# rm -rf /etc/my.cnf
[root@stu ~]#
#3安装依赖设置用户创建目录并授权
[root@stu ~]# yum install libaio-devel -y
[root@stu tools]# useradd -s /sbin/nologin -M mysql
[root@stu tools]# mkdir -p /application/mysql/data[root@stu tools]# mkdir -p /application/mysql/binlog[root@stu tools]# chown -R mysql.mysql /application/mysql/
[root@stu tools]# ls -ld /application/mysql/
#4编写配置文件
[root@stu ~]# vim /etc/my.cnf
[mysqld]
user=mysql
basedir=/usr/local/mysql
datadir=/application/mysql/data
socket=/tmp/mysql.sock
server_id=6
port=3306
gtid-mode=on
enforce-gtid-consistency=true
log_error=/application/mysql/data/mysql.log
log_bin=/application/mysql/binlog/mysql-bin
binlog_format=row
max_binlog_size=512M
binlog_expire_logs_seconds=604800
secure-file-priv=/tmp
innodb_flush_method=O_DIRECT
lower_case_table_names=1
[client]
socket=/tmp/mysql.sock
[mysql]
socket=/tmp/mysql.sock
prompt=laiyue [\\d]>
#5下载解压设置环境变量
[root@stu ~]# cd /server/tools
[root@stu ~]# wget https://cdn.mysql.com/archives/mysql-8.0/mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz
[root@stu tools]# tar xf mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz
[root@stu tools]# mv mysql-8.0.26-linux-glibc2.12-x86_64 /application/
[root@stu tools]# ln -s /application/mysql-8.0.26-linux-glibc2.12-x86_64 /usr/local/mysql
[root@stu tools]# vim /etc/profile
export PATH=/usr/local/mysql/bin:$PATH
[root@stu tools]# source /etc/profile
[root@stu tools]# mysql -V
#6初始化数据库
[root@stu ~]# mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/application/mysql/data
#7查看mysql自带的启动脚本
[root@stu ~]# sh /usr/local/mysql/support-files/mysql.server
Usage: mysql.server {start|stop|restart|reload|force-reload|status} [ MySQL server options ]
#8拷贝脚本到系统启动脚本服务管理目录中
[root@stu ~]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
#9用传统的方式启动mysql
[root@stu init.d]# service mysqld restart
[root@stu ~]# netstat -tulnp
#10加入开机自启动并自动生成systemctl管理工具
[root@stu ~]# systemctl enable mysqld
#11重启后测试
[root@stu ~]# systemctl restart mysqld
[root@stu ~]# systemctl stop mysqld
[root@stu ~]# systemctl status mysqld
