RedHat系LinuxにMySQL5.7をYumでインストール

$ sudo yum remove mariadb-libs
$ sudo rm -rf /var/lib/mysql/

[suna@localhost ~]$ uname -r
3.10.0-1160.80.1.el7.x86_64
[suna@localhost ~]$ 

#Red Hat Enterprise Linux 9
https://dev.mysql.com/get/mysql80-community-release-el9-1.noarch.rpm
#Red Hat Enterprise Linux 8
wget https://dev.mysql.com/get/mysql80-community-release-el8-4.noarch.rpm
#Red Hat Enterprise Linux 7
wget https://dev.mysql.com/get/mysql80-community-release-el7-7.noarch.rpm
#Red Hat Enterprise Linux 6
wget https://dev.mysql.com/get/mysql80-community-release-el6-7.noarch.rpm

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

[suna@localhost ~]$ sudo yum localinstall https://dev.mysql.com/get/mysql80-community-release-el7-7.noarch.rpm
読み込んだプラグイン:fastestmirror, langpacks
mysql80-community-release-el7-7.noarch.rpm                                                   |  11 kB  00:00:00     
/var/tmp/yum-root-1R6qJ2/mysql80-community-release-el7-7.noarch.rpm を調べています: mysql80-community-release-el7-7.noarch
/var/tmp/yum-root-1R6qJ2/mysql80-community-release-el7-7.noarch.rpm をインストール済みとして設定しています
依存性の解決をしています
--> トランザクションの確認を実行しています。
---> パッケージ mysql80-community-release.noarch 0:el7-7 を インストール
--> 依存性解決を終了しました。
依存性を解決しました
====================================================================================================================
 Package                          アーキテクチャー
                                                バージョン     リポジトリー                                    容量
====================================================================================================================
インストール中:
 mysql80-community-release        noarch        el7-7          /mysql80-community-release-el7-7.noarch         10 k
トランザクションの要約
====================================================================================================================
インストール  1 パッケージ
合計容量: 10 k
インストール容量: 10 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
警告: RPMDB は yum 以外で変更されました。
  インストール中          : mysql80-community-release-el7-7.noarch                                              1/1 
  検証中                  : mysql80-community-release-el7-7.noarch                                              1/1 
インストール:
  mysql80-community-release.noarch 0:el7-7                                                                          
完了しました!
[suna@localhost ~]$ 

$ sudo yum repolist all | grep mysql

[suna@localhost ~]$ sudo yum repolist all | grep mysql
mysql-cluster-7.5-community/x86_64           MySQL Cluster 7.5 Comm 無効
mysql-cluster-7.5-community-source           MySQL Cluster 7.5 Comm 無効
mysql-cluster-7.6-community/x86_64           MySQL Cluster 7.6 Comm 無効
mysql-cluster-7.6-community-source           MySQL Cluster 7.6 Comm 無効
mysql-cluster-8.0-community/x86_64           MySQL Cluster 8.0 Comm 無効
mysql-cluster-8.0-community-debuginfo/x86_64 MySQL Cluster 8.0 Comm 無効
mysql-cluster-8.0-community-source           MySQL Cluster 8.0 Comm 無効
mysql-connectors-community/x86_64            MySQL Connectors Commu 有効:    206
mysql-connectors-community-debuginfo/x86_64  MySQL Connectors Commu 無効
mysql-connectors-community-source            MySQL Connectors Commu 無効
mysql-tools-community/x86_64                 MySQL Tools Community  有効:     94
mysql-tools-community-debuginfo/x86_64       MySQL Tools Community  無効
mysql-tools-community-source                 MySQL Tools Community  無効
mysql-tools-preview/x86_64                   MySQL Tools Preview    無効
mysql-tools-preview-source                   MySQL Tools Preview -  無効
mysql57-community/x86_64                     MySQL 5.7 Community Se 無効
mysql57-community-source                     MySQL 5.7 Community Se 無効
mysql80-community/x86_64                     MySQL 8.0 Community Se 有効:    367
mysql80-community-debuginfo/x86_64           MySQL 8.0 Community Se 無効
mysql80-community-source                     MySQL 8.0 Community Se 無効
[suna@localhost ~]$ 

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

[suna@localhost ~]$ sudo yum-config-manager --disable mysql80-community
読み込んだプラグイン:fastestmirror, langpacks
============================================= repo: mysql80-community ==============================================
[mysql80-community]
async = True
bandwidth = 0
base_persistdir = /var/lib/yum/repos/x86_64/7
baseurl = http://repo.mysql.com/yum/mysql-8.0-community/el/7/x86_64
cache = 0
cachedir = /var/cache/yum/x86_64/7/mysql80-community
check_config_file_age = True
compare_providers_priority = 80
cost = 1000
deltarpm_metadata_percentage = 100
deltarpm_percentage = 
enabled = 0
enablegroups = True
exclude = 
failovermethod = priority
ftp_disable_epsv = False
gpgcadir = /var/lib/yum/repos/x86_64/7/mysql80-community/gpgcadir
gpgcakey = 
gpgcheck = True
gpgdir = /var/lib/yum/repos/x86_64/7/mysql80-community/gpgdir
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022,
   file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
