Thursday, February 13, 2020

MySQL 8 installation on CentOS 7.7




login as: root
root@172.26.72.112's password:
Last login: Thu Feb 13 13:01:36 2020 from 172.26.71.179
[root@centospdmn ~]# yum check mysql-*
Loaded plugins: fastestmirror, langpacks
check ['mysql-community-release-el7-5.noarch.rpm', 'mysql-community-release-el7-                                                                                        5.noarch.rpm.1', 'mysql-community-release-el7-5.noarch.rpm.2', 'mysql-community-                                                                                        release-el7-5.noarch.rpm.3']
[root@centospdmn ~]# yum check mysql-*
Loaded plugins: fastestmirror, langpacks
check ['mysql-community-release-el7-5.noarch.rpm', 'mysql-community-release-el7-5.noarch.rpm.1', 'mysql-community-release-el7-5.noarch.rpm.2', 'mysql-community-release-el7-5.noarch.rpm.3']
[root@centospdmn ~]# yum install mysql-community-release-el7-5.noarch.rpm
Loaded plugins: fastestmirror, langpacks
Examining mysql-community-release-el7-5.noarch.rpm: mysql-community-release-el7-5.noarch
Marking mysql-community-release-el7-5.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-release.noarch 0:el7-5 will be installed
--> Processing Conflict: mysql80-community-release-el7-3.noarch conflicts mysql-community-release
Loading mirror speeds from cached hostfile
 * base: centos.myfahim.com
 * centosplus: mirror.dhakacom.com
 * extras: mirror.dhakacom.com
 * updates: mirror.dhakacom.com
No package matched to upgrade: mysql-community-release
--> Finished Dependency Resolution
Error: mysql80-community-release conflicts with mysql-community-release-el7-5.noarch
 You could try using --skip-broken to work around the problem

 You could try running: rpm -Va --nofiles --nodigest
[root@centospdmn ~]#
[root@centospdmn ~]# rpm -qa | grep mysql*
Binary file mysql80-community-release-el7-1.noarch.rpm matches
Binary file mysql80-community-release-el7-1.noarch.rpm.1 matches
Binary file mysql80-community-release-el7-1.noarch.rpm.2 matches
Binary file mysql-community-release-el7-5.noarch.rpm matches
Binary file mysql-community-release-el7-5.noarch.rpm.1 matches
Binary file mysql-community-release-el7-5.noarch.rpm.2 matches
Binary file mysql-community-release-el7-5.noarch.rpm.3 matches
[root@centospdmn ~]# ll
total 136
-rw-------. 1 root root  1713 Jan 31 12:23 anaconda-ks.cfg
drwxr-xr-x. 2 root root     6 Feb 10 13:16 Desktop
drwxr-xr-x. 2 root root     6 Feb 10 13:16 Documents
drwxr-xr-x. 2 root root     6 Feb 10 13:16 Downloads
-rw-r--r--. 1 root root  1744 Jan 31 12:25 initial-setup-ks.cfg
drwxr-xr-x. 2 root root     6 Feb 10 13:16 Music
drwxr-xr-x. 2 root root  4096 Feb  5 00:26 mysql
-rw-r--r--. 1 root root 25820 Apr 18  2018 mysql80-community-release-el7-1.noarch.rpm
-rw-r--r--. 1 root root 25820 Apr 18  2018 mysql80-community-release-el7-1.noarch.rpm.1
-rw-r--r--. 1 root root 25820 Apr 18  2018 mysql80-community-release-el7-1.noarch.rpm.2
-rw-r--r--. 1 root root  6140 Nov 12  2015 mysql-community-release-el7-5.noarch.rpm
-rw-r--r--. 1 root root  6140 Nov 12  2015 mysql-community-release-el7-5.noarch.rpm.1
-rw-r--r--. 1 root root  6140 Nov 12  2015 mysql-community-release-el7-5.noarch.rpm.2
-rw-r--r--. 1 root root  6140 Nov 12  2015 mysql-community-release-el7-5.noarch.rpm.3
-rw-r--r--. 1 root root   582 Feb  4 15:28 notes
drwxr-xr-x. 2 root root     6 Feb 10 13:16 Pictures
drwxr-xr-x. 2 root root     6 Feb 10 13:16 Public
-rw-r--r--. 1 root root  3736 Sep 10 00:29 repomd.xml
-rw-r--r--. 1 root root     0 Feb  4 13:19 sudo
drwxr-xr-x. 2 root root     6 Feb 10 13:16 Templates
drwxr-xr-x. 2 root root     6 Feb 10 13:16 Videos
[root@centospdmn ~]# rpm -Uvh mysql80-community-release-*
warning: mysql80-community-release-el7-1.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
warning: package mysql80-community-release-el7-1.noarch was already added, skipping mysql80-community-release-el7-1.noarch
warning: package mysql80-community-release-el7-1.noarch was already added, skipping mysql80-community-release-el7-1.noarch
Preparing...                          ################################# [100%]
        package mysql80-community-release-el7-3.noarch (which is newer than mysql80-community-release-el7-1.noarch) is already installed
