Difference between revisions of "How to install Percona Database Server"
From Brian Nelson Ramblings
(→Set root password) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 32: | Line 32: | ||
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 | + | ===Set root password=== |
Make sure to start Percona | Make sure to start Percona | ||
| − | service | + | service mysql start |
Log into mysql and check the users | Log into mysql and check the users | ||
| Line 49: | Line 49: | ||
SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('briansnelson'); | SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('briansnelson'); | ||
SET PASSWORD FOR 'root'@'localhost.localdomain' = 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
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 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;
