mkdir -p /data/mysql/data /data/mysql/log
groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysql /data/mysql/
#/etc/my.cnf 配置文件
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
server-id = 1
port = 3306
basedir = /usr/local/mysql
datadir = /data/mysql/data
pid-file = /data/mysql/mysql.pid
socket = /tmp/mysql.sock
tmpdir = /tmp
user = mysql
bind-address = 0.0.0.0
log_error=/data/mysql/log/mysql.log
#default_authentication_plugin=mysql_native_password
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
skip-external-locking
skip_name_resolve = 1
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
init_connect='SET NAMES utf8mb4'
lower_case_table_names = 1
max_connections = 400
max_connect_errors = 1000
explicit_defaults_for_timestamp = true
max_allowed_packet = 128M
interactive_timeout = 1800
wait_timeout = 1800
tmp_table_size = 134217728
max_heap_table_size = 134217728
#expire_logs_days = 15
#初始化
/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data/ --initialize
配置启动服务
vim /usr/lib/systemd/system/mysql.service
[Unit]
Description=MySQL server
After=syslog.target network.target
[Service]
User=mysql
Group=mysql
Type=forking
TimeoutSec=0
#PermissionsStartOnly=true
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --daemonize
LimitNOFILE = 65535
Restart=on-failure
RestartSec=3
RestartPreventExitStatus=1
PrivateTmp=false
[Install]
WantedBy=multi-user.target
修改root密码
alter user 'root'@'localhost' identified by 'f6789affefdaM'
同步账号密码
create user 'slave'@'%' identified by '21dafefjj12da%';
grant replication slave on *.* to 'slave'@'%';
grant replication SLAVE, replication client ON *.* TO 'slave'@'%';
flush privileges;
从服务器登录后执行：
change master to get_master_public_key=1;
CHANGE MASTER TO MASTER_HOST='192.168.10.29', MASTER_USER='slave', MASTER_PASSWORD='21dafefjj12da%', MASTER_PORT=3306;
开启同步
start slave;
show slave status\;