hdrdir = /var/cache/yum/x86_64/7/mysql80-community/headers
http_caching = all
includepkgs = 
ip_resolve = 
keepalive = True
keepcache = False
mddownloadpolicy = sqlite
mdpolicy = group:small
mediaid = 
metadata_expire = 21600
metadata_expire_filter = read-only:present
metalink = 
minrate = 0
mirrorlist = 
mirrorlist_expire = 86400
name = MySQL 8.0 Community Server
old_base_cache_dir = 
password = 
persistdir = /var/lib/yum/repos/x86_64/7/mysql80-community
pkgdir = /var/cache/yum/x86_64/7/mysql80-community/packages
proxy = False
proxy_dict = 
proxy_password = 
proxy_username = 
repo_gpgcheck = False
retries = 10
skip_if_unavailable = False
ssl_check_cert_permissions = True
sslcacert = 
sslclientcert = 
sslclientkey = 
sslverify = True
throttle = 0
timeout = 30.0
ui_id = mysql80-community/x86_64
ui_repoid_vars = releasever,
   basearch
username = 
[suna@localhost ~]$ sudo yum-config-manager --enable mysql57-community
読み込んだプラグイン:fastestmirror, langpacks
============================================= repo: mysql57-community ==============================================
[mysql57-community]
async = True
bandwidth = 0
base_persistdir = /var/lib/yum/repos/x86_64/7
baseurl = http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64
cache = 0
cachedir = /var/cache/yum/x86_64/7/mysql57-community
check_config_file_age = True
compare_providers_priority = 80
cost = 1000
deltarpm_metadata_percentage = 100
deltarpm_percentage = 
enabled = 1
enablegroups = True
exclude = 
failovermethod = priority
ftp_disable_epsv = False
gpgcadir = /var/lib/yum/repos/x86_64/7/mysql57-community/gpgcadir
gpgcakey = 
gpgcheck = True
gpgdir = /var/lib/yum/repos/x86_64/7/mysql57-community/gpgdir
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022,
   file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
hdrdir = /var/cache/yum/x86_64/7/mysql57-community/headers
http_caching = all
includepkgs = 
ip_resolve = 
keepalive = True
keepcache = False
mddownloadpolicy = sqlite
mdpolicy = group:small
mediaid = 
metadata_expire = 21600
metadata_expire_filter = read-only:present
metalink = 
minrate = 0
mirrorlist = 
mirrorlist_expire = 86400
name = MySQL 5.7 Community Server
old_base_cache_dir = 
password = 
persistdir = /var/lib/yum/repos/x86_64/7/mysql57-community
pkgdir = /var/cache/yum/x86_64/7/mysql57-community/packages
proxy = False
proxy_dict = 
proxy_password = 
proxy_username = 
repo_gpgcheck = False
retries = 10
skip_if_unavailable = False
ssl_check_cert_permissions = True
sslcacert = 
sslclientcert = 
sslclientkey = 
sslverify = True
throttle = 0
timeout = 30.0
ui_id = mysql57-community/x86_64
ui_repoid_vars = releasever,
   basearch
username = 

 $ sudo yum repolist enabled | grep mysql

[suna@localhost ~]$ sudo yum repolist enabled | grep mysql
mysql-connectors-community/x86_64       MySQL Connectors Community           206
mysql-tools-community/x86_64            MySQL Tools Community                 94
mysql57-community/x86_64                MySQL 5.7 Community Server           624
[suna@localhost ~]$ 

$ sudo yum module disable mysql

$ sudo yum install mysql-community-server

$ sudo systemctl start  mysqld

$ sudo systemctl status  mysqld

[suna@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 月 2022-11-14 19:38:13 JST; 1min 4s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 11534 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
  Process: 11462 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 11537 (mysqld)
    Tasks: 27
   CGroup: /system.slice/mysqld.service
           └─11537 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

11月 14 19:38:09 localhost.localdomain systemd[1]: Starting MySQL Server...
11月 14 19:38:13 localhost.localdomain systemd[1]: Started MySQL Server.
[suna@localhost ~]$ 

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

[suna@localhost ~]$ sudo grep 'temporary password' /var/log/mysqld.log
2022-11-14T10:38:10.697517Z 1 [Note] A temporary password is generated for root@localhost: Dpe*yyd5pV,V
[suna@localhost ~]$ 

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

$ mysql_secure_installation

$ sudo systemctl enable mysqld

$ sudo reboot
$ sudo systemctl status mysqld

[suna@localhost ~]$ cat /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/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 leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# 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
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[suna@localhost ~]$ 

$ sudo vi /etc/my.cnf

[suna@localhost etc]$ sudo cat /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/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 leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# 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
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
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]
default-character-set = utf8mb4
[mysqladmin]
default-character-set = utf8mb4
[client]
default-character-set = utf8mb4

$ sudo systemctl restart mysqld

$ mysql -uroot -p

[suna@localhost etc]$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 22
Server version: 5.7.40 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> 
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> 

CREATE DATABASE データベース名;

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

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

mysql> 

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

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