installing Mysql 8 community edition involve below steps

1.Add MySQL Repository package.
2. Install MySQL Community Server from the repository.
3. Enable MySQL server to auto-start.
4. Start MySQL server.
5 .Verify if MySQL is running.
Follow the steps in the provided link to add the repository and install MySQL.
click here

installing MySQL percona edition

Percona Server for MySQL indeed offers additional features and enhancements beyond what is available in the MySQL Community Edition. These additions are designed to improve performance, scalability, and manageability of MySQL databases. While Percona Server for MySQL aims to provide enterprise-level functionality, it remains an open-source solution, distinguishing itself from MySQL Enterprise Edition, which is proprietary software provided by Oracle.

installing percona MySQL edition

the first step is to add percona repo by using the below command

steps below are based on this link from official percona site

also you can use the following link for more deep steps

$ sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

We initiate the setup process by executing the following command:

sudo percona-release setup ps-80

final step is to starting the instalation

sudo yum install percona-server-server

note: there some dependency that are required such as perl
need to check you repo if it have this dependcay

post installation check

after the installation there are some additional steps which include enable daemon for mysql
and starting up daemon for MySQL

1.start and enable Mysql daemon
use the below to enable mysql daemon to start auto during OS boot

sudo systemctl enable mysqld.service

next start mysql daemon

sudo systemctl start mysqld.service

now final step is to check the status of mysql services make sure that they are running
systemctl status mysqld

2.VERIFICATION

last is to check and confirm that MySQL is processes are running

We’ll first utilize the pidof utility to check if the MySQL server process is running:

pidof mysqld

Next, we’ll utilize the netstat command to confirm that MySQL is listening for connections on port 3306
netstat -ntlp | grep 3306

Finally, we’ll employ the lsof command to inspect the files currently open by the MySQL server process:
sudo lsof -u mysql

configure root user

after the installation you to setup the root user so you will able to connect to MySQL
the steps involve 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

next we need to setup the password for root user to be able to connect normally from local host

also we need to reload grant tables to that we can run alter command

mysql> FLUSH PRIVILEGES;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Awersdfzxc.1';

now stop and run command to start MySQL in normal mode without option –skip-grant-tables

$ sudo systemctl stop mysqld 
$ sudo systemctl unset-environment MYSQLD_OPTS 
$ sudo systemctl start mysqld

now try to login to MySQL engin using the password you setup for root and it should connect normaly

mysql -u root -p

removing MySQL server

the steps are done as follow

1. remove MySQL related repo packages
2. remove all MySQL packages
3. remove MySQL user from OS
4. remove any left-over MySQL files
5. verfiyy MySQL is not persent at all on OS

STEP 1. SEARCH FOR REPOSITORY PACKAGES ⭐️

using rpm we will search for repo for MySQL , and using grepto filter for our target repo using unqaie pattern
rpm -qa | grep -i mysql

STEP 2. REMOVE REPO

we have located the full name of MySQL repo now we will use yum to remove the repo from repo list

sudo yum -y remove mysql80-community-release-el7-3.noarch

3. SEARCH FOR INSTALLED MYSQL PACKAGES

next steps is to locate all MySQL packages installed by using the below , this important as MySQL has a lot of packages installed other that MySQL community server .

using the below grep command will help locate all these packages.

rpm -qa | grep -i mysql

STEP 4. REMOVE MYSQL PACKAGES

now we will start by removing the packages using yum remove and then specifying the list of mysql we have found

 yum remove mysql-community-server-8.0.36-1.el8.x86_64 mysql-community-client-8.0.36-1.el8.x86_64 mys
ql-community-client-plugins-8.0.36-1.el8.x86_64 mysql-community-libs-8.0.36-1.el8.x86_64 mysql-community-icu-data-files-8.0.36-1.e
l8.x86_64 mysql80-community-release-el8-9.noarch mysql-community-common-8.0.36-1.el8.x86_64

STEP 5. REMOVE MYSQL USER

To remove the MySQL user that was added during the MySQL installation process, you can utilize the userdel command.
First, to verify if the MySQL user still exists within the operating system, the grep command can be used to search for the MySQL user in the passwd file. Once confirmed, you can proceed to delete the user. The userdel command facilitates this process. You have the option to run userdel followed by the username to initiate an interactive user deletion wizard.
Alternatively, for a more direct approach, you can use userdel -r [username] to not only delete the user but also remove their home directory and any assigned mailbox, if applicable. The -r option ensures that both the user’s home directory and their mailbox (if they have one) are deleted alongside the user account.

