How to install Percona Database Server
From Brian Nelson Ramblings
Contents
How to install Percona Database Server
You have heard of all the performace increases by using Percona over normal MySQL.
Now you want to install Percona on your Centos system.
First you will want to install the repo
rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
Now you can run
yum install Percona-Server-server-56 Percona-Server-client-56
This will install Percona's Server 5.6 package.
Testing the Percona Repo
Make sure the packages are downloadable from the Repo
yum list | grep percona
You will see something like:
Percona-Server-server-51.x86_64 5.1.72-rel14.10.597.rhel6 percona Percona-Server-server-55.x86_64 5.5.34-rel32.0.591.rhel6 percona Percona-Server-server-56.x86_64 5.6.14-rel62.0.483.rhel6 percona Percona-Server-shared-51.x86_64 5.1.72-rel14.10.597.rhel6 percona Percona-Server-shared-55.x86_64 5.5.34-rel32.0.591.rhel6 percona
Set root password
Make sure to start Percona
service mysqld start
Log into mysql and check the users
mysql -u root
SELECT User, Host, Password FROM mysql.user;
Now set the root passwords
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('briansnelson');
SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('briansnelson');
SET PASSWORD FOR 'root'@'localhost.localdomain' = PASSWORD('briansnelson');
FLUSH PRIVILEGES;
