Difference between revisions of "How to install Percona Database Server"

From Brian Nelson Ramblings
Jump to: navigation, search
(Set root password)
 
(3 intermediate revisions by the same user not shown)
Line 31: Line 31:
 
  Percona-Server-shared-51.x86_64        5.1.72-rel14.10.597.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
 
  Percona-Server-shared-55.x86_64        5.5.34-rel32.0.591.rhel6      percona
 +
 +
===Set root password===
 +
 +
Make sure to start Percona
 +
 +
service mysql 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;
  
 
===Additional Articles:===
 
===Additional Articles:===

Latest revision as of 21:37, 19 December 2013

Logo percona server new.png

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.

From http://www.percona.com

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 mysql 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;

Additional Articles: