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
