CentOS7 安装 Percona Server for My

0、准备活动

先删除可能存在的Percona Server或Mysql

$ find / -name mysql|xargs rm -rf
$ service mysql stop
$ yum remove Percona-Server*
$ rm -rf /var/lib/mysql
$ rm -f /etc/my.cnf

1、添加官方源

yum install http://www.percona.com/downloads/percona-release/redhat/0.1-6/percona-release-0.1-6.noarch.rpm

2、安装Percona Server

yum install Percona-Server-server-57

3、启动 Percona Server

启动 停止 重启 查看命令如下..

service mysql start
service mysql status
service mysql stop
service mysql restart

4、设置系统服务并开机启动 Percona Server

systemctl enable mysql.service
systemctl start mysql.service

5、从错误日志中获取默认密码

tail -300f /var/log/mysqld.log

6、登录mysql 初始化数据库

mysql -uroot -p

修改root密码,添加远程超级用户,刷新权限

SET PASSWORD = PASSWORD('your_new_password');
GRANT ALL PRIVILEGES ON *.* TO admin@"%" IDENTIFIED BY 'your_password' WITH GRANT OPTION;
flush privileges;

试一下用远程访问权限用户admin连接数据库

完美