Difference between revisions of "How to install Percona Database Server"
From Brian Nelson Ramblings
(→Set root password=) |
(→Set root password) |
||
| 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:=== | ||
Revision as of 20:55, 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 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');
FLUSH PRIVILEGES;
