Percona 为 MySQL 数据库服务器进行了改进,在功能和性能上较 MySQL 有着很显著的提升。该版本提升了在高负载情况下的 InnoDB 的性能、为 DBA 提供一些非常有用的性能诊断工具;另外有更多的参数和命令来控制服务器行为
Step1: 进入安装目录
执行:cd /usr/local
Step2:卸载系统自带的mysql 否则可能会产生冲突
执行: rpm -qa|grep -i mysql
rpm-e --nodeps xxxxxx(已安装的mysql rpm包)
Step3: 获取最新perconaserver rpm (percona server5.6 rhel6 64bit)
下载地址:
http://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.13-rc60.5/RPM/rhel6/x86_64/
Step4: 安装perconaserver
执行: rpm-ivh Percona-Server-server-56-5.6.13-rc60.5.417.rhel6.x86_64.rpmPercona-Server-client-56-5.6.13-rc60.5.417.rhel6.x86_64.rpmPercona-Server-shared-56-5.6.13-rc60.5.417.rhel6.x86_64.rpm
或者
rpm -ivhPercona-Server-shared-56-5.6.13-rc60.5.417.rhel6.x86_64.rpm
rpm -ivhPercona-Server-client-56-5.6.13-rc60.5.417.rhel6.x86_64.rpm
rpm -ivhPercona-Server-server-56-5.6.13-rc60.5.417.rhel6.x86_64.rpm
至此已安装完percona 服务器端、客户端和客户端共享库.
Step5: 启动mysql(Percona Server)
执行:service mysql start
Step6: 设定root用户密码
执行:/usr/bin/mysqladmin -u root password'new-password'
Step7: 访问mysql
执行:mysql –h localhost –u root –p 123456
Step8: 新建用户
格式: create user 'username'@'host' identified by 'password';
执行: createuser 'darcy'@'localhost' identified by '123456';
flush privileges;
Step9: 授予权限
格式:grant privileges on databasename.tablename to 'username'@'host'
执行:grant all privileges on *.* to darcy@'%'identified by '123456';
flush privileges;
其他操作同mysql 类似.