centos 7 安装percona Server 服务器方法

rpm -qa | grep mysql
rpm -qa | grep mariadb
rpm -e [软件标识]

初始化 

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 

chown -R centralight /cl/data/mysql/percona3311 

mysql_install_db --datadir=/cl/data/mysql/percona3311 --user=centralight 

[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 

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; 

systemctl stop firewalld.service 

systemctl disable firewalld.service