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

From Brian Nelson Ramblings
Jump to: navigation, search
(→‎Testing the Percona Repo)
(→‎Set root password)
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
[[File:Logo percona server new.png|150px|frameless|right]]
 
==How to install Percona Database Server==
 
==How to install Percona Database Server==
  
Line 13: Line 14:
 
Now you can run  
 
Now you can run  
  
−
  yum install Percona-Server-server-56
+
  yum install Percona-Server-server-56 Percona-Server-client-56
  
 
This will install Percona's Server 5.6 package.
 
This will install Percona's Server 5.6 package.
Line 30: 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:

Retrieved from "https://briansnelson.com/index.php?title=How_to_install_Percona_Database_Server&oldid=289"