Difference between revisions of "How to install Percona Database Server"
From Brian Nelson Ramblings
(Created page with "==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 ...") |
(→Set root password) |
||
| (6 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 31: | 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=== | |
| − | * | + | 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:=== | ||
| + | |||
| + | * [[MySQL - Check Which Query is Consuming Resources]] | ||
| + | * [[Rest your MySQL Admin Password]] | ||
| + | * [[How to Convert Table to InnoDB]] | ||
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;
