slave 192.168.1.106数据库安装

#从109服务器复制安装文件
scp mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz  root@10.10.0.106:/liri/soft/soft
#卸载mariadb
rpm -qa|grep mariadb
cd /liri/soft/soft
tar -xvf mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz

ll
#重命名
mv mysql-8.0.18-linux-glibc2.12-x86_64 mysql
#移动到usr/
mv mysql /usr/local/

cd /usr/local/mysql
mkdir data
#10.10.0.109复制<my.cnf>配置文件
scp root@10.10.0.109:/usr/local/mysql/my.cnf /usr/local/mysql/
cp /usr/local/mysql/my.cnf /etc/

rpm -qa|grep libaio

#安装配置
cd /usr/local/mysql/bin
./mysqld --initialize --console

#启动mysql
cd /usr/local/mysql/support-files
 ./mysql.server start
 
 rm -rf /var/lock/subsys/mysql

cd /var/lib
mkdir mysql
cd /usr/local/mysql/support-files
./mysql.server start

rm -rf /usr/local/mysql/data/
#重新初始化
cd /usr/local/mysql/bin
./mysqld --initialize --console

cd /usr/local/mysql/support-files
cp mysql.server  /etc/init.d/mysqld

#启动失败的话,查看日志，先注释删除my.cnf的sql_mode
cat /usr/local/mysql/logs/error.log

service mysqld restart

mysql -uroot -p

#更新密码,授权等
SQL> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Ab1234568';
SQL> update user set host='%' where user = 'root';
SQL> use mysql;
SQL> update user set host='%' where user = 'root';
SQL> grant all privileges on *.* to 'root'@'%';
SQL> update user set host='%' where user = 'root';
SQL> grant all privileges on *.* to 'root'@'%';
SQL> flush privileges;
SQL> exit;


mysql -uroot -h 10.10.0.106 -p
#登录正常，
#如果换个服务器登录失败--云服务器主机开通端口。

！！！！！！！！！！！安装OK！！！！！！！！！！！

##加入开机启动

chkconfig --add mysqld
chkconfig mysqld on
chkconfig --list