Installing Percona Server on Centos 7

Percona server Is a MySQL build with XtraDB storage engine enabled by default. Differs from MySQL + InnoDB plugin in better performance / scalability, especially on modern multi-core servers.

Add the Percona repository and update

                      
                        [[email protected]]# yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
[[email protected]]# yum update
                      
                    

Install Percona-Server

                      
                        [[email protected]]# yum install Percona-Server-server-57
                      
                    

We start the service and add it to startup

                      
                        [[email protected]]# systemctl start mysqld
[[email protected]]# systemctl enable mysqld
                      
                    

We look at our password, which was generated automatically

                      
                        [[email protected]]# grep -i password /var/log/mysqld.log
2019-07-23T08:18:31.597730Z 1 [Note] A temporary password is generated for [email protected]: %password%
                      
                    

We change it. To do this, run the script, set a new password, and answer questions.

                      
                        [[email protected]]# mysql_secure_installation
                      
                    

We create a user in the database

Connecting to the mysql server

                      
                        [[email protected]]# mysql -u root -p
                      
                    

Create database “db_name”

                      
                        mysql> CREATE DATABASE db_name;
                      
                    

Create user “userdb_test” and assign a password to it

                      
                        mysql> CREATE USER 'userdb_test'@'localhost' IDENTIFIED BY 'Bv&ea5dfgvR72';
                      
                    

Assigning privileges to the base

                      
                        mysql> GRANT ALL PRIVILEGES ON db_name.* TO 'userdb_test'@'localhost';
                      
                    

Updating privileges

                      
                        mysql> FLUSH PRIVILEGES;
                      
                    

We leave

                      
                        mysql> exit;
                      
                    

Related Posts