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

From Brian Nelson Ramblings
Jump to: navigation, search
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 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');
  
 
===Additional Articles:===
 
===Additional Articles:===

Revision as of 20:53, 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 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');

Additional Articles: