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;
Sidebar