(2024.1) Percona Installation
- Brian Dixon
- Marty Goodrich
- Joel Duncan
Owned by Brian Dixon
Note: This page contains instructions for installing Percona with MySQL 8, or MySQL 5.7. Both Databases are supported by PCR-360, so please make sure to follow the instructions related to the version you are installing. MySQL 8 is the preferred installation option, as support for MySQL 5.7 will start to be replaced by MySQL 8.
Installing Percona MySQL 8 on Centos/Red Hat (Recommended for new installs)
#become root
sudo su
# remove any previous installs
service mysql stop
yum remove mysql-dev mysql-server mysql-libs Percona-Server*
#enable the repository
sudo percona-release setup ps80
On RedHat 8 systems it is needed to disable dnf mysql module to install Percona-Server
Do you want to disable it? [y/N] y
...
# remove an residual db info
rm -rf /var/lib/mysql
rm -f /etc/my.cnf
# install Percona repos
sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
# install percona server (and client)
sudo yum install percona-server-server
# start the server
service mysql start
# get the temp root password
grep -o "temporary password is generated for root@localhost.*" /var/log/mysqld.log | cut -f2- -d: | tail -1 | sed -e 's/^[[:space:]]*//'
# secure the installation
mysql_secure_installation -p
# restart the server
service mysql restartInstalling Percona MySQL 5.7
#become root
sudo su
# remove any previous installs
service mysql stop
yum remove mysql-dev mysql-server mysql-libs Percona-Server*
# remove an residual db info
rm -rf /var/lib/mysql
rm -f /etc/my.cnf
# install Percona repos
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm
# install percona server (and client)
yum install Percona-Server-server-57
# start the server
service mysql start
# get the temp root password
grep -o "temporary password is generated for root@localhost.*" /var/log/mysqld.log | cut -f2- -d: | tail -1 | sed -e 's/^[[:space:]]*//'
# secure the installation
mysql_secure_installation -p
# restart the server
service mysql restartSetting up the database
Log In to the Database as root
mysql -u root -p