类型 | 主机名 | IP | 操作系统 |
---|---|---|---|
Master | master | 192.168.121.182 | CentOS 7.3 |
slave | slave | 192.168.121.181 | CentOS 7.3 |
# wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
# sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
# yum -y install mysql-server mysql mysql-devel
mysql-devel:开发用到的库以及包含文件。 mysql:mysql客户端。 mysql-server:数据库服务器。
# sudo chown -R root:root /var/lib/mysql
# systemctl start mysqld
# mysql -uroot
mysql > use mysql;
mysql > update user set password=password('123456') where user='root';
mysql > exit;
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
# systemctl restart mysqld