RedHat系のLinuxにMySQL8.0をYumでインストール

uname -r

[rin@localhost ~]$ uname -r
4.18.0-372.32.1.el8_6.x86_64
[rin@localhost ~]$ 

wget https://dev.mysql.com/get/mysql80-community-release-el9-1.noarch.rpm
wget https://dev.mysql.com/get/mysql80-community-release-el8-4.noarch.rpm
wget https://dev.mysql.com/get/mysql80-community-release-el7-7.noarch.rpm
wget https://dev.mysql.com/get/mysql80-community-release-el6-7.noarch.rpm

 $ sudo yum localinstall https://dev.mysql.com/get/mysql80-community-release-el8-4.noarch.rpm

[rin@localhost ~]$ sudo yum localinstall https://dev.mysql.com/get/mysql80-community-release-el8-4.noarch.rpm
メタデータの期限切れの最終確認: 1:49:59 時間前の 2022年11月17日 07時57分42秒 に実施しました。
mysql80-community-release-el8-4.noarch.rpm                                                               37 kB/s |  14 kB     00:00    
依存関係が解決しました。
========================================================================================================================================
 パッケージ                                   アーキテクチャー          バージョン                リポジトリー                    サイズ
========================================================================================================================================
インストール:
 mysql80-community-release                    noarch                    el8-4                     @commandline                     14 k
トランザクションの概要
========================================================================================================================================
インストール  1 パッケージ
合計サイズ: 14 k
インストール後のサイズ: 8.6 k
これでよろしいですか? [y/N]: y
パッケージのダウンロード:
トランザクションの確認を実行中
トランザクションの確認に成功しました。
トランザクションのテストを実行中
トランザクションのテストに成功しました。
トランザクションを実行中
  準備             :                                                                                                                1/1 
  インストール中   : mysql80-community-release-el8-4.noarch                                                                         1/1 
  検証             : mysql80-community-release-el8-4.noarch                                                                         1/1 
インストール済み:
  mysql80-community-release-el8-4.noarch                                                                                                
完了しました!
[rin@localhost ~]$ 

$ sudo yum repolist all | grep mysql

[rin@localhost ~]$ sudo yum repolist all | grep mysql
mysql-cluster-8.0-community           MySQL Cluster 8.0 Community         無効化
mysql-cluster-8.0-community-debuginfo MySQL Cluster 8.0 Community - Debug 無効化
mysql-cluster-8.0-community-source    MySQL Cluster 8.0 Community - Sourc 無効化
mysql-connectors-community            MySQL Connectors Community          有効化
mysql-connectors-community-debuginfo  MySQL Connectors Community - Debugi 無効化
mysql-connectors-community-source     MySQL Connectors Community - Source 無効化
mysql-tools-community                 MySQL Tools Community               有効化
mysql-tools-community-debuginfo       MySQL Tools Community - Debuginfo   無効化
mysql-tools-community-source          MySQL Tools Community - Source      無効化
mysql-tools-preview                   MySQL Tools Preview                 無効化
mysql-tools-preview-source            MySQL Tools Preview - Source        無効化
mysql80-community                     MySQL 8.0 Community Server          有効化
mysql80-community-debuginfo           MySQL 8.0 Community Server - Debugi 無効化
mysql80-community-source              MySQL 8.0 Community Server - Source 無効化
[rin@localhost ~]$ 

$ sudo yum -y install yum-utils
$ sudo yum-config-manager --disable mysql57-community
$ sudo yum-config-manager --enable mysql80-community

 $ sudo yum repolist enabled | grep mysql

[rin@localhost ~]$  sudo yum repolist enabled | grep mysql
mysql-connectors-community              MySQL Connectors Community
mysql-tools-community                   MySQL Tools Community
mysql80-community                       MySQL 8.0 Community Server
[rin@localhost ~]$ 

$ sudo yum module disable mysql

$ sudo yum install mysql-community-server

$ sudo systemctl start  mysqld

$ sudo systemctl status  mysqld

[rin@localhost ~]$ sudo systemctl status  mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2022-11-17 10:05:44 JST; 7s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 13063 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 13141 (mysqld)
   Status: "Server is operational"
    Tasks: 39 (limit: 10822)
   Memory: 485.1M
   CGroup: /system.slice/mysqld.service
           └─13141 /usr/sbin/mysqld

11月 17 10:05:37 localhost.localdomain systemd[1]: Starting MySQL Server...
11月 17 10:05:44 localhost.localdomain systemd[1]: Started MySQL Server.
[rin@localhost ~]$ 

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

[rin@localhost ~]$ sudo grep 'temporary password' /var/log/mysqld.log
2022-11-17T01:05:40.726912Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: j4N*&/;sNtd9
[rin@localhost ~]$ 

$> mysql -uroot -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '新しいパスワード';

$ mysql_secure_installation

$ sudo systemctl enable mysqld

$ sudo reboot
$ sudo systemctl status mysqld

[rin@localhost ~]$ cat /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[rin@localhost ~]$ 

$ sudo vi /etc/my.cnf

[rin@localhost ~]$ cat /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
character-set-server=utf8mb4
default-storage-engine=InnoDB
max_allowed_packet=256M
transaction-isolation=READ-COMMITTED
[mysql]
default-character-set = utf8mb4
[mysqlcheck]

$ sudo systemctl restart mysqld

$ mysql -uroot -p

[rin@localhost ~]$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.31 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> 

CREATE DATABASE データベース名;

mysql> create database mysql80db;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| mysql80db          |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> 

CREATE USER ユーザー名@localhost IDENTIFIED BY 'パスワード';　 #サーバー内からのみアクセス可
CREATE USER ユーザー名@'%' IDENTIFIED BY 'パスワード'; #サーバー内及びネットワークからアクセス可

mysql> CREATE USER testuser@'%' IDENTIFIED BY 'Sssss@5632';
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE USER testuser@localhost IDENTIFIED BY 'Sssss@5632';
Query OK, 0 rows affected (0.01 sec)

mysql> 

GRANT all ON *.* TO 'ユーザー名'@'localhost';

mysql> GRANT all ON *.* TO 'testuser'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql>