mysql8安装

1、先卸载当前系统中已安装的mariadbrpm -qa | grep mariadbrpm -e --nodeps ⽂件名2、安装mysql依赖包

yum install gcc gcc-c++ openssl openssl-devel libaio libaio-devel ncurses ncurses-devel3、下载mysql

wget https://mirrors.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-8.0/mysql-8.0.16-el7-x86_.tar.gz4、解压mysql压缩包，创建mysql⽬录

tar xf mysql-8.0.15-el7-x86_.tar.gz -C /application/mv mysql-8.0.15-el7-x86_/ mysqlcd mysql

mkdir data ----创建数据库⽂件⽬录mkdir logs ----创建⽇志⽬录

/application/mysql/logs/error.log 创建⽇志5、创建mysql虚拟⽤户和组

useradd -s /sbin/nologin -M mysql #groupadd mysql #添加⽤户组

#useradd -r -g mysql mysql #创建mysql⽤户，并添加到mysql⽤户组 chown -R mysql.mysql /application/mysql6、配置/etc/my.cnf

[mysqld]

basedir=/application/mysqldatadir=/application/mysql/dataport=3306

socket=/tmp/mysql.sock

pid-file=/application/mysql/python.pid

log-error=/application/mysql/logs/error.log

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLEScharacter_set_server = utf8[client]

default-character-set = utf8

7、配置环境变量

echo \"export PATH=$PATH:/application/mysql/bin\" >> /etc/profilesource /etc/profile8、初始化数据库

./bin/mysqld --initialize --user=mysql --basedir=/application/mysql/ --datadir=/application/mysql/data #mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql初始化完成后，会⾃动为root帐户⽣成⼀个初始密码，要记录下来9、制作启动⽂件

cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld

sed -i 's#/usr/local/mysql#/application/mysql#g' /application/mysql/bin/mysqld_safe /etc/init.d/mysqldchmod +x /etc/init.d/mysqld10.启动mysql服务/etc/init.d/mysqld start停⽌mysql服务/etc/init.d/mysqld stop11.改密码

alter user root@'localhost' identified by '123456';12.创建远程连接帐号

create user root@'%' identified by '21345';grant all on *.* to root@'%' with grant option;flush privileges;