CentOS 7 安装 Percona Server 5.6

关注

最新推荐文章于 2026-07-26 14:31:09 发布 466 阅读 AI 写同款· GEO 优化 ›

执行用户 root , 安装使用用户 centralight

1.更新yum
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm

2.安装
yum install Percona-Server-client-56 Percona-Server-server-56
安装如果有冲突，之前已经安装过mysql，则需要卸载
rpm -qa | grep mysql
rpm -qa | grep mariadb
rpm -e [软件标识]

3.非多实例配置及启动
默认配置文件路径 /etc/my.cnf
初始化
mysql_install_db --user=centralight --datadir=/cl/data/mysql/percona3311
启动
mysqld_safe --user=centralight --datadir=/cl/data/mysql --defaults-file=/cl/dist/conf/mysql/my.cnf

4.多实例配置及启动
chown -R centralight /cl/data/mysql/percona3311
mysql_install_db --datadir=/cl/data/mysql/percona3311 --user=centralight

所有配置文件目录
默认配置文件路径 /etc/my.cnf,修改成如下
[client]
user = root
password = 123
# Here follows entries for some specific programs
[mysqld_multi]
mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin

[mysqld3311]
socket     = /var/lib/mysql/mysql3311.sock
port       = 3311
datadir    = /cl/data/mysql/percona3311
pid-file   = /var/lib/mysql/hostname.pid3311
user       = centralight

skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
启动
mysqld_multi --defaults-file=/etc/my.cnf --log=/cl/log/mysql/mysql.log start 3311
报告状态
mysqld_multi --defaults-file=/etc/my.cnf report 3311

5.登陆数据库修改用户及权限，并能远程连接
mysql -uroot -p -h127.0.0.1 -P3311
mysql> use mysql;
mysql> update user set host='%’ where host = ‘localhost’ and user=‘root’
mysql> flush privileges;

设置密码
mysql> UPDATE user SET Password=password("123") WHERE user='root' and host='%’;
mysql> flush privileges;