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 restartRedirecting 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