测试环境:
192.168.226.129
192.168.226.130
MySQL安装:
一、rpm包
1、wget http://repo.mysql.com/mysql-community-release-el7- 5.noarch.rpm(下载rpm)
2、rpm -ivh mysql-community-release-el7-5.noarch.rpm(安装 rpm包)
3、yum install mysql-server (安装)
二、操作MySQL
1、service mysql start(启动数据库)
2、service mysql status(查看数据库状态)
3、mysql -u root -p(登录数据库)
3、GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
flush privileges; (赋值权限)
4、exit
三、Linux防火墙
1、systemctl status firewalld.service(查看防火墙状态)
2、systemctl stop firewalld.service (关闭防火墙) 注意点: centos7中防火墙的文件名有改变:
1、firewalld的基本使用
启动: systemctl start firewalld
关闭: systemctl stop firewalld
查看状态: systemctl status firewalld
开机禁用 : systemctl disable firewalld
开机启用 : systemctl enable firewalld
99 rpm -qa | grep mysql
106 yum -y install wget
107 wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
108 rpm -ivh mysql-community-release-el7-5.noarch.rpm
109 yum install mysql-server
111 mysql -u root
112 chown root /var/lib/mysql/
113 mysql -u root
use mysql;
update user set password=password('123456') where user='root';
exit;
116 service mysql restart
117 mysql -u root -p
mysql -u root -p
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";
118 service mysqld restart
``
`
MySQL主从复制配置
主节点服务器 地址 192.168.226.130
从节点服务器 地址 192.168.226.129
主节点服务器安装好之后,直接clone 一个即可,不需要重复安装2次。
从节点clone命令