在s201,s202,s203上安装MySQL
(安装jdk)
配置MySQL 5.7的yum源
sudo tee -a /etc/yum.repos.d/mysql-community.repo << EOF
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/\$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
EOF
检查mysql源的信息
yum repolist enabled | grep mysql
安装mysql的server
sudo yum install -y mysql-community-server
启动mysql
sudo service mysqld start
获取启动日志中的默认初始密码
sudo grep ‘temporary password’ /var/log/mysqld.log
获取密码并赋给一个变量
PASSWORD=sudo grep 'temporary password' /var/log/mysqld.log | awk '{print $NF}'
使用root用户登录
mysql -uroot -p$PASSWORD
修改root用户的密码
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘Lazy_123!’;
修改mysql远程登录权限
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘Lazy_123!’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
安装mycat(s201)
安装JDK并配置环境变量
解压安装包
修改配置文件
修改conf目录下主要以下三个注意配置文件
server.xml是Mycat服务器参数调整和用户授权的配置文件
schema.xml是逻辑库定