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
[[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