1.先安装mysql,并配置密码,用户远程登陆权限
一、mysql安装
1、下载yum文件
wget http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
2、安装yum文件
rpm -ivh mysql57-community-release-el7-10.noarch.rpm
3、安装mysql
yum -y install mysql-community-server --nogpgcheck
4、测试
systemctl start mysqld
systemctl stop mysqld
systemctl restart mysqld
systemctl status mysqld
systemctl enable mysqld
5、查找密码
grep "password" /var/log/mysqld.log
6、复制密码并登陆数据库
mysql -u root -p
7、修改密码策略
mysql> SET GLOBAL validate_password_policy=LOW;
mysql> SET GLOBAL validate_password_length=4;
8、修改密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '1111';
9、开启远程登录权限
mysql> use mysql;
mysql> select User,Host from user;
mysql> update user set host ="%" where user = "root";
mysql> flush privileges;
2.主从复制,分别修改主从两台机器的配置文件
原理:
主:log_bin
从:IO线程读取日志,SQL线程根据日志同步数据
2、配置步骤:
主:
1、开启日志并修改server_id
vim /etc/my.cnf:
log_bin=master_log
server_id=1
2、重启mysql
systemctl restart mysqld
3、查看master状态
mysql> show master status;
从:
1、修改server_id
vim /etc/my.cnf:
server_id=2
2、修改uuid
vim /var/lib/mysql/auto.cnf:
server-uuid=xxxxxx6
3、重启mysql
systemctl restart mysqld
4、修改slave状态
mysql> stop slave;
mysql> change master to master_host='192.168.83.128',master_user='root',master_password='1111',master_log_file='master_log.000001';
mysql> start slave;
5、查看slave状态
mysql>show slave status \G;