Centos7安装MySQL5.7以及PT工具

sudo rpm -Uvh https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
sudo rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

sudo yum install mysql-community-server -y

sudo systemctl start mysqld
sudo systemctl enable mysqld

sudo grep 'temporary password' /var/log/mysqld.log

mysql_secure_installation

CREATE USER 'username'@'%' IDENTIFIED BY 'StrongPassword123!';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

-- 修改 root 用户的主机限制（适用于 MySQL 5.7）测试使用
UPDATE mysql.user SET Host='%' WHERE User='root' AND Host='localhost';
FLUSH PRIVILEGES;

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf  # Ubuntu
sudo vi /etc/my.cnf                         # CentOS

bind-address = 0.0.0.0

sudo systemctl restart mysql    # Ubuntu
sudo systemctl restart mysqld    # CentOS

# 添加 Percona YUM 仓库
sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm -y
# 启用 Percona Toolkit 仓库
sudo percona-release enable tools release
# 安装 Percona Toolkit
sudo yum install percona-toolkit -y
# 验证
pt-query-digest --version
pt-online-schema-change --version