mysql 8.0版本安装配置

查看是否安装了数据库

[root@localhost ~]# rpm -qa |grep  mariadb
[root@localhost ~]# rpm -qa |grep  mysql

下载mysql源

[root@localhost ~]#  yum install libaio

下载mysql 8.0版本

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz

#####安装依赖

[root@localhost ~]# yum install -y ncurses-devel libaio-devel gcc gcc-c++ glibc cmake autoconf

解压安装包

[root@localhost ~]# tar   xf  mysql-8.0.11-linux-glibc2.12-x86_64.tar.xz

移动目录并改名

[root@wl2 ~]# mv mysql-8.0.11-linux-glibc2.12-x86_64 /usr/local/mysql-8.0.11

创建软连接

[root@localhost ~]# ln -s /usr/local/mysql-8.0.11/  /usr/local/mysql

创建登陆用户

root@localhost ~]# useradd mysql -s /sbin/nologin -M

配置文件

[root@wl2 ~]# cat  /etc/my.cnf 
[client]
port=3306

[mysqld]
#server_id=222
port=3306
user=mysql
socket=/tmp/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
log-error=/var/log/mysqld.log

transaction_isolation = READ-COMMITTED
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
lower_case_table_names = 1

gtid_mode=ON
log_slave_updates
enforce_gtid_consistency
slave-skip-errors=all
skip-name-resolve=1

进入配置文件初始化

[root@wl2 ~]# cd  /usr/local/mysql/bin/
[root@wl2 /usr/local/mysql/bin]#  ./mysqld --initialize  --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

##### 初始化之后日志里会生成随机密码

--user：指定用户
--basedir：指定mysql的安装目录
--datadir：指定MySQL的数据目录