grep mysql /etc/passwd
sudo userdel
sudo userdel -r mysql

you can ignore the error regarding mail spool since MySQL don’t have mailbox

STEP 6. REMOVE OTHER LEFTOVER FILES

now we have remove MySQL packages and deleted the user , next steps is to remove all left over directory created by MySQL installation

normally there will be data directory located in /var/lib
and log file for MySQL located in /var/log
search for MySQL file using ls and if there is still some MySQL leftovers proceed with deleting these files
ls /var/lib ls /var/log

VERIFICATION

last steps is to confirm that we have successfully remove MySQL from the OS

while run the below command , nothing should popup for the below command

pidof mysqld netstat -ntlp | grep 3306 sudo lsof -u mysql

Installing Specific Version of MySQL

link for reference steps
When setting up a MySQL environment, particularly for testing purposes, it’s important for database administrators (DBAs) to often install specific versions of MySQL to ensure compatibility with applications. In your scenario, you’re looking to install MySQL version 8.0.26-16.1. Here’s a streamlined guide on how to do this, with an emphasis on downloading the correct version from Percona, as Percona offers optimized versions of MySQL

1. Visit Percona’s Downloads Section: Start by navigating to Percona’s official downloads page. You can reach it by following this link: Percona Downloads.
2. Select the MySQL Version: Once on the downloads page, you’ll need to find the MySQL server version you’re interested in, which is MySQL 8.0.26-16.1 in this case. Keep in mind that navigating the Percona website might require you to select not just the version but also the specific distribution and OS you are using, such as Ubuntu, Debian, CentOS, etc.
   
3. Download the Repository Package: Percona packages its releases in repository packages. You’ll need to download the repository package suitable for your operating system. This might involve selecting your OS version and then downloading a .deb package for Debian-based systems like Ubuntu, or a .rpm package for Red Hat-based systems like CentOS.
   you can use wget to download the repo directly on OS
   wget https://downloads.percona.com/downloads/Percona-Server-8.0/Percona-Server-8.0.16-7/binary/redhat/8/x 86_64/Percona-Server-8.0.16-7-r613e312-el8-x86_64-bundle.tar

one done extract the package and using tar
tar -xvf yourfile.tar

4. Install the Repository Package: Once the repository package is downloaded, you will need to install it. This step varies depending on your OS. For Debian-based systems, you’d use dpkg to install a .deb file, and for Red Hat-based systems, you’d use rpm to install a .rpm file.
   to speed up the process setup a variable with the version you required

version=8.0.26-16.1 echo $version

sudo yum install percona-mysql-router-$version.x86_64
sudo yum install mysql-community-client-$version.x86_64

Performing MySQL Secure Installation

Securing a fresh MySQL installation is crucial, and this can be accomplished by running the mysql_secure_installation script. This utility is designed to enhance the security of MySQL in several key ways:

• It is executed exclusively by the root user to ensure administrative privileges.
• The script significantly boosts MySQL’s security by prompting you to set a password for the root account, thereby safeguarding it.
• It prevents the root user from logging in remotely, adding an extra layer of protection.
• The script also removes anonymous users, eliminating potential unauthorized access points.
• It deletes the default test database, which is created during the MySQL installation process, to prevent unintended access.
• Lastly, the script immediately reloads privilege settings, applying these security enhancements without delay to the MySQL environment.
  reference details steps

access the root password

To initiate the mysql_secure_installation process, it’s necessary to obtain the temporary root password generated during the MySQL installation. This password can be found in the /var/log/mysqld.log file. By employing the grep command, you can efficiently filter the contents of this file to exclusively display the root password, using the following command:

sudo grep 'password' /var/log/mysqld.log

This command searches the specified log file for any lines containing the word “password,” effectively isolating and revealing the temporary root password required for proceeding with the secure installation script.

RUN MYSQL_SECURE_INSTALLATION SCRIPT

Next, proceed by executing the mysql_secure_installation command and respond to the prompts as previously outlined. The script will request the root password, which you’ve retrieved from the mysqld.log file.

https://www.dragonflydb.io/faq/postgres-delete-cluster