[root@centospdmn ~]# rpm -Uvh mysql80-community-*
warning: mysql80-community-release-el7-1.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
warning: package mysql80-community-release-el7-1.noarch was already added, skipping mysql80-community-release-el7-1.noarch
warning: package mysql80-community-release-el7-1.noarch was already added, skipping mysql80-community-release-el7-1.noarch
Preparing...                          ################################# [100%]
        package mysql80-community-release-el7-3.noarch (which is newer than mysql80-community-release-el7-1.noarch) is already installed
[root@centospdmn ~]# rpm -qa| grep mysql*
Binary file mysql80-community-release-el7-1.noarch.rpm matches
Binary file mysql80-community-release-el7-1.noarch.rpm.1 matches
Binary file mysql80-community-release-el7-1.noarch.rpm.2 matches
Binary file mysql-community-release-el7-5.noarch.rpm matches
Binary file mysql-community-release-el7-5.noarch.rpm.1 matches
Binary file mysql-community-release-el7-5.noarch.rpm.2 matches
Binary file mysql-community-release-el7-5.noarch.rpm.3 matches
[root@centospdmn ~]# yum remove mysql*
Loaded plugins: fastestmirror, langpacks
No Match for argument: mysql
No Match for argument: mysql80-community-release-el7-1.noarch.rpm
No Match for argument: mysql80-community-release-el7-1.noarch.rpm.1
No Match for argument: mysql80-community-release-el7-1.noarch.rpm.2
No Match for argument: mysql-community-release-el7-5.noarch.rpm
No Match for argument: mysql-community-release-el7-5.noarch.rpm.1
No Match for argument: mysql-community-release-el7-5.noarch.rpm.2
No Match for argument: mysql-community-release-el7-5.noarch.rpm.3
No Packages marked for removal
[root@centospdmn ~]# yum clean all
Loaded plugins: fastestmirror, langpacks
Cleaning repos: base centosplus extras updates
Cleaning up list of fastest mirrors
[root@centospdmn ~]# yum update
Loaded plugins: fastestmirror, langpacks
Determining fastest mirrors
 * base: mirrors.piconets.webwerks.in
 * centosplus: mirrors.piconets.webwerks.in
 * extras: mirrors.piconets.webwerks.in
 * updates: mirrors.piconets.webwerks.in
