Share via
Post Views. 4.644
Pembaca yang budiman,
Dalam artikel ini, kita akan melihat berikut MySQL Upgrade dari 5. 6 sampai 5. 7.
1. Masuk ke Akun AWS
Pertama, kita perlu halaman Konsol AWS dengan menggunakan tautan di bawah ini
https. //aw. amazon. com/konsol/
Klik tombol masuk ke Konsol .
Masuk ke akun aws
Masuk menggunakan nama pengguna & sandi dan klik masuk .
Masuk ke AWS Management Console
We can see the AWS Management Console Dashboard
Buka Layanan, di bawah modul komputasi, klik EC2 layanan untuk membuka.
Buka Layanan, di bawah modul komputasi, klik EC2 layanan untuk membuka.
Kami dapat meluncurkan Windows Server dengan menggunakan tautan di bawah ini
Luncurkan Instans EC2 Linux
Kita dapat melihat server windows telah berhasil diluncurkan
Kami dapat menghubungkan dempul dengan menggunakan tautan di bawah ini
Hubungkan ke Server MySQL Menggunakan Putty
1
2
3
masuk sebagai. ec2-pengguna
Mengotentikasi dengan public key "imported-openssh-
[ec2-pengguna@ip-172-31-41-179 ~]$
4. Beralih ke pengguna root1
2
[ec2-pengguna@ip-172-31-41-7 ~]$ sudo su
[akar@ip-172-31-41-7 ec2-user]#
5. Instal pembaruan Server1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
[akar@ip-172-31-41-7 ec2-user]# yum update -y
Merah Topi Perbarui Infrastruktur 3 Client Configuration Server 8 14 kB/s | 3. 5 kB 00. 00
Merah Topi Perusahaan Linux 8 for x86_64 - AppStream from RHUI (RPMs) 39 MB/s | 25 MB 00. 00
Merah Topi Perusahaan Linux 8 for x86_64 - BaseOS from RHUI (RPMs) 43 MB/s | 26 MB 00. 00
Dependensi diselesaikan.
==============================================================================================================================================================================================================
paket arsitektur versi repositori Size
==============================================================================================================================================================================================================
Memasang.
kernel x86_ 64 4.18.0-240. 8. 1. el8_3 rhel-8- . 3baseos-rhui-rpms 4.3 M
kernel-inti x86_64 4.18.0-240. 8. 1. el8_3 rhel-8-baseos-rhui-rpms 30 M
kernel-modul x86_64 4.18.0-240. 8. 1. el8_3 rhel-8-baseos-rhui-rpms 26 M
Meningkatkan.
NetworkManager x86_ 64 1:1. 26. 0-12. el8_3 rhel-8- . 4baseos-rhui-rpms 2.4 M
NetworkManager-libnm x86_64 1:1. 26. 0-12. el8_3 rhel-8- . 8baseos-rhui-rpms 1.8 M
NetworkManager-tim x86_64 1:1. 26. 0-12. el8_3 rhel-8-baseos-rhui-rpms 142 k
NetworkManager-tui x86_64 1:1. 26. 0-12. el8_3 rhel-8-baseos-rhui-rpms 320 k
awan-init noarch 19.4-11. el8_3. 1 rhel-8-appstream-rhui-rpms 945 k
ikal x86_ 64 7.61.1-14. el8_3. 1 rhel-8-baseos-rhui-rpms 353 k
jenis bebas x86_ 64 2.9.1-4. el8_3. 1 rhel-8-baseos-rhui-rpms 394 k
gnutls x86_ 64 3.6.14-7. el8_3 rhel-8- . 0baseos-rhui-rpms 1.0 M
wawasan-klien noarch 3.1.1-1. el8_3 rhel-8- . 0appstream-rhui-rpms 1.0 M
iptables-libs x86_64 1.8.4-15. el8_3. 3 rhel-8-baseos-rhui-rpms 106 k
kernel-alat x86_64 4.18.0-240. 8. 1. el8_3 rhel-8- . 5baseos-rhui-rpms 4.5 M
kernel-alat-libs x86_64 4.18.0-240. 8. 1. el8_3 rhel-8-baseos-rhui-rpms 4. 3 M
kexec-tools x86_ 64 2. 0. 20-34. el8_3. 1 rhel-8-baseos-rhui-rpms 496 k
libcurl x86_ 64 7.61.1-14. el8_3. 1 rhel-8-baseos-rhui-rpms 299 k
microcode_ctl x86_ 64 4. 20200609-2. 20201112. 1. el8_3 rhel-8-baseos-rhui-rpms 4. 6 M
openssl x86_ 64 1. 1. 1. 1g-12. el8_3 rhel-8-baseos-rhui-rpms 707 k
openssl-libs x86_ 64 1. 1. 1. 1g-12. el8_3 rhel-8-baseos-rhui-rpms 1. 5 M
python3-perf x86_ 64 4. 18. 0-240. 8. 1. el8_3 rhel-8-baseos-rhui-rpms 4. 4 M
qemu-guest-agent x86_ 64 15. 4. 2. 0-34. module+el8. 3. 0+8829+e7a0a3ea. 1 rhel-8-appstream-rhui-rpms 228 k
systemd x86_ 64 239-41. el8_3. 1 rhel-8-baseos-rhui-rpms 3. 5 M
systemd-libs x86_ 64 239-41. el8_3. 1 rhel-8-baseos-rhui-rpms 1. 1 M
systemd-pam x86_ 64 239-41. el8_3. 1 rhel-8-baseos-rhui-rpms 456 k
systemd-udev x86_ 64 239-41. el8_3. 1 rhel-8-baseos-rhui-rpms 1. 3 M
tuned noarch 2. 14. 0-3. el8_3. 1 rhel-8-baseos-rhui-rpms 292 k
Installing dependencies.
linux-firmware noarch 20200619-101. git3890db36. el8_3 rhel-8-baseos-rhui-rpms 101 M
Transaksi Ringkasan
==============================================================================================================================================================================================================
Instal 4 Paket
Tingkatkan 24 Paket
Total unduh ukuran. 198 M
Mengunduh Paket.
(1/28): kernel-4. 18. 0-240. 8. 1. el8_3. x86_64. rpm 15 mb / s . | 4. 3 MB 00. 00
(2/28): kernel-inti-4. 18. 0-240. 8. 1. el8_3. x86_64. rpm 33 mb / s . | 30 MB 00. 00
(3/28): kernel-modul-4. 18. 0-240. 8. 1. el8_3. x86_64. rpm 22 mb / s . | 26 MB 00. 01
(4/28): awan-init-19. 4-11. el8_3. 1. noarch. RPM 3. 6 MB/s . 945 kB 00. 00
(5/28): qemu-tamu-agen . 2. 0-4.2.0-34. modul+el8. 3. 0+8829+e7a0a3ea. 1. x86_64. rpm 1. 9 MB/s . 228 kB 00. 00
(6/28): wawasan-klien-3. 1. 1-1. el8_3. noarch. rpm > 6.8 MB/s . 1. 0 MB 00. 00
(7/28): NetworkManager-tim-1. 26. 0-12. el8_3. x86_64. rpm > 1.3 MB/s . 142 kB 00. 00
(8/28): jenis bebas-2. 9. 1-4. el8_3. 1. x86_64. RPM 3. 1 MB/s . 394 kB 00. 00
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 64 mb /s | 198 MB 00. 03
Menjalankan transaksi periksa
Transaksi centang berhasil.
Menjalankan transaksi tes
Transaksi test berhasil.
Menjalankan transaksi
Mempersiapkan . 1 / 1
Menjalankan scriptlet. systemd-lib-239 . el8_3. 1. x86_64 -41.el8_3.1.x86_64 1 / 1
Meningkatkan versi . systemd-lib-239 . el8_3. 1. x86_64 -41.el8_3.1.x86_64 1 / 52
Menjalankan scriptlet. systemd-lib-239 . el8_3. 1. x86_64 -41.el8_3.1.x86_64 1 / 52
Meningkatkan versi . gnutl-3. 6. 14-7. el8_3. x86_64 2 / 52
Meningkatkan versi . openssl-lib-1 . :1. 1. 1g-12. el8_3. x86_64 3 / 52
Menjalankan scriptlet. openssl-libs-1. 1. 1. 1g-12. el8_3. x86_64 3 / 52
Meningkatkan versi . libcurl-7. 61. 1-14. el8_3. 1. x86_64 4 / 52
Meningkatkan versi . NetworkManager-libnm-1 . :1. 26. 0-12. el8_3. x86_64 5 / 52
Menjalankan scriptlet. NetworkManager-libnm-1 . :1. 26. 0-12. el8_3. x86_64 5 / 52
Meningkatkan versi . iptables-libs-1. 8. 4-15. el8_3. 3. x86_64 6 / 52
Menjalankan scriptlet. sistemd-239-41. el8_3. 1. x86_64 7 / 52
Meningkatkan versi . sistemd-239-41. el8_3. 1. x86_64 7 / 52
Menjalankan scriptlet. sistemd-239-41. el8_3. 1. x86_64 7 / 52
Meningkatkan versi . systemd-pam-239 . el8_3. 1. x86_64 -41.el8_3.1.x86_64 8 / 52
Memverifikasi . kernel-modul-4. 18. 0-240. 8. 1. el8_3. x86_64 1 / 52
Memverifikasi . kernel-inti-4. 18. 0-240. 8. 1. el8_3. x86_64 2 / 52
Memverifikasi . kernel-4. 18. 0-240. 8. 1. el8_3. x86_64 3 / 52
Verifying . linux-firmware-20200619 . git3890db36. el8_3. noarch -101.git3890db36.el8_3.noarch 4 / 52
Memverifikasi . awan-init-19. 4-11. el8_3. 1. Noarch 5 / 52
Memverifikasi . awan-init-19. 4-11. el8. noarch 6 / 52
Memverifikasi . wawasan-klien-3. 1. 1-1. el8_3. Noarch 7 / 52
Memverifikasi . wawasan-klien-3. 1. 0-3. el8. noarch 8 / 52
Ditingkatkan.
Pengelola Jaringan-1. 1. 26. 0-12. el8_3. x86_64 Pengelola Jaringan-libnm- . 1:1. 26. 0-12. el8_3. x86_64 Pengelola Jaringan-tim- . 1:1. 26. 0-12. el8_3. x86_64 Pengelola Jaringan-tui- . 1:1. 26. 0-12. el8_3. x86_64
awan-init-19.4-11. el8_3. 1. noarch ikal-7. 61. 1-14. el8_3. 1. x86_64 jenis bebas-2. 9. 1-4. el8_3. 1. x86_64 gnutl-3. 6. 14-7. el8_3. x86_64
wawasan-klien-3.1.1-1. el8_3. noarch iptables-libs- . 8. 41.8.4-15. el8_3. 3. x86_64 kernel-alat- . 18. 04.18.0-240. 8. 1. el8_3. x86_64 kernel-alat- . 18. 0libs-4.18.0-240. 8. 1. el8_3. x86_64
kexec-alat-2.0.20-34. el8_3. 1. x86_64 libcurl-7. 61. 1-14. el8_3. 1. x86_64 microcode_ctl-4. 20200609-2. 20201112. 1. el8_3. x86_64 openssl-1. 1. 1. 1g-12. el8_3. x86_64
openssl-lib-1:1. 1. 1g-12. el8_3. x86_64 python3-sempurna- . 18. 04.18.0-240. 8. 1. el8_3. x86_64 qemu-tamu- . agent-15:4. 2. 0-34. modul+el8. 3. 0+8829+e7a0a3ea. 1. x86_64 sistemd-239- . el8_3. 1. x86_6441.el8_3.1.x86_64
systemd-libs-239-41. el8_3. 1. x86_64 systemd-pam- . el8_3. 1. x86_64239-41.el8_3.1.x86_64 systemd-udev- . el8_3. 1. x86_64239-41.el8_3.1.x86_64 disetel-2. 14. 0-3. el8_3. 1. noarch
Terpasang.
kernel-4. 18. 0-240. 8. 1. el8_3. x86_64 kernel-inti- . 18. 04.18.0-240. 8. 1. el8_3. x86_64 kernel-modul- . 18. 04.18.0-240. 8. 1. el8_3. x86_64 linux-firmware- . git3890db36. el8_3. noarch20200619-101.git3890db36.el8_3.noarch
Lengkap.
6. Instal paket wget1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
[akar@ip-172-31-41-7 ec2-user]# yum install wget -y
Terakhir metadata kedaluwarsa periksa. 0. 04. 39 lalu pada Senin 28 . Dec 2020 08:06. 57 AM UTC.
Dependensi diselesaikan.
==============================================================================================================================================================================================================
paket arsitektur versi repositori Size
==============================================================================================================================================================================================================
Memasang.
wget x86_ 64 1.19.5-10. el8 rhel-8-appstream-rhui-rpms 734 k
Transaksi Ringkasan
==============================================================================================================================================================================================================
Instal 1 Paket
Total unduh ukuran. 734 k
Ukuran Terpasang. 2. 8 M
Mengunduh Paket.
wget-1. 19. 5-10. el8. x86_64. RPM 5. 0 MB/s . 734 kB 00. 00
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 3. 9 MB/s . 734 kB 00. 00
Menjalankan transaksi periksa
Transaksi centang berhasil.
Menjalankan transaksi tes
Transaksi test berhasil.
Menjalankan transaksi
Mempersiapkan . 1 / 1
Memasang . wget-1. 19. 5-10. el8. x86_64 1 / 1
Menjalankan scriptlet. wget-1. 19. 5-10. el8. x86_64 1 / 1
Memverifikasi . wget-1. 19. 5-10. el8. x86_64 1/1
Terpasang.
wget-1. 19. 5-10. el8. x86_64
Lengkap.
6. Install MySQL 5. 6We can install MySQL 5. 6 by using below link
Install MySQL 5. 6
7. Upgrade MySQL from 5. 6 to 5. 7Check the Status of MySQL1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
[root@ip-172-31-41-7 ec2-user]# service mysqld start
Redirecting to /bin/systemctl start mysqld. service
[root@ip-172-31-41-7 ec2-user]# service mysqld status
Redirecting to /bin/systemctl status mysqld. service
● mysqld. service - MySQL Community Server
Loaded. loaded (/usr/lib/systemd/system/mysqld. service; enabled; vendor preset. disabled)
Active. active (running) since Mon 2020-12-28 08. 22. 56 UTC; 4s ago
Process. 58906 ExecStartPost=/usr/bin/mysql-systemd-start post (code=exited, status=0/SUCCESS)
Process. 58846 ExecStartPre=/usr/bin/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID. 58905 (mysqld_safe)
Tasks. 23 (limit. 4836)
Memory. 493. 3M
CGroup. /system. slice/mysqld. service
├─ 58905 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─ 59080 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mysqld. log --pid-file=/var/run/mysqld/mysqld. pid --socket=/var/lib/mysq>
Stop the Service of MySQL 5. 61
2
[root@ip-172-31-41-7 ec2-user]# service mysqld stop
Redirecting to /bin/systemctl stop mysqld. service
Check the Status of MySQL1
2
3
4
5
6
7
8
9
10
11
12
13
14
[root@ip-172-31-41-7 ec2-user]# service mysqld status
Redirecting to /bin/systemctl status mysqld. service
● mysqld. service - MySQL Community Server
Loaded. loaded (/usr/lib/systemd/system/mysqld. service; enabled; vendor preset. disabled)
Active. inactive (dead) since Mon 2020-12-28 08. 32. 29 UTC; 2s ago
Process. 59177 ExecStartPost=/usr/bin/mysql-systemd-start post (code=exited, status=0/SUCCESS)
Process. 59176 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
Process. 59164 ExecStartPre=/usr/bin/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID. 59176 (code=exited, status=0/SUCCESS)
Dec 28 08. 26. 58 ip-172-31-41-7. ap-south-1. compute. internal systemd[1]. Starting MySQL Community Server. . .
Dec 28 08. 26. 58 ip-172-31-41-7. ap-south-1. compute. internal mysqld_safe[59176]. 201228 08. 26. 58 mysqld_safe Logging to '/var/log/mysqld. log'.
Dec 28 08. 26. 58 ip-172-31-41-7. ap-south-1. compute. internal mysqld_safe[59176]. 201228 08. 26. 58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Dec 28 08. 26. 59 ip-172-31-41-7. ap-south-1. compute. internal systemd[1]. Started MySQL Community Server.
Take Backup of MySQL Database 5. 61
2
3
4
5
6
7
8
9
10
11
12
13
[root@ip-172-31-41-7 ec2-user]# cp -r /var/lib/mysql /tmp
[root@ip-172-31-41-7 ec2-user]# cd /tmp
[root@ip-172-31-41-7 tmp]# ls
mysql systemd-private-573e2cde6da64d8d896e39e7124b0a7e-chronyd. service-qrjFEf
[root@ip-172-31-41-7 tmp]# cd mysql/
[akar@ip-172-31-41-7 mysql]# ll
total 110604
-rw-r-----. 1 root root 56 Dec 28 08. 35 auto. cnf
-rw-r-----. 1 root root 12582912 Dec 28 08. 35 ibdata1
-rw-r-----. 1 root root 50331648 Dec 28 08. 35 ib_logfile0
-rw-r-----. 1 root root 50331648 Dec 28 08. 35 ib_logfile1
drwx------. 2 root root 4096 Dec 28 08. 35 mysql
drwx------. 2 root root 4096 Dec 28 08. 35 performance_schema
Remove Binaries of MySQL 5. 61
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
[root@ip-172-31-41-7 ec2-user]# yum remove mysql-community-server*
Dependensi diselesaikan.
==============================================================================================================================================================================================================
Package Architecture Version Repository Size
==============================================================================================================================================================================================================
Removing.
mysql-community-server x86_ 64 5. 6. 50-2. el7 @mysql56-community 268 M
Removing unused dependencies.
libaio x86_ 64 0. 3. 112-1. el8 @rhel-8-baseos-rhui-rpms 93 k
mysql-community-client x86_ 64 5. 6. 50-2. el7 @mysql56-community 83 M
mysql-community-common x86_ 64 5. 6. 50-2. el7 @mysql56-community 2. 3 M
mysql-community-libs x86_ 64 5. 6. 50-2. el7 @mysql56-community 9. 1 M
ncurses-compat-libs x86_ 64 6. 1-7. 20180224. el8 @rhel-8-baseos-rhui-rpms 1. 2 M
perl-Carp noarch 1. 42-396. el8 @rhel-8-baseos-rhui-rpms 41 k
perl-DBI x86_ 64 1. 641-3. module+el8. 3. 0+6481+fbe55708 @rhel-8-appstream-rhui-rpms 1. 8 M
perl-Data-Dumper x86_ 64 2. 167-399. el8 @rhel-8-baseos-rhui-rpms 104 k
perl-Digest noarch 1. 17-395. el8 @rhel-8-appstream-rhui-rpms 26 k
perl-Digest-MD5 x86_ 64 2. 55-396. el8 @rhel-8-appstream-rhui-rpms 55 k
perl-Enkode x86_64 4:2. 97-3. el8 @rhel-8-baseos-rhui-rpms 9. 7 M
perl-Errno x86_ 64 1. 28-416. el8 @rhel-8-baseos-rhui-rpms 9. 3 k
perl-Exporter noarch 5. 72-396. el8 @rhel-8-baseos-rhui-rpms 54 k
Transaksi Ringkasan
==============================================================================================================================================================================================================
Remove 50 Packages
Freed space. 401 M
Is this ok [y/N]. y
Menjalankan transaksi periksa
Transaksi centang berhasil.
Menjalankan transaksi tes
Transaksi test berhasil.
Menjalankan transaksi
Mempersiapkan . 1 / 1
Running scriptlet. mysql-community-server-5. 6. 50-2. el7. x86_64 1/1
Running scriptlet. mysql-community-server-5. 6. 50-2. el7. x86_64 1/50
Erasing . mysql-community-server-5. 6. 50-2. el7. x86_64 1 / 50
Running scriptlet. mysql-community-server-5. 6. 50-2. el7. x86_64 1/50
Erasing . perl-DBI-1. 641-3. module+el8. 3. 0+6481+fbe55708. x86_ 64 2/50
Erasing . perl-Math-BigInt-1. 1. 9998. 11-7. el8. noarch 3/50
Erasing . mysql-community-client-5. 6. 50-2. el7. x86_64 4/50
Menghapus . perl-libnet-3. 11-3. el8. noarch 5/50
Erasing . perl-URI-1. 73-3. el8. noarch 6/50
Erasing . perl-IO-Socket-SSL-2. 066-4. module+el8. 3. 0+6446+594cad75. noarch 7/50
Erasing . perl-HTTP-Tiny-0. 074-1. el8. noarch 8/50
Verifying . libaio-0. 3. 112-1. el8. x86_64 1/50
Verifying . mysql-community-client-5. 6. 50-2. el7. x86_64 2/50
Verifying . mysql-community-common-5. 6. 50-2. el7. x86_64 3/50
Verifying . mysql-komunitas-libs . 6. 50-5.6.50-2. el7. x86_64 4/50
Verifying . mysql-community-server-5. 6. 50-2. el7. x86_64 5/50
Verifying . ncurses-compat-libs-6. 1-7. 20180224. el8. x86_64 6/50
Verifying . perl-Carp-1. 42-396. el8. noarch 7/50
Verifying . perl-DBI-1. 641-3. module+el8. 3. 0+6481+fbe55708. x86_ 64 8/50
Removed.
libaio-0. 3. 112-1. el8. x86_64 mysql-community-client-5. 6. 50-2. el7. x86_64 mysql-community-common-5. 6. 50-2. el7. x86_64
mysql-community-libs-5. 6. 50-2. el7. x86_64 mysql-community-server-5. 6. 50-2. el7. x86_64 ncurses-compat-libs-6. 1-7. 20180224. el8. x86_64
perl-Carp-1. 42-396. el8. noarch perl-DBI-1. 641-3. module+el8. 3. 0+6481+fbe55708. x86_64 perl-Data-Dumper-2. 167-399. el8. x86_64
perl-Digest-1. 17-395. el8. noarch perl-Digest-MD5-2. 55-396. el8. x86_64 perl-Enkode- . 4:2. 97-3. el8. x86_64
perl-Errno-1. 28-416. el8. x86_64 perl-Exporter-5. 72-396. el8. noarch perl-File-Path-2. 15-2. el8. noarch
perl-File-Temp-0. 230. 600-1. el8. noarch perl-Getopt-Long-1. 2. 50-4. el8. noarch perl-HTTP-Tiny-0. 074-1. el8. noarch
perl-IO-1. 38-416. el8. x86_64 perl-IO-Socket-IP-0. 39-5. el8. noarch perl-IO-Socket-SSL-2. 066-4. module+el8. 3. 0+6446+594cad75. noarch
perl-MIME-Base64-3. 15-396. el8. x86_64 perl-Math-BigInt-1. 1. 9998. 11-7. el8. noarch perl-Math-Complex-1. 59-416. el8. noarch
perl-Mozilla-CA-20160104-7. modul+el8. 3. 0+6498+9eecfe51. noarch perl-Net-SSLeay-1. 88-1. module+el8. 3. 0+6446+594cad75. x86_64 perl-PathTools-3. 74-1. el8. x86_64
perl-Pod-Escapes-1. 1. 07-395. el8. noarch perl-Pod-Perldoc-3. 28-396. el8. noarch perl-Pod-Simple-1. 3. 35-395. el8. noarch
perl-Pod-Usage-4. 1. 69-395. el8. noarch perl-Scalar-List-Utils-3. 1. 49-2. el8. x86_64 perl-Socket-4. 2. 027-3. el8. x86_64
perl-Storable-1. 3. 11-3. el8. x86_64 perl-Term-ANSIColor-4. 06-396. el8. noarch perl-Term-Cap-1. 17-395. el8. noarch
perl-Text-ParseWords-3. 30-395. el8. noarch perl-Teks- . 0523Tabs+Wrap-2013.0523-395. el8. noarch perl-Time-Local-1. 1. 280-1. el8. noarch
perl-URI-1. 73-3. el8. noarch perl-Unicode- . 25Normalize-1.25-396. el8. x86_64 perl-constant-1. 33-396. el8. noarch
perl-interpreter-4. 5. 26. 3-416. el8. x86_64 perl-libnet-3. 11-3. el8. noarch perl-libs-4. 5. 26. 3-416. el8. x86_64
perl-macros-4. 5. 26. 3-416. el8. x86_64 perl-parent-1. 0. 237-1. el8. noarch perl-podlators-4. 11-1. el8. noarch
perl-threads-1. 2. 21-2. el8. x86_64 perl-threads-shared-1. 58-2. el8. x86_64
Lengkap.
Download Binaries of MySQL 5. 7 (RPM)1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
[root@ip-172-31-41-7 ec2-user]# wget https. //dev. mysql. com/get/mysql57-community-release-el7-9. noarch. rpm
--2020-12-28 08. 38. 59-- https. //dev. mysql. com/get/mysql57-community-release-el7-9. noarch. rpm
Resolving dev. mysql. com (dev. mysql. com). . . 137. 254. 60. 11
Connecting to dev. mysql. com (dev. mysql. com). 137. 254. 60. 11. . 443. connected.
HTTP request sent, awaiting response. . . 302 Found
Location. https. //repo. mysql. com//mysql57-community-release-el7-9. noarch. rpm [following]
--2020-12-28 08. 39. 00-- https. //repo. mysql. com//mysql57-community-release-el7-9. noarch. rpm
Resolving repo. mysql. com (repo. mysql. com). . . 104. 120. 171. 24
Connecting to repo. mysql. com (repo. mysql. com). 104. 120. 171. 24. . 443. connected.
HTTP request sent, awaiting response. . . 200 OK
Length. 9224 (9. 0K) [application/x-redhat-package-manager]
Saving to. ‘ mysql57-community-release-el7-9. noarch. rpm ’
mysql57-community-release-el7-9. noarch. rpm 100%[=================================================================================================================>] 9. 01K --. -KB/s in 0s
2020-12-28 08. 39. 00 (193 MB/s) - ‘ mysql57-community-release-el7-9. noarch. rpm ’ saved [9224/9224]
[root@ip-172-31-41-7 ec2-user]# ll
total 20
-rw-r--r--. 1 root root 9224 Sep 12 2016 mysql57-community-release-el7-9. noarch. rpm
-rw-r--r--. 1 root root 6140 Nov 12 2015 mysql-community-release-el7-5. noarch. rpm
Install Binareis of MySQL 5. 7 (RPM)1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
[root@ip-172-31-41-7 ec2-user]# yum localinstall mysql57-community-release-el7-9. noarch. rpm --allowerasing
Last metadata expiration check. 0. 23. 49 ago on Mon 28 Dec 2020 08. 18. 00 AM UTC.
Dependensi diselesaikan.
==============================================================================================================================================================================================================
Package Architecture Version Repository Size
==============================================================================================================================================================================================================
Memasang.
mysql57-community-release noarch el7-9 @commandline 9. 0 k
Removing dependent packages.
mysql-community-release noarch el7-5 @System 4. 3 k
Transaksi Ringkasan
==============================================================================================================================================================================================================
Instal 1 Paket
Remove 1 Package
Total size. 9. 0 k
Is this ok [y/N]. y
Mengunduh Paket.
Menjalankan transaksi periksa
Transaksi centang berhasil.
Menjalankan transaksi tes
Transaksi test berhasil.
Menjalankan transaksi
Mempersiapkan . 1 / 1
Installing . mysql57-community-release-el7-9. noarch 1/2
Erasing . mysql-community-release-el7-5. noarch 2/2
Verifying . mysql57-komunitas-rilis . noarch-el7-9.noarch 1/2
Verifying . mysql-community-release-el7-5. noarch 2/2
Terpasang.
mysql57-community-release-el7-9. noarch
Lengkap.
Install MySQL 5. 71
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
[root@ip-172-31-41-7 ec2-user]# yum -y install mysql-community-server
MySQL 5. 7 Community Server 9. 5 MB/s . 2. 0 MB 00. 00
Last metadata expiration check. 0. 00. 01 ago on Mon 28 Dec 2020 08. 42. 27 AM UTC.
Dependensi diselesaikan.
==============================================================================================================================================================================================================
Package Architecture Version Repository Size
==============================================================================================================================================================================================================
Memasang.
mysql-community-server x86_ 64 5. 7. 32-1. el7 mysql57-community 173 M
Installing dependencies.
libaio x86_ 64 0. 3. 112-1. el8 rhel-8-baseos-rhui-rpms 33 k
mysql-community-client x86_ 64 5. 7. 32-1. el7 mysql57-community 25 M
mysql-community-common x86_ 64 5. 7. 32-1. el7 mysql57-community 308 k
mysql-community-libs x86_ 64 5. 7. 32-1. el7 mysql57-community 2. 3 M
ncurses-compat-libs x86_ 64 6. 1-7. 20180224. el8 rhel-8-baseos-rhui-rpms 331 k
perl-Ikan mas noarch 1.42-396. el8 rhel-8-baseos-rhui-rpms 30 k
perl-Data-Dumper x86_ 64 2. 167-399. el8 rhel-8-baseos-rhui-rpms 58 k
perl-Digest noarch 1. 17-395. el8 rhel-8-appstream-rhui-rpms 27 k
perl-Digest-MD5 x86_ 64 2. 55-396. el8 rhel-8-appstream-rhui-rpms 37 k
perl-Encode x86_ 64 4. 2. 97-3. el8 rhel-8-baseos-rhui-rpms 1. 5 M
perl-Errno x86_ 64 1. 28-416. el8 rhel-8-baseos-rhui-rpms 76 k
perl-Exporter noarch 5. 72-396. el8 rhel-8-baseos-rhui-rpms 34 k
perl-File-Path noarch 2. 15-2. el8 rhel-8-baseos-rhui-rpms 38 k
perl-File-Temp noarch 0. 230. 600-1. el8 rhel-8-baseos-rhui-rpms 63 k
perl-Getopt-Long noarch 1. 2. 50-4. el8 rhel-8-baseos-rhui-rpms 63 k
perl-HTTP-Tiny noarch 0. 074-1. el8 rhel-8-baseos-rhui-rpms 58 k
Transaksi Ringkasan
==============================================================================================================================================================================================================
Install 47 Packages
Total download size. 214 M
Installed size. 912 M
Mengunduh Paket.
(1/47). mysql-community-common-5. 7. 32-1. el7. x86_64. rpm 2. 7 MB/s . 308 kB 00. 00
(2/47). mysql-community-libs-5. 7. 32-1. el7. x86_64. rpm 11 MB/s . 2. 3 MB 00. 00
(3/47). perl-Mozilla-CA-20160104-7. module+el8. 3. 0+6498+9eecfe51. noarch. rpm 136 kB/s . 15 kB 00. 00
(4/47). perl-URI-1. 73-3. el8. noarch. rpm 1. 0 MB/s . 116 kB 00. 00
(5/47). perl-Net-SSLeay-1. 88-1. module+el8. 3. 0+6446+594cad75. x86_64. rpm 3. 1 MB/s . 379 kB 00. 00
(6/47). perl-Digest-1. 17-395. el8. noarch. rpm 277 kB/s . 27 kB 00. 00
(7/47). mysql-community-client-5. 7. 32-1. el7. x86_64. rpm 35 MB/s . 25 MB 00. 00
(8/47). perl-Digest-MD5-2. 55-396. el8. x86_64. rpm 245 kB/s . 37 kB 00. 00
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 68 MB/s . 214 MB 00. 03
warning. /var/cache/dnf/mysql57-community-65b9ecb4cc6a2553/packages/mysql-community-client-5. 7. 32-1. el7. x86_64. rpm. Header V3 DSA/SHA1 Signature, key ID 5072e1f5. NOKEY
MySQL 5. 7 Community Server 5. 7 MB/s . 5. 8 kB 00. 00
Importing GPG key 0x5072E1F5.
Userid . "Rekayasa Rilis MySQL
Sidik Jari. A4A9 4068 76FC BD3C 4567 70C8 8C71 8D3B 5072 E1F5
Dari . /dll/pki/rpm-gpg/RPM-GPG-KEY-mysql
Kunci diimpor berhasil
Menjalankan transaksi periksa
Transaksi centang berhasil.
Menjalankan transaksi tes
Transaksi test berhasil.
Menjalankan transaksi
Mempersiapkan . 1 / 1
Memasang . perl-libs-4 . :5. 26. 3-416. el8. x86_64 1 / 47
Memasang . perl-Eksportir-5. 72-396. el8. noarch 2 / 47
Memasang . perl-Carp-1. 42-396. el8. noarch 3/47
Installing . perl-Scalar-List-Utils-3. 1. 49-2. el8. x86_64 4/47
Installing . perl-parent-1. 0. 237-1. el8. noarch 5/47
Installing . perl-Text-ParseWords-3. 30-395. el8. noarch 6/47
Installing . mysql-community-common-5. 7. 32-1. el7. x86_64 7/47
Installing . mysql-komunitas-libs . 7. 32-5.7.32-1. el7. x86_64 8/47
Running scriptlet. mysql-community-libs-5. 7. 32-1. el7. x86_64 8/47
Verifying . mysql-community-client-5. 7. 32-1. el7. x86_64 1/47
Verifying . mysql-community-common-5. 7. 32-1. el7. x86_64 2/47
Verifying . mysql-community-libs-5. 7. 32-1. el7. x86_64 3/47
Verifying . mysql-community-server-5. 7. 32-1. el7. x86_64 4/47
Verifying . perl-Mozilla-CA-20160104-7. module+el8. 3. 0+6498+9eecfe51. noarch 5/47
Verifying . perl-URI-1. 73-3. el8. noarch 6/47
Verifying . perl-Net-SSLeay-1. 88-1. module+el8. 3. 0+6446+594cad75. x86_64 7/47
Verifying . perl-Digest-1. 17-395. el8. noarch 8/47
Terpasang.
libaio-0. 3. 112-1. el8. x86_64 mysql-community-client-5. 7. 32-1. el7. x86_64 mysql-community-common-5. 7. 32-1. el7. x86_64
mysql-community-libs-5. 7. 32-1. el7. x86_64 mysql-community-server-5. 7. 32-1. el7. x86_64 ncurses-compat-libs-6. 1-7. 20180224. el8. x86_64
perl-Carp-1. 42-396. el8. noarch perl-Data-Dumper-2. 167-399. el8. x86_64 perl-Digest-1. 17-395. el8. noarch
perl-Digest-MD5-2. 55-396. el8. x86_64 perl-Encode-4. 2. 97-3. el8. x86_64 perl-Errno-1. 28-416. el8. x86_64
perl-Exporter-5. 72-396. el8. noarch perl-File-Path-2. 15-2. el8. noarch perl-File-Temp-0. 230. 600-1. el8. noarch
perl-Getopt-Long-1. 2. 50-4. el8. noarch perl-HTTP-Tiny-0. 074-1. el8. noarch perl-IO-1. 38-416. el8. x86_64
perl-IO-Socket-IP-0. 39-5. el8. noarch perl-IO-Socket-SSL-2. 066-4. module+el8. 3. 0+6446+594cad75. noarch perl-MIME-Base64-3. 15-396. el8. x86_64
perl-Mozilla-CA-20160104-7. module+el8. 3. 0+6498+9eecfe51. noarch perl-Net-SSLeay-1. 88-1. module+el8. 3. 0+6446+594cad75. x86_64 perl-PathTools- . 743.74-1. el8. x86_64
perl-Pod-Escapes-1. 1. 07-395. el8. noarch perl-Pod-Perldoc-3. 28-396. el8. noarch perl-Pod-Simple-1. 3. 35-395. el8. noarch
perl-Pod-Usage-4. 1. 69-395. el8. noarch perl-Scalar-List-Utils-3. 1. 49-2. el8. x86_64 perl-Socket-4. 2. 027-3. el8. x86_64
perl-Storable-1. 3. 11-3. el8. x86_64 perl-Term-ANSIColor-4. 06-396. el8. noarch perl-Term-Cap-1. 17-395. el8. noarch
perl-Teks-ParseWords-3.30-395. el8. noarch perl-Teks- . 0523Tabs+Wrap-2013.0523-395. el8. noarch perl-Waktu- . Local-1:1. 280-1. el8. noarch
perl-URI-1.73-3. el8. noarch perl-Unicode-Normalize-1. 25-396. el8. x86_64 perl-konstan- . 331.33-396. el8. noarch
perl-interpreter-4. 5. 26. 3-416. el8. x86_64 perl-libnet-3. 11-3. el8. noarch perl-libs-4. 5. 26. 3-416. el8. x86_64
perl-macros-4. 5. 26. 3-416. el8. x86_64 perl-parent-1. 0. 237-1. el8. noarch perl-podlators-4. 11-1. el8. noarch
perl-threads-1. 2. 21-2. el8. x86_64 perl-threads-shared-1. 58-2. el8. x86_64
Lengkap.
Check Version of MySQL1
2
[root@ip-172-31-41-7 ec2-user]# mysql -V
mysql Ver 14. 14 Distrib 5. 7. 32, for Linux (x86_64) using EditLine wrapper
Start the Service of MySQL1
2
[root@ip-172-31-41-7 ec2-user]# service mysqld start
Redirecting to /bin/systemctl start mysqld. service
Check the Status of MySQL1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
[root@ip-172-31-40-179 ec2-user]# service mysqld status
Redirecting to /bin/systemctl status mysqld. service
● mysqld. service - MySQL Server
Loaded. loaded (/usr/lib/systemd/system/mysqld. service; enabled; vendor preset. disabled)
Active. active (running) since Tue 2020-12-29 12. 03. 34 UTC; 21s ago
Docs. man. mysqld(8)
http. //dev. mysql. com/doc/refman/en/using-systemd. html
Process. 66842 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld. pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process. 66783 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID. 66845 (mysqld)
Tasks. 27 (batas. 4836)
Memory. 233. 8M
CGroup. /system. slice/mysqld. service
└─ 66845 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld. pid
Dec 29 12. 03. 29 ip-172-31-40-179. ap-south-1. compute. internal systemd[1]. Starting MySQL Server. . .
Dec 29 12. 03. 34 ip-172-31-40-179. ap-south-1. compute. internal systemd[1]. Started MySQL Server.
Connect to MySQL 5. 7 Database1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
[root@ip-172-31-41-7 ec2-user]# mysql -u root -p
Enter password.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version. 5. 7. 32 MySQL Community Server (GPL)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
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>
Check the version of MySQL 5. 7 Database1
2
3
4
5
6
7
8
9
10
mysql> select @@version;
+-----------+
. @@version .
+-----------+
. 5. 7. 32 .
+-----------+
1 row in set (0. 00 sec)
mysql> exit
ByE
Upgrading the MySQL 5. 7 Database1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
[root@ip-172-31-41-7 ec2-user]# mysql_upgrade -u root -p
Enter password.
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql. columns_priv OK
mysql. db OK
mysql. engine_cost OK
mysql. event OK
mysql. func OK
mysql. general_log OK
mysql. gtid_executed OK
mysql. help_category OK
mysql. help_keyword OK
mysql. help_relation OK
mysql. help_topic Oke
mysql. innodb_index_stats OK
mysql. innodb_table_stats OK
mysql. ndb_binlog_index OK
mysql. plugin OK
mysql. proc OK
mysql. procs_priv OK
mysql. proxies_priv OK
mysql. server_cost OK
mysql. servers OK
mysql. slave_master_info OK
mysql. slave_relay_log_info OK
mysql. slave_worker_info OK
mysql. slow_log OK
mysql. tables_priv OK
mysql. time_zone OK
mysql. time_zone_leap_second OK
mysql. time_zone_name OK
mysql. time_zone_transition OK
mysql. time_zone_transition_type OK
mysql. user OK
Upgrading the sys schema.
Checking databases.
sys. sys_config OK
Upgrade process completed successfully.
Checking if update is needed.
Setting the root PasswordThis command enables you to improve the security of your MySQL installation in the following ways
👉 You can set a password for root accounts
👉 You can remove root accounts that are accessible from outside the local host
👉 You can remove anonymous-user accounts
👉 Anda dapat menghapus basis data pengujian, yang secara default dapat diakses oleh pengguna anonim
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
[root@ip-172-31-41-7 ec2-user]# mysql_secure_installation
Securing the MySQL server deployment.
Enter password for user root.
VALIDATE PASSWORD PLUGIN can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Apakah Anda ingin untuk penyiapanVALIDATE PASSWORD plugin?
Tekan y. Y for Yes, any other key for No.
Using existing password for root.
Change the password for root ? ((Press y. Y for Yes, any other key for No) .
. . . skipping.
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.
Remove anonymous users? (Press y. Y for Yes, any other key for No) . y
Success.
Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network.
Disallow root login remotely? (Press y. Y for Yes, any other key for No) . y
Success.
By default, MySQL comes with a database named 'test' that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.
Remove test database and access to it? (Press y. Y for Yes, any other key for No) . y
- Dropping test database. . .
Success.
- Removing privileges on test database. . .
Success.
Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.
Muat ulang hak istimewa tabel sekarang? (Press y|Y untuk Ya, apa saja . other key for No) : y
Success.
Connect to MySQL 5. 7 Database1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
[root@ip-172-31-41-7 ec2-user]# mysql -u root -p
Enter password.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version. 5. 7. 32 MySQL Community Server (GPL)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
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>
Check the version of MySQL 5. 7 Database1
2
3
4
5
6
7
8
9
10
mysql> select @@version;
+-----------+
. @@version .
+-----------+
. 5. 7. 32 .
+-----------+
1 row in set (0. 00 sec)
mysql> exit
Selamat tinggal
Terima kasih telah memberikan waktu Anda yang berharga untuk membaca informasi di atas. Harap klik di sini untuk berlangganan pembaruan lebih lanjut