mysql 8.0 安装记录

mysql 8.0 安装记录

mysql 安装信息：

用root 安装依赖

yum -y install libaio libaio-devel

下载mysql安装包

nohup wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz &

解压到/home/hadoop 目录中

tar -xvf mysql-8.0.26-linux-glibc2.12-x86_64.tar.xz

mv mysql-8.0.26-linux-glibc2.12-x86_64 mysql

mkdir -p /home/hadoop/mysql/{data,log,tmp,var,conf}

上传my.cnf 模版配置文件到conf 目录中

my.cnf

初始化mysql

./bin/mysqld --defaults-file=/home/hadoop/mysql/conf/my.cnf --initialize --user=‘hadoop’ ;

启动mysql命令

./bin/mysqld_safe --defaults-file=/home/hadoop/mysql/conf/my.cnf &

通过查看mysql 启动日志，查看到mysql root 密码

./mysql -uroot -p’Ra8s(1qyhkuO’ -h localhost -S /home/hadoop/mysql/var/mysql.sock

修改root 密码

alter user ‘root’@‘localhost’ identified by ‘talkingData_2021’;

create user ‘feilong’@’%’ identified by ‘feiLong_2021’ ;

grant all privileges on . to ‘feilong’@’%’ ;

alter user ‘feilong’@’%’ identified with mysql_native_password by ‘feiLong_2021’ ;

备用跳过root 输入密码时用。

#./bin/mysqld_safe --defaults-file=/home/hadoop/mysql/conf/my.cnf --skip-grant-tables &

配置信息： 172.23.7.58 feilong/feiLong_2021

#查看防火墙，通常要关闭防火墙

systemctl status firewalld

service iptables stop

#关闭防火墙

systemctl stop firewalld

service stop status

配置文件如下：

[mysqld]
port                               = 3306
basedir                            = /home/hadoop/mysql
datadir                            = /home/hadoop/mysql/data
tmpdir                             = /home/hadoop/mysql/tmp
socket                             = /home/hadoop/mysql/var/mysql.sock
pid-file                           = /home/hadoop/mysql/var/mysql.pid
slow_query_log_file                = /home/hadoop/mysql/log/slow.log
log_error                          = /home/hadoop/mysql/log/error.log
sql_mode                           = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
explicit_defaults_for_timestamp    = off
innodb_buffer_pool_size            = 2G
max_connections                    = 32000
max_connect_errors                 = 2000
max_allowed_packet                 = 30M
log-bin=mysql-bin
server-id=1
binlog_format=MIXED
character-set-server               = utf8mb4
[mysql]
default-character-set = utf8mb4
socket                             = /home/hadoop/mysql/var/mysql.sock

[client]
default-character-set = utf8mb4
socket                = /home/hadoop/mysql/var/mysql.sock