Vagrant+AlmaLinuxで構築した開発環境にMySQL8をインストールする

$ dnf localinstall -y https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

$ dnf install -y @mysql:8.0

$ mysql --version
mysql Ver 8.0.21 for Linux on x86_64 (Source distribution)

$ systemctl start mysqld
$ systemctl enable mysqld

$ vi /etc/my.cnf
validate_password.policy=LOW

$ systemctl restart mysqld

$ mysql_secure_installation

Securing the MySQL server deployment.
Connecting to MySQL using a blank password.
The 'validate_password' component is installed on the server.
The subsequent steps will run with the existing configuration
of the component.
Please set the password for root here.

New password:

Re-enter new password:

Estimated strength of the password: 50y
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y

Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y

$ mysql -u root -p
Enter password:

> create database hoge_db; 
> create user 'user_name'@'localhost' identified by 'password';

> grant all on hoge_db.* to 'user_name'@'localhost' with grant option;
> flush privileges;