base                                                                                                                                             | 3.6 kB  00:00:00
centosplus                                                                                                                                       | 2.9 kB  00:00:00
extras                                                                                                                                           | 2.9 kB  00:00:00
updates                                                                                                                                          | 2.9 kB  00:00:00
(1/5): base/7/x86_64/group_gz                                                                                                                    | 165 kB  00:00:00
(2/5): extras/7/x86_64/primary_db                                                                                                                | 159 kB  00:00:00
(3/5): centosplus/7/x86_64/primary_db                                                                                                            | 2.7 MB  00:00:01
(4/5): updates/7/x86_64/primary_db                                                                                                               | 6.7 MB  00:00:06
(5/5): base/7/x86_64/primary_db                                                                                                                  | 6.0 MB  00:00:07
No packages marked for update
[root@centospdmn ~]# yum check mysql*
Loaded plugins: fastestmirror, langpacks
check ['mysql', 'mysql80-community-release-el7-1.noarch.rpm', 'mysql80-community-release-el7-1.noarch.rpm.1', 'mysql80-community-release-el7-1.noarch.rpm.2', 'mysql-community-release-el7-5.noarch.rpm', 'mysql-community-release-el7-5.noarch.rpm.1', 'mysql-community-release-el7-5.noarch.rpm.2', 'mysql-community-release-el7-5.noarch.rpm.3']
[root@centospdmn ~]# find / -name "mysql80-community-release-el7-1.noarch.rpm" -print
find: ‘/proc/28854’: No such file or directory
find: ‘/run/user/1000/gvfs’: Permission denied
/etc/yum.repos.d/mysql80-community-release-el7-1.noarch.rpm
/root/mysql80-community-release-el7-1.noarch.rpm
/var/tmp/yum-root-NIT_J_/mysql80-community-release-el7-1.noarch.rpm
/tmp/mozilla_admin0/mysql80-community-release-el7-1.noarch.rpm
/tmp/gnome-software-EJVPF0/mysql80-community-release-el7-1.noarch.rpm
[root@centospdmn ~]# find / -name "mysql*" -print
find: ‘/proc/10326’: No such file or directory
find: ‘/run/user/1000/gvfs’: Permission denied
/sys/fs/selinux/booleans/mysql_connect_any
/etc/yum.repos.d/mysql-community-source.repo
/etc/yum.repos.d/mysql-community.repo
/etc/yum.repos.d/mysql80-community-release-el7-1.noarch.rpm
/etc/my.cnf.d/mysql-clients.cnf
/etc/selinux/targeted/active/modules/100/mysql
/root/mysql-community-release-el7-5.noarch.rpm
/root/mysql-community-release-el7-5.noarch.rpm.1
/root/mysql80-community-release-el7-1.noarch.rpm
/root/mysql80-community-release-el7-1.noarch.rpm.1
/root/mysql80-community-release-el7-1.noarch.rpm.2
/root/mysql
/root/mysql/mysql-8.0.19-1.el8.aarch64.rpm-bundle.tar
/root/mysql/mysql-community-test-8.0.19-1.el8.aarch64.rpm
/root/mysql/mysql-community-libs-8.0.19-1.el8.aarch64.rpm
/root/mysql/mysql-community-server-debug-debuginfo-8.0.19-1.el8.aarch64.rpm
/root/mysql/mysql-community-debuginfo-8.0.19-1.el8.aarch64.rpm
/root/mysql/mysql-community-libs-debuginfo-8.0.19-1.el8.aarch64.rpm
/root/mysql/mysql-community-server-debug-8.0.19-1.el8.aarch64.rpm
/root/mysql/mysql-community-test-debuginfo-8.0.19-1.el8.aarch64.rpm
/root/mysql/mysql-community-devel-8.0.19-1.el8.aarch64.rpm
/root/mysql/mysql-community-debugsource-8.0.19-1.el8.aarch64.rpm
/root/mysql/mysql-community-common-8.0.19-1.el8.aarch64.rpm
/root/mysql/mysql-community-client-debuginfo-8.0.19-1.el8.aarch64.rpm
/root/mysql/mysql-community-server-8.0.19-1.el8.aarch64.rpm
/root/mysql/mysql-community-server-debuginfo-8.0.19-1.el8.aarch64.rpm
/root/mysql/mysql-community-client-8.0.19-1.el8.aarch64.rpm
/root/mysql-community-release-el7-5.noarch.rpm.2
/root/mysql-community-release-el7-5.noarch.rpm.3
/var/tmp/yum-admin-C2BCfb/x86_64/7/mysql-connectors-community
/var/tmp/yum-admin-C2BCfb/x86_64/7/mysql-tools-community
/var/tmp/yum-admin-C2BCfb/x86_64/7/mysql80-community
/var/tmp/yum-root-NIT_J_/mysql80-community-release-el7-1.noarch.rpm
/var/tmp/yum-root-NIT_J_/mysql57-community-release-el7-11.noarch.rpm
/var/lib/yum/repos/x86_64/7/mysql-connectors-community
/var/lib/yum/repos/x86_64/7/mysql-tools-community
/var/lib/yum/repos/x86_64/7/mysql80-community
/var/cache/yum/x86_64/7/mysql80-community
/tmp/gnome-software-RFPMF0/mysql80-community-release-el7-3.noarch-4.rpm
/tmp/mozilla_admin0/mysql80-community-release-el7-3.noarch-3.rpm
/tmp/mozilla_admin0/mysql80-community-release-el7-3.noarch-4.rpm
/tmp/mozilla_admin0/mysql80-community-release-el7-1.noarch.rpm
/tmp/mozilla_admin0/mysql80-community-release-el7-1.noarch-1.rpm
/tmp/gnome-software-EJVPF0/mysql80-community-release-el7-1.noarch.rpm
/tmp/gnome-software-LQEFF0/mysql80-community-release-el7-1.noarch-1.rpm
/tmp/gnome-software-VZEAF0/mysql80-community-release-el7-3.noarch-3.rpm
/usr/lib/firewalld/services/mysql.xml
/usr/lib/python2.7/site-packages/sos/plugins/mysql.py
/usr/lib/python2.7/site-packages/sos/plugins/mysql.pyc
/usr/lib/python2.7/site-packages/sos/plugins/mysql.pyo
/usr/lib64/mysql
/usr/lib64/mysql/plugin/mysql_clear_password.so
/usr/share/augeas/lenses/dist/mysql.aug
/usr/share/man/man5/mysql_table.5.gz
/usr/share/vim/vim74/syntax/mysql.vim
/usr/share/mysql
/usr/share/qemu-kvm/qemu-ga/fsfreeze-hook.d/mysql-flush.sh.sample
/home/admin/Downloads/mysql80-community-release-el7-3.noarch.rpm
/home/admin/Downloads/mysql80-community-release-el7-3.noarch(1).rpm
/home/admin/Downloads/mysql80-community-release-el7-3.noarch(2).rpm
/home/admin/Downloads/mysql80-community-release-el7-3.noarch(3).rpm
/home/admin/Downloads/mysql80-community-release-el7-3.noarch(4).rpm
[root@centospdmn ~]# rpm -ivh /root/mysql/mysql-community-server-8.0.19-1.el8.aarch64.rpm
warning: /root/mysql/mysql-community-server-8.0.19-1.el8.aarch64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
        ld-linux-aarch64.so.1()(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        ld-linux-aarch64.so.1(GLIBC_2.17)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libc.so.6(GLIBC_2.28)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libcrypto.so.1.1()(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libcrypto.so.1.1(OPENSSL_1_1_0)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libcrypto.so.1.1(OPENSSL_1_1_1)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libdl.so.2(GLIBC_2.17)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libgcc_s.so.1(GCC_4.5.0)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libm.so.6(GLIBC_2.17)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libpthread.so.0(GLIBC_2.17)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        librt.so.1(GLIBC_2.17)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libssl.so.1.1()(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libssl.so.1.1(OPENSSL_1_1_0)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libssl.so.1.1(OPENSSL_1_1_1)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libstdc++.so.6(CXXABI_1.3.11)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libstdc++.so.6(CXXABI_1.3.8)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libstdc++.so.6(CXXABI_1.3.9)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libstdc++.so.6(GLIBCXX_3.4.20)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libstdc++.so.6(GLIBCXX_3.4.21)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libstdc++.so.6(GLIBCXX_3.4.22)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libtirpc.so.3()(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        libtirpc.so.3(TIRPC_0.3.0)(64bit) is needed by mysql-community-server-8.0.19-1.el8.aarch64
        mysql-community-client(aarch-64) >= 8.0.11 is needed by mysql-community-server-8.0.19-1.el8.aarch64
        mysql-community-common(aarch-64) = 8.0.19-1.el8 is needed by mysql-community-server-8.0.19-1.el8.aarch64
[root@centospdmn ~]# yum install  ld-linux-aarch64.so.1
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
 * base: mirrors.piconets.webwerks.in
 * centosplus: mirrors.piconets.webwerks.in
 * extras: mirrors.piconets.webwerks.in
 * updates: mirrors.piconets.webwerks.in
No package ld-linux-aarch64.so.1 available.
Error: Nothing to do
[root@centospdmn ~]# yum install mysql-community-client
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
 * base: mirrors.piconets.webwerks.in
 * centosplus: mirrors.piconets.webwerks.in
 * extras: mirrors.piconets.webwerks.in
 * updates: mirrors.piconets.webwerks.in
No package mysql-community-client available.
Error: Nothing to do
[root@centospdmn ~]# cd /etc/yum.repos.d/
[root@centospdmn yum.repos.d]# ll
total 72
-rw-r--r--. 1 root root  1248 Feb 10 13:51 CentOS-Base.repo
-rw-r--r--. 1 root root  1664 Feb  5 00:48 CentOS-Base.repo_bkp
-rw-r--r--. 1 root root  1309 Sep  5 18:35 CentOS-CR.repo
-rw-r--r--. 1 root root   649 Sep  5 18:35 CentOS-Debuginfo.repo
-rw-r--r--. 1 root root   314 Sep  5 18:35 CentOS-fasttrack.repo
-rw-r--r--. 1 root root   630 Sep  5 18:35 CentOS-Media.repo
-rw-r--r--. 1 root root  1331 Sep  5 18:35 CentOS-Sources.repo
-rw-r--r--. 1 root root  6639 Sep  5 18:35 CentOS-Vault.repo
-rw-r--r--. 1 root root 25820 Apr 18  2018 mysql80-community-release-el7-1.noarch.rpm
-rw-r--r--. 1 root root  2076 Feb 10 13:27 mysql-community.repo
-rw-r--r--. 1 root root  2108 Apr 24  2019 mysql-community-source.repo
drwxr-xr-x. 2 root root   248 Feb  5 00:40 test
[root@centospdmn yum.repos.d]# vi mysql-community.repo
[root@centospdmn yum.repos.d]# vi mysql-community-source.repo
[root@centospdmn yum.repos.d]# rpm -Uvh https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm
Retrieving https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm
warning: /var/tmp/rpm-tmp.m1X3NU: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
        package mysql80-community-release-el7-3.noarch is already installed
[root@centospdmn yum.repos.d]# sed -i 's/enabled=1/enabled=0/' /etc/yum.repos.d/mysql-community.repo
[root@centospdmn yum.repos.d]# yum --enablerepo=mysql80-community install mysql-community-server
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
 * base: mirrors.piconets.webwerks.in
 * centosplus: mirrors.piconets.webwerks.in
 * extras: mirrors.piconets.webwerks.in
 * updates: mirrors.piconets.webwerks.in
mysql80-community                                                                                                                                | 2.5 kB  00:00:00
mysql80-community/x86_64/primary_db                                                                                                              |  97 kB  00:00:00
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.19-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.19-1.el7 for package: mysql-community-server-8.0.19-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.11 for package: mysql-community-server-8.0.19-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.19-1.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11 for package: mysql-community-client-8.0.19-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:8.0.19-1.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.64-1.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-7.0.1.el7.centos.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-7.0.1.el7.centos.x86_64
---> Package mysql-community-libs.x86_64 0:8.0.19-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:8.0.19-1.el7 will be obsoleting
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
 Package                                            Arch                          Version                                Repository                                Size
========================================================================================================================================================================
Installing:
 mysql-community-libs                               x86_64                        8.0.19-1.el7                           mysql80-community                        4.0 M
     replacing  mariadb-libs.x86_64 1:5.5.64-1.el7
 mysql-community-libs-compat                        x86_64                        8.0.19-1.el7                           mysql80-community                        1.3 M
     replacing  mariadb-libs.x86_64 1:5.5.64-1.el7
 mysql-community-server                             x86_64                        8.0.19-1.el7                           mysql80-community                        436 M
Installing for dependencies:
 mysql-community-client                             x86_64                        8.0.19-1.el7                           mysql80-community                         41 M
 mysql-community-common                             x86_64                        8.0.19-1.el7                           mysql80-community                        605 k

Transaction Summary
========================================================================================================================================================================
Install  3 Packages (+2 Dependent packages)

Total download size: 483 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7/mysql80-community/packages/mysql-community-common-8.0.19-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY:-- ETA
Public key for mysql-community-common-8.0.19-1.el7.x86_64.rpm is not installed
(1/5): mysql-community-common-8.0.19-1.el7.x86_64.rpm                                                                                            | 605 kB  00:00:00
(2/5): mysql-community-libs-8.0.19-1.el7.x86_64.rpm                                                                                              | 4.0 MB  00:00:03
(3/5): mysql-community-libs-compat-8.0.19-1.el7.x86_64.rpm                                                                                       | 1.3 MB  00:00:01
(4/5): mysql-community-client-8.0.19-1.el7.x86_64.rpm                                                                                            |  41 MB  00:00:30
(5/5): mysql-community-server-8.0.19-1.el7.x86_64.rpm                                                                                            | 436 MB  00:03:45
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                   2.1 MB/s | 483 MB  00:03:50
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
 Userid     : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
 Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
 Package    : mysql80-community-release-el7-3.noarch (installed)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : mysql-community-common-8.0.19-1.el7.x86_64                                                                                                           1/6
  Installing : mysql-community-libs-8.0.19-1.el7.x86_64                                                                                                             2/6
  Installing : mysql-community-client-8.0.19-1.el7.x86_64                                                                                                           3/6
  Installing : mysql-community-server-8.0.19-1.el7.x86_64                                                                                                           4/6
  Installing : mysql-community-libs-compat-8.0.19-1.el7.x86_64                                                                                                      5/6
  Erasing    : 1:mariadb-libs-5.5.64-1.el7.x86_64                                                                                                                   6/6
  Verifying  : mysql-community-libs-8.0.19-1.el7.x86_64                                                                                                             1/6
  Verifying  : mysql-community-libs-compat-8.0.19-1.el7.x86_64                                                                                                      2/6
  Verifying  : mysql-community-client-8.0.19-1.el7.x86_64                                                                                                           3/6
  Verifying  : mysql-community-common-8.0.19-1.el7.x86_64                                                                                                           4/6
  Verifying  : mysql-community-server-8.0.19-1.el7.x86_64                                                                                                           5/6
  Verifying  : 1:mariadb-libs-5.5.64-1.el7.x86_64                                                                                                                   6/6

Installed:
  mysql-community-libs.x86_64 0:8.0.19-1.el7          mysql-community-libs-compat.x86_64 0:8.0.19-1.el7          mysql-community-server.x86_64 0:8.0.19-1.el7

Dependency Installed:
  mysql-community-client.x86_64 0:8.0.19-1.el7                                       mysql-community-common.x86_64 0:8.0.19-1.el7

Replaced:
  mariadb-libs.x86_64 1:5.5.64-1.el7

Complete!
[root@centospdmn yum.repos.d]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
[root@centospdmn yum.repos.d]# grep "A temporary password" /var/log/mysqld.log
2020-02-13T07:50:26.382733Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: =(!TBp2H3);M


Note that your temporary password will be different. You will need this password for changing the password of the root user account.

[root@centospdmn yum.repos.d]# mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:
Error: Access denied for user 'root'@'localhost' (using password: YES)
[root@centospdmn yum.repos.d]# mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:
Error: Access denied for user 'root'@'localhost' (using password: YES)
[root@centospdmn yum.repos.d]# grep "A temporary password" /var/log/mysqld.log
2020-02-13T07:50:26.382733Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: =(!TBp2H3);M
[root@centospdmn yum.repos.d]# mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:

The existing password for the user account root has expired. Please set a new password.

New password:

Re-enter new password:
 ... Failed! Error: Your password does not satisfy the current policy requirements

New password:

Re-enter new password:
The 'validate_password' component is installed on the server.
The subsequent steps will run with the existing configuration
of the component.
Using existing password for root.

Estimated strength of the password: 100
Change the password for root ? ((Press y|Y for Yes, any other key for No) : y

New password:

Re-enter new password:

Estimated strength of the password: 100
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y
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) : n

 ... skipping.
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) : n

 ... skipping.
Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.

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

All done!
[root@centospdmn yum.repos.d]#

[root@centospdmn yum.repos.d]# service mysqld restart
Redirecting to /bin/systemctl restart mysqld.service
[root@centospdmn yum.repos.d]# chkconfig mysqld on
Note: Forwarding request to 'systemctl enable mysqld.service'.
[root@centospdmn yum.repos.d]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@centospdmn yum.repos.d]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.19 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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

mysql>

No comments:

Post a Comment