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