Install Percona 8 on Rocky 9

Install percona server

Install Percona Server for MySQL from Percona RPM repository

$ sudo yum install <https://repo.percona.com/yum/percona-release-latest.noarch.rpm> 
$ sudo percona-release setup ps80 
$ sudo yum install percona-server-server

Update the root password

Post-installation

During an installation on Debian/Ubuntu, you are prompted to enter a root password. On Red Hat Enterprise Linux and derivatives, you update the root password after installation.

Restart the server with the --skip-grant-tables option to allow access without a password. This option is insecure. This option also disables remote connections.

$ sudo systemctl stop mysqld 
$ sudo systemctl set-environment MYSQLD_OPTS="--skip-grant-tables" 
$ sudo systemctl start mysqld 
$ mysql

Reload the grant tables to be able to run the ALTER USER statement. Enter a password that satisfies the current policy.

mysql> FLUSH PRIVILEGES; 
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'rootPassword_12'; 
mysql> exit

If, when adding the password, MySQL returns ERROR 1819 (HY000) Your password does not satisfy the current policy, run the following command to see policy requirement.

mysql> SHOW VARIABLES LIKE 'validate_password%';

Redo your password to satisfy the requirements. Stop the server, remove the — skip-grant-tables option, start the server, and log into the server with the updated password.

$ sudo systemctl stop mysqld 
$ sudo systemctl unset-environment MYSQLD_OPTS 
$ sudo systemctl start mysqld 
$ mysql -u root -p