mysql记录下

最新推荐文章于 2024-09-11 09:31:43 发布
最新推荐文章于 2024-09-11 09:31:43 发布
阅读量770 收藏
点赞数
分类专栏： MariaDB
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_37477226/article/details/105407425
版权

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Resolving Dependencies
–> Running transaction check
—> Package wget.x86_64 0:1.14-18.el7 will be installed
–> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================================================
Package Arch Version Repository Size

Installing:
wget x86_64 1.14-18.el7 server 547 k

Transaction Summary

Install 1 Package

Total download size: 547 k
Installed size: 2.0 M
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : wget-1.14-18.el7.x86_64 1/1
Verifying : wget-1.14-18.el7.x86_64 1/1

Installed:
wget.x86_64 0:1.14-18.el7

Complete!
[root@localhost ~]# wget http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm
–2020-04-09 11:26:22-- http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm
Resolving repo.mysql.com (repo.mysql.com)… failed: Name or service not known.
wget: unable to resolve host address ‘repo.mysql.com’
[root@localhost ~]#
[root@localhost ~]# #如果没有wget命令可以通过如下命令安装
[root@localhost ~]# yum install wget -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Package wget-1.14-18.el7.x86_64 already installed and latest version
Nothing to do
[root@localhost ~]# ^C
[root@localhost ~]# ^C
[root@localhost ~]# ^C
[root@localhost ~]# wget http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm
–2020-04-09 11:26:38-- http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm
Resolving repo.mysql.com (repo.mysql.com)… failed: Name or service not known.
wget: unable to resolve host address ‘repo.mysql.com’
[root@localhost ~]#
[root@localhost ~]# #如果没有wget命令可以通过如下命令安装
[root@localhost ~]# yum install wget -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Package wget-1.14-18.el7.x86_64 already installed and latest version
Nothing to do
[root@localhost ~]# wget http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm
–2020-04-09 11:26:52-- http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm
Resolving repo.mysql.com (repo.mysql.com)… failed: Name or service not known.
wget: unable to resolve host address ‘repo.mysql.com’
[root@localhost ~]#
[root@localhost ~]# #如果没有wget命令可以通过如下命令安装
[root@localhost ~]# yum install wget -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Package wget-1.14-18.el7.x86_64 already installed and latest version
Nothing to do
[root@localhost ~]# wget http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm
–2020-04-09 11:27:08-- http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm
Resolving repo.mysql.com (repo.mysql.com)… failed: Name or service not known.
wget: unable to resolve host address ‘repo.mysql.com’
[root@localhost ~]#
[root@localhost ~]# #如果没有wget命令可以通过如下命令安装
[root@localhost ~]# yum install wget -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Package wget-1.14-18.el7.x86_64 already installed and latest version
Nothing to do
[root@localhost ~]# yum localinstall mysql57-community-release-el7-7.noarch.rpm
Loaded plugins: fastestmirror
Cannot open: mysql57-community-release-el7-7.noarch.rpm. Skipping.
Nothing to do
[root@localhost ~]# ls
anaconda-ks.cfg
[root@localhost ~]# wget http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm
–2020-04-09 11:27:54-- http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm
Resolving repo.mysql.com (repo.mysql.com)… failed: Name or service not known.
wget: unable to resolve host address ‘repo.mysql.com’
[root@localhost ~]# wget http://23.213.169.17//mysql57-community-release-el7-7.noarch.rpm
–2020-04-09 11:29:04-- http://23.213.169.17//mysql57-community-release-el7-7.noarch.rpm
Connecting to 23.213.169.17:80… connected.
HTTP request sent, awaiting response… 400 Bad Request
2020-04-09 11:29:05 ERROR 400: Bad Request.

[root@localhost ~]# wget http://23.213.169.17/mysql57-community-release-el7-7.noarch.rpm
–2020-04-09 11:29:13-- http://23.213.169.17/mysql57-community-release-el7-7.noarch.rpm
Connecting to 23.213.169.17:80… connected.
HTTP request sent, awaiting response… 400 Bad Request
2020-04-09 11:29:13 ERROR 400: Bad Request.

[root@localhost ~]# ping 23.213.169.17
PING 23.213.169.17 (23.213.169.17) 56(84) bytes of data.
64 bytes from 23.213.169.17: icmp_seq=1 ttl=50 time=225 ms
64 bytes from 23.213.169.17: icmp_seq=2 ttl=50 time=228 ms
^C
— 23.213.169.17 ping statistics —
3 packets transmitted, 2 received, 33% packet loss, time 2002ms
rtt min/avg/max/mdev = 225.580/226.914/228.249/1.416 ms
[root@localhost ~]# http://23.213.169.17//mysql57-community-release-el7-7.noarch.rpm^C
[root@localhost ~]# ^C
[root@localhost ~]# ^C
[root@localhost ~]# ls
anaconda-ks.cfg
[root@localhost ~]# cd /
[root@localhost /]# ls
bak data home media opt root srv usr
bin dev lib mnt p13390677_112040_Linux-x86-64_1of7.zip run sys var
boot etc lib64 mysql57-community-release-el7-7.noarch.rpm proc sbin tmp web
[root@localhost /]# #添加到yum源
[root@localhost /]# yum localinstall mysql57-community-release-el7-7.noarch.rpm

#查看可用和默认的yum源，这里默认的就是5.7
yum repolist all | grep mysql
Loaded plugins: fastestmirror
Examining mysql57-community-release-el7-7.noarch.rpm: mysql57-community-release-el7-7.noarch
Marking mysql57-community-release-el7-7.noarch.rpm to be installed
Resolving Dependencies
–> Running transaction check
—> Package mysql57-community-release.noarch 0:el7-7 will be installed
–> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================================================
Package Arch Version Repository Size

Installing:
mysql57-community-release noarch el7-7 /mysql57-community-release-el7-7.noarch 7.8 k

Transaction Summary

Install 1 Package

Total size: 7.8 k
Installed size: 7.8 k
Is this ok [y/d/N]: Exiting on user command
Your transaction was saved, rerun it with:
yum load-transaction /tmp/yum_save_tx.2020-04-09.11-31.inBdER.yumtx
[root@localhost /]# #查看可用和默认的yum源，这里默认的就是5.7
[root@localhost /]# yum repolist all | grep mysql
[root@localhost /]# yum localinstall mysql57-community-release-el7-7.noarch.rpm
Loaded plugins: fastestmirror
Examining mysql57-community-release-el7-7.noarch.rpm: mysql57-community-release-el7-7.noarch
Marking mysql57-community-release-el7-7.noarch.rpm to be installed
Resolving Dependencies
–> Running transaction check
—> Package mysql57-community-release.noarch 0:el7-7 will be installed
–> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================================================
Package Arch Version Repository Size

Installing:
mysql57-community-release noarch el7-7 /mysql57-community-release-el7-7.noarch 7.8 k

Transaction Summary

Install 1 Package

Total size: 7.8 k
Installed size: 7.8 k
Is this ok [y/d/N]:
Exiting on user command
Your transaction was saved, rerun it with:
yum load-transaction /tmp/yum_save_tx.2020-04-09.11-31.WFPgAp.yumtx
[root@localhost /]# yum localinstall mysql57-community-release-el7-7.noarch.rpm
Loaded plugins: fastestmirror
Examining mysql57-community-release-el7-7.noarch.rpm: mysql57-community-release-el7-7.noarch
Marking mysql57-community-release-el7-7.noarch.rpm to be installed
Resolving Dependencies
–> Running transaction check
—> Package mysql57-community-release.noarch 0:el7-7 will be installed
–> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================================================
Package Arch Version Repository Size

Installing:
mysql57-community-release noarch el7-7 /mysql57-community-release-el7-7.noarch 7.8 k

Transaction Summary

Install 1 Package

Total size: 7.8 k
Installed size: 7.8 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : mysql57-community-release-el7-7.noarch 1/1
Verifying : mysql57-community-release-el7-7.noarch 1/1

Installed:
mysql57-community-release.noarch 0:el7-7

Complete!
[root@localhost /]# yum repolist all | grep mysql
http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - “Could not resolve host: repo.mysql.com; Unknown error”
Trying other mirror.
http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - “Could not resolve host: repo.mysql.com; Unknown error”
Trying other mirror.
http://repo.mysql.com/yum/mysql-tools-community/el/7/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - “Could not resolve host: repo.mysql.com; Unknown error”
Trying other mirror.
http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - “Could not resolve host: repo.mysql.com; Unknown error”
Trying other mirror.
mysql-connectors-community/x86_64 MySQL Connectors Community enabled: 0
mysql-connectors-community-source MySQL Connectors Community - So disabled
mysql-tools-community/x86_64 MySQL Tools Community enabled: 0
mysql-tools-community-source MySQL Tools Community - Source disabled
mysql55-community/x86_64 MySQL 5.5 Community Server disabled
mysql55-community-source MySQL 5.5 Community Server - So disabled
mysql56-community/x86_64 MySQL 5.6 Community Server disabled
mysql56-community-source MySQL 5.6 Community Server - So disabled
mysql57-community/x86_64 MySQL 5.7 Community Server enabled: 0
mysql57-community-source MySQL 5.7 Community Server - So disabled
[root@localhost /]# #添加到yum源
[root@localhost /]# yum localinstall mysql57-community-release-el7-7.noarch.rpm

#查看可用和默认的yum源，这里默认的就是5.7
yum repolist all | grep mysql
Loaded plugins: fastestmirror
Examining mysql57-community-release-el7-7.noarch.rpm: mysql57-community-release-el7-7.noarch
mysql57-community-release-el7-7.noarch.rpm: does not update installed package.
Nothing to do
[root@localhost /]#
[root@localhost /]# #查看可用和默认的yum源，这里默认的就是5.7
[root@localhost /]# yum repolist all | grep mysql
http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - “Could not resolve host: repo.mysql.com; Unknown error”
Trying other mirror.
http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - “Could not resolve host: repo.mysql.com; Unknown error”
Trying other mirror.
http://repo.mysql.com/yum/mysql-tools-community/el/7/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - “Could not resolve host: repo.mysql.com; Unknown error”
Trying other mirror.
http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - “Could not resolve host: repo.mysql.com; Unknown error”
Trying other mirror.
mysql-connectors-community/x86_64 MySQL Connectors Community enabled: 0
mysql-connectors-community-source MySQL Connectors Community - So disabled
mysql-tools-community/x86_64 MySQL Tools Community enabled: 0
mysql-tools-community-source MySQL Tools Community - Source disabled
mysql55-community/x86_64 MySQL 5.5 Community Server disabled
mysql55-community-source MySQL 5.5 Community Server - So disabled
mysql56-community/x86_64 MySQL 5.6 Community Server disabled
mysql56-community-source MySQL 5.6 Community Server - So disabled
mysql57-community/x86_64 MySQL 5.7 Community Server enabled: 0
mysql57-community-source MySQL 5.7 Community Server - So disabled
[root@localhost /]# yum install mysql-community-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - “Could not resolve host: repo.mysql.com; Unknown error”
Trying other mirror.

One of the configured repositories failed (MySQL Connectors Community),
and yum doesn’t have enough cached data to continue. At this point the only
safe thing yum can do is fail. There are a few ways to work “fix” this:

 1. Contact the upstream for the repository and get them to fix the problem.

 2. Reconfigure the baseurl/etc. for the repository, to point to a working
    upstream. This is most often useful if you are using a newer
    distribution release than is supported by the repository (and the
    packages for the previous distribution release still work).

 3. Run the command with the repository temporarily disabled
        yum --disablerepo=mysql-connectors-community ...

 4. Disable the repository permanently, so yum won't use it by default. Yum
    will then just ignore the repository until you permanently enable it
    again or use --enablerepo for temporary usage:

        yum-config-manager --disable mysql-connectors-community
    or
        subscription-manager repos --disable=mysql-connectors-community

 5. Configure the failing repository to be skipped, if it is unavailable.
    Note that yum will try to contact the repo. when it runs most commands,
    so will have to try and fail each time (and thus. yum will be be much
    slower). If it is a very temporary problem though, this is often a nice
    compromise:

        yum-config-manager --save --setopt=mysql-connectors-community.skip_if_unavailable=true

failure: repodata/repomd.xml from mysql-connectors-community: [Errno 256] No more mirrors to try.
http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - “Could not resolve host: repo.mysql.com; Unknown error”
[root@localhost /]# yum install mysql-community-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - “Could not resolve host: repo.mysql.com; Unknown error”
Trying other mirror.

One of the configured repositories failed (MySQL Connectors Community),
and yum doesn’t have enough cached data to continue. At this point the only
safe thing yum can do is fail. There are a few ways to work “fix” this:

 1. Contact the upstream for the repository and get them to fix the problem.

 2. Reconfigure the baseurl/etc. for the repository, to point to a working
    upstream. This is most often useful if you are using a newer
    distribution release than is supported by the repository (and the

[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql-tools-community]
name=MySQL Tools Community
baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

Enable to use MySQL 5.5

[mysql55-community]
name=MySQL 5.5 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.5-community/el/7/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

Enable to use MySQL 5.6

[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/7/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[root@localhost yum.repos.d]# yum install mysql-community-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - “Could not resolve host: repo.mysql.com; Unknown error”
Trying other mirror.

One of the configured repositories failed (MySQL Connectors Community),
and yum doesn’t have enough cached data to continue. At this point the only
safe thing yum can do is fail. There are a few ways to work “fix” this:

 1. Contact the upstream for the repository and get them to fix the problem.

 2. Reconfigure the baseurl/etc. for the repository, to point to a working
    upstream. This is most often useful if you are using a newer
    distribution release than is supported by the repository (and the
    packages for the previous distribution release still work).

 3. Run the command with the repository temporarily disabled
        yum --disablerepo=mysql-connectors-community ...

 4. Disable the repository permanently, so yum won't use it by default. Yum
    will then just ignore the repository until you permanently enable it
    again or use --enablerepo for temporary usage:

        yum-config-manager --disable mysql-connectors-community
    or
        subscription-manager repos --disable=mysql-connectors-community

 5. Configure the failing repository to be skipped, if it is unavailable.
    Note that yum will try to contact the repo. when it runs most commands,
    so will have to try and fail each time (and thus. yum will be be much
    slower). If it is a very temporary problem though, this is often a nice
    compromise:

        yum-config-manager --save --setopt=mysql-connectors-community.skip_if_unavailable=true

failure: repodata/repomd.xml from mysql-connectors-community: [Errno 256] No more mirrors to try.
http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - “Could not resolve host: repo.mysql.com; Unknown error”
nameserver 8.8.8.8
~
~
~ ~
~
~ nameserver 8.8.8.8
~
~ ~
~
~ ~
~
~
nameserver 8.8.8.8
nameserver 114.114.114.114
nameserver 8.8.8.8
nameserver 114.114.114.114
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
“/etc/resolv.conf” 2L, 46C written
[root@localhost yum.repos.d]# ls
~ bak mysql-community.repo mysql-community-source.repo server.repo
[root@localhost yum.repos.d]# cat ~
cat: /root: Is a directory
[root@localhost yum.repos.d]# cat ~
cat: /root: Is a directory
[root@localhost yum.repos.d]# cd ~
-bash: cd: ~: Not a directory
[root@localhost yum.repos.d]# cat ~
nameserver 8.8.8.8
nameserver 114.114.114.114
[root@localhost yum.repos.d]#
[root@localhost yum.repos.d]# ^C
[root@localhost yum.repos.d]# ^C
[root@localhost yum.repos.d]# ^C
[root@localhost yum.repos.d]# ls
~ bak mysql-community.repo mysql-community-source.repo server.repo
[root@localhost yum.repos.d]# mv ~ 1
[root@localhost yum.repos.d]# ls
1 bak mysql-community.repo mysql-community-source.repo server.repo
[root@localhost yum.repos.d]# cat 1
nameserver 8.8.8.8
nameserver 114.114.114.114
[root@localhost yum.repos.d]# rm -rf 1
[root@localhost yum.repos.d]# ls
bak mysql-community.repo mysql-community-source.repo server.repo
[root@localhost yum.repos.d]# yum clean all
Loaded plugins: fastestmirror
Existing lock /var/run/yum.pid: another copy is running as pid 15002.
Another app is currently holding the yum lock; waiting for it to exit…
The other application is: yum
Memory : 23 M RSS (425 MB VSZ)
Started: Thu Apr 9 11:38:09 2020 - 03:33 ago
State : Traced/Stopped, pid: 15002
Another app is currently holding the yum lock; waiting for it to exit…
The other application is: yum
Memory : 23 M RSS (425 MB VSZ)
Started: Thu Apr 9 11:38:09 2020 - 03:35 ago
State : Traced/Stopped, pid: 15002
Another app is currently holding the yum lock; waiting for it to exit…
The other application is: yum
Memory : 23 M RSS (425 MB VSZ)
Started: Thu Apr 9 11:38:09 2020 - 03:37 ago
State : Traced/Stopped, pid: 15002
Another app is currently holding the yum lock; waiting for it to exit…
The other application is: yum
Memory : 23 M RSS (425 MB VSZ)
Started: Thu Apr 9 11:38:09 2020 - 03:39 ago
State : Traced/Stopped, pid: 15002
^C

Exiting on user cancel.
[root@localhost yum.repos.d]# ps -ef | grep yum
root 15002 14171 0 11:38 pts/1 00:00:00 /usr/bin/python /usr/bin/yum repolist all
root 15204 14171 0 11:41 pts/1 00:00:00 grep --color=auto yum
[root@localhost yum.repos.d]# kill -9 15002
[root@localhost yum.repos.d]# yum clean all
Loaded plugins: fastestmirror
Cleaning repos: mysql-connectors-community mysql-tools-community mysql57-community server
Cleaning up list of fastest mirrors
[1]+ Interrupt yum repolist all | grep --color=auto mysql
[root@localhost yum.repos.d]# yum clean all
Loaded plugins: fastestmirror
Cleaning repos: mysql-connectors-community mysql-tools-community mysql57-community server
[root@localhost yum.repos.d]# ^C
[root@localhost yum.repos.d]# ^C
[root@localhost yum.repos.d]# ^C
[root@localhost yum.repos.d]# ^C
[root@localhost yum.repos.d]# ^C
[root@localhost yum.repos.d]# ^C
[root@localhost yum.repos.d]# yum list ^C
[root@localhost yum.repos.d]# yum repolist all | grep mysql
http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: [Errno 12] Timeout on http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: (28, ‘Resolving timed out after 30541 milliseconds’)
Trying other mirror.
http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: [Errno 12] Timeout on http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: (28, ‘Resolving timed out after 30541 milliseconds’)
Trying other mirror.
http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: [Errno 12] Timeout on http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: (28, ‘Resolving timed out after 30541 milliseconds’)
Trying other mirror.
http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: [Errno 12] Timeout on http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/repodata/repomd.xml: (28, ‘Resolving timed out after 30541 milliseconds’)
Trying other mirror.
CZ
[1]+ Stopped yum repolist all | grep --color=auto mysql
[root@localhost yum.repos.d]# ping 28, 'Resolving timed^C
[root@localhost yum.repos.d]# ^C
[root@localhost yum.repos.d]# ^C
[root@localhost yum.repos.d]# ^C
[root@localhost yum.repos.d]# ping http://repo.mysql.com/
^C
[root@localhost yum.repos.d]# ping repo.mysql.com
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1localhost localhost.localdomain localhost6 localhost6.localdomain6
23.79.41.42 repo.mysql.com
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
“/etc/hosts” 3L, 185C written
[root@localhost yum.repos.d]# ping repo.mysql.com
PING repo.mysql.com (23.79.41.42) 56(84) bytes of data.
64 bytes from repo.mysql.com (23.79.41.42): icmp_seq=1 ttl=49 time=140 ms
^C
— repo.mysql.com ping statistics —
2 packets transmitted, 1 received, 50% packet loss, time 1001ms
rtt min/avg/max/mdev = 140.819/140.819/140.819/0.000 ms
[root@localhost yum.repos.d]# ping repo.mysql.com^C
[root@localhost yum.repos.d]# ps -ef | grep yum
root 15275 14171 0 11:43 pts/1 00:00:00 /usr/bin/python /usr/bin/yum repolist all
root 15654 14171 0 11:49 pts/1 00:00:00 grep --color=auto yum
[root@localhost yum.repos.d]# kill -9 15275
[root@localhost yum.repos.d]# yum repolist all | grep mysql
mysql-connectors-community/x86_64 MySQL Connectors Community enabled: 141
mysql-connectors-community-source MySQL Connectors Community - So disabled
mysql-tools-community/x86_64 MySQL Tools Community enabled: 105
mysql-tools-community-source MySQL Tools Community - Source disabled
mysql55-community/x86_64 MySQL 5.5 Community Server disabled
mysql55-community-source MySQL 5.5 Community Server - So disabled
mysql56-community/x86_64 MySQL 5.6 Community Server disabled
mysql56-community-source MySQL 5.6 Community Server - So disabled
mysql57-community/x86_64 MySQL 5.7 Community Server enabled: 404
mysql57-community-source MySQL 5.7 Community Server - So disabled
[1]+ Interrupt yum repolist all | grep --color=auto mysql
[root@localhost yum.repos.d]# yum remove mariadb*
Loaded plugins: fastestmirror
Resolving Dependencies
–> Running transaction check
—> Package mariadb-libs.x86_64 1:5.5.60-1.el7_5 will be erased
–> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-7.el7.x86_64
–> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-7.el7.x86_64
–> Running transaction check
—> Package postfix.x86_64 2:2.10.1-7.el7 will be erased
–> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================================================
Package Arch Version Repository Size

Removing:
mariadb-libs x86_64 1:5.5.60-1.el7_5 @anaconda 4.4 M
Removing for dependencies:
postfix x86_64 2:2.10.1-7.el7 @anaconda 12 M

Transaction Summary

Remove 1 Package (+1 Dependent package)

Installed size: 17 M
Is this ok [y/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Erasing : 2:postfix-2.10.1-7.el7.x86_64 1/2
Erasing : 1:mariadb-libs-5.5.60-1.el7_5.x86_64 2/2
warning: /etc/my.cnf saved as /etc/my.cnf.rpmsave
Verifying : 2:postfix-2.10.1-7.el7.x86_64 1/2
Verifying : 1:mariadb-libs-5.5.60-1.el7_5.x86_64 2/2

Removed:
mariadb-libs.x86_64 1:5.5.60-1.el7_5

Dependency Removed:
postfix.x86_64 2:2.10.1-7.el7

Complete!
[root@localhost yum.repos.d]# yum remove mariadb*^C
[root@localhost yum.repos.d]# yum install mysql-community-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Resolving Dependencies
–> Running transaction check
—> Package mysql-community-server.x86_64 0:5.7.29-1.el7 will be installed
–> Processing Dependency: mysql-community-common(x86-64) = 5.7.29-1.el7 for package: mysql-community-server-5.7.29-1.el7.x86_64
–> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.29-1.el7.x86_64
–> Processing Dependency: net-tools for package: mysql-community-server-5.7.29-1.el7.x86_64
–> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mysql-community-server-5.7.29-1.el7.x86_64
–> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mysql-community-server-5.7.29-1.el7.x86_64
–> Processing Dependency: libaio.so.1()(64bit) for package: mysql-community-server-5.7.29-1.el7.x86_64
–> Running transaction check
—> Package libaio.x86_64 0:0.3.109-13.el7 will be installed
—> Package mysql-community-client.x86_64 0:5.7.29-1.el7 will be installed
–> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.29-1.el7.x86_64
—> Package mysql-community-common.x86_64 0:5.7.29-1.el7 will be installed
—> Package net-tools.x86_64 0:2.0-0.24.20131004git.el7 will be installed
–> Running transaction check
—> Package mysql-community-libs.x86_64 0:5.7.29-1.el7 will be installed
–> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================================================
Package Arch Version Repository Size

Installing:
mysql-community-server x86_64 5.7.29-1.el7 mysql57-community 175 M
Installing for dependencies:
libaio x86_64 0.3.109-13.el7 server 24 k
mysql-community-client x86_64 5.7.29-1.el7 mysql57-community 26 M
mysql-community-common x86_64 5.7.29-1.el7 mysql57-community 311 k
mysql-community-libs x86_64 5.7.29-1.el7 mysql57-community 2.5 M
net-tools x86_64 2.0-0.24.20131004git.el7 server 306 k

Transaction Summary

Install 1 Package (+5 Dependent packages)

Total download size: 205 M
Installed size: 882 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5.7.29-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Public key for mysql-community-common-5.7.29-1.el7.x86_64.rpm is not installed
(1/4): mysql-community-common-5.7.29-1.el7.x86_64.rpm | 311 kB 00:00:01
(2/4): mysql-community-libs-5.7.29-1.el7.x86_64.rpm | 2.5 MB 00:00:01
(3/4): mysql-community-client-5.7.29-1.el7.x86_64.rpm | 26 MB 00:00:24
(4/4): mysql-community-server-5.7.29-1.el7.x86 99% [=-] 499 kB/s | 203 MB 00:00:02 ETA
(4/4): mysql-community-server-5.7.29-1.el7.x86 99% [=-] 518 kB/s | 204 MB 00:00:01 ETA

(4/4): mysql-community-server-5.7.29-1.el7.x86_64.rpm | 175 MB 00:04:23

Total 787 kB/s | 205 MB 00:04:26
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 : mysql57-community-release-el7-7.noarch (installed)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]:

Didn’t install any keys
[root@localhost yum.repos.d]#
[root@localhost yum.repos.d]#
[root@localhost yum.repos.d]# yum install mysql-community-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Resolving Dependencies
–> Running transaction check
—> Package mysql-community-server.x86_64 0:5.7.29-1.el7 will be installed
–> Processing Dependency: mysql-community-common(x86-64) = 5.7.29-1.el7 for package: mysql-community-server-5.7.29-1.el7.x86_64
–> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.29-1.el7.x86_64
–> Processing Dependency: net-tools for package: mysql-community-server-5.7.29-1.el7.x86_64
–> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mysql-community-server-5.7.29-1.el7.x86_64
–> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mysql-community-server-5.7.29-1.el7.x86_64
–> Processing Dependency: libaio.so.1()(64bit) for package: mysql-community-server-5.7.29-1.el7.x86_64
–> Running transaction check
—> Package libaio.x86_64 0:0.3.109-13.el7 will be installed
—> Package mysql-community-client.x86_64 0:5.7.29-1.el7 will be installed
–> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.29-1.el7.x86_64
—> Package mysql-community-common.x86_64 0:5.7.29-1.el7 will be installed
—> Package net-tools.x86_64 0:2.0-0.24.20131004git.el7 will be installed
–> Running transaction check
—> Package mysql-community-libs.x86_64 0:5.7.29-1.el7 will be installed
–> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================================================
Package Arch Version Repository Size

Installing:
mysql-community-server x86_64 5.7.29-1.el7 mysql57-community 175 M
Installing for dependencies:
libaio x86_64 0.3.109-13.el7 server 24 k
mysql-community-client x86_64 5.7.29-1.el7 mysql57-community 26 M
mysql-community-common x86_64 5.7.29-1.el7 mysql57-community 311 k
mysql-community-libs x86_64 5.7.29-1.el7 mysql57-community 2.5 M
net-tools x86_64 2.0-0.24.20131004git.el7 server 306 k

Transaction Summary

Install 1 Package (+5 Dependent packages)

Total size: 205 M
Total download size: 330 k
Installed size: 882 M
Is this ok [y/d/N]: y
Downloading packages:

Total 119 MB/s | 330 kB 00:00:00
warning: /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5.7.29-1.el7.x86_64.rpm: Header V3 DSA/
SHA1 Signature, key ID 5072e1f5: NOKEY
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 : mysql57-community-release-el7-7.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-5.7.29-1.el7.x86_64 1/6
Installing : mysql-community-libs-5.7.29-1.el7.x86_64 2/6
Installing : mysql-community-client-5.7.29-1.el7.x86_64 3/6
Installing : libaio-0.3.109-13.el7.x86_64 4/6
Installing : net-tools-2.0-0.24.20131004git.el7.x86_64 5/6
Installing : mysql-community-server-5.7.29-1.el7.x86_64 6/6
Verifying : mysql-community-common-5.7.29-1.el7.x86_64 1/6
Verifying : net-tools-2.0-0.24.20131004git.el7.x86_64 2/6
Verifying : mysql-community-client-5.7.29-1.el7.x86_64 3/6
Verifying : mysql-community-server-5.7.29-1.el7.x86_64 4/6
Verifying : libaio-0.3.109-13.el7.x86_64 5/6
Verifying : mysql-community-libs-5.7.29-1.el7.x86_64 6/6

Installed:
mysql-community-server.x86_64 0:5.7.29-1.el7

Dependency Installed:
libaio.x86_64 0:0.3.109-13.el7 mysql-community-client.x86_64 0:5.7.29-1.el7
mysql-community-common.x86_64 0:5.7.29-1.el7 mysql-community-libs.x86_64 0:5.7.29-1.el7
net-tools.x86_64 0:2.0-0.24.20131004git.el7

Complete!

学无止境201902
关注
专栏目录
mysql索引详解
学Java，找哪吒
07-07 10万+
MySQL的存储引擎架构将查询处理与数据的存储/提取相分离
Mysql获取最新记录
zhangxing
10-30 4002
前言 怎么获取Mysql表中同一标识(flag)下多条记录的最新记录呢？这里的宗旨是先order by time desc，其结构作为一个父表，然后再在父表中进行group by flag；这里值得注意的是，如果order by 与 group by在同一维度中的话，group by应该放在order by之前。 SQL示例 对于多张维表 select task.* from task_info task left join( select *
yum卡在Running Transaction Testde
yang.zhou欢迎各位
10-28 2055
真是奇怪，yum今天出了怪问题。一直卡在Running Transaction Testde，然后就按啥都不好使了。有点类似这样： … Running rpm_check_debug  Running Transaction Test   #yum clean all 是没有用滴，谷歌一下，这个帖子给我启示： http://forums.fedora
Running transaction check，yum卡在这个地方不动了
u014196765的博客
08-30 781
如果运行还不成功，那么重启服务器试试。我的服务器用了各种办法不行，最后重启服务器就好了。
One of the configured repositories failed (未知), and yum doesn‘t have enough cached data to continue
m0_73646990的博客
09-11 3017
由于CentOS的源地址内容已移除，CentOS 操作系统结束了生命周期，源地址内容已移除。只需要将它的base源换成其他可用源，我这里将它换成了阿里的base源。相关命令，就可以正常使用了。
yum错误---Running Transaction
q601046124的专栏
07-03 3271
yum错误---TypeError: rpmdb open failed  一、错误信息 今天使用yum的时候出现的报错，如下是报错和解决的办法 rpmdb: Thread/process 28879/3086964416 failed: Thread died in Berkeley DB library error: db4 error(-30975) from dbe
Centos7 安装mysql5.7
z60015260的博客
08-25 1308
1.在Centos7中默认安装有MariaDB，这个是MySQL的分支，但为了需要，还是要在系统中安装MySQL，通过yum安装完成之后可以自动覆盖掉MariaDB。5.重新执行yum -y install mysql-community-server， 看到以下打印则安装完成。MySQL有密码设置的规范，具体是与validate_password_policy的值有关。2.下载并安装MySQL官方的 Yum Repository。8.更改mysql密码，查看msql临时密码。7.查看MySQL运行状态。
Linux安装MySql 与 远程连接错误代码1045
清峰的博客
12-04 941
阿里云Centos7在线安装mysql5.7：https://blog.csdn.net/qq279862451/article/details/81486921 mysql远程连接错误代码1045 1、关闭防火墙 2、给mysql添加权限 解决方法： 在远程机上（192.168.30.14）进行设置 登录mysql客户端 1、给mysql添加权限 Grant all privileges on . to ‘root’@’%’ identified by ‘password’; root是mysql
mysql 数据表中查找重复记录
01-19
您可能感兴趣的文章:浅谈MySQL临时表与派生表Mysql跨表更新 多表update sql语句总结mysql锁表和解锁语句分享MySQL中基本的多表连接查询教程MySQL表字段设置默认值(图文教程及注意细节)MySQL中使用表别名与字段别名...
MySQL记录
生活是一种修炼
08-26 425
# 查询表在哪个数据库 SELECT table_schema FROM information_schema.TABLES WHERE table_name = 'push_app'; # mysql中查询一个字段具体是属于哪一个数据库的那一张表：用这条语句就能查询出来,其中 table_schema 是所在库, table_name 是所在表 SELECT table_schema, ...
MySQL 5.7升级MySQL 8.0过程记录
最新发布
10-18
MySQL 5.7升级MySQL 8.0过程记录
Transaction check error
qq_30602569的博客
02-13 1181
yum安装软件时，报错Transaction check error，说明rpm软件包出现了冲突。会查询出具体和哪些软件包冲突了。然后执行【yum remove 刚刚查询出来的冲突的软件包】即可。解决办法：执行【yum list installed | grep 冲突的软件包名字】。
Centos7 安装和配置MySQL5.7
qq_37654381的博客
02-25 142
第一步，下载MySQL安装 cd /usr/local wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm yum -y localinstall mysql57-community-release-el7-11.noarch.rpm 第二步，在线安装MySQL yum -y install my...
centos7 更新网络源，下载扩展源时出现“one of the configured repositories failed”提示，解决方案
ANoben的博客
06-21 2511
网络源保障问题 将其中所有的mirrorlist代码段注释掉，将baseurl取消注释，再执行清理缓存、建立缓存、yum update 就可以了第二种，超级简单切换个网络，换个网试试。（亲测有效）
yum install 提示 Error: Nothing to do
滴水穿石的启示
03-25 4078
正在解析主机 repo.mysql.com (repo.mysql.com)... 失败：未知的名称或服务（解决方案）
m0_56983111的博客
10-14 779
Centos，DNS服务器无法找到对应的主机IP
MySQL 记录
shpunishment的博客
02-18 243
limit_time = date_add( limit_time, INTERVAL ( SELECT TimeStampDiff( DAY, now(), apply_time ) ) + 1 DAY ) ,
易语言mysql查找记录_易语言应用接口支持库MySql支持库查找记录
weixin_30350163的博客
01-19 2468
查找记录是我们执行mysql数据库的基本操作，查找满足条件的记录,返回记录集句柄.注意执行这条语句后不需要再执行 返回记录集 命令。查找记录查找记录 命令 操作系统支持：Windows 所属类别：MySql支持库查找满足条件的记录,返回记录集句柄.注意执行这条语句后不需要再执行 返回记录集 命令。语法： 整数型 查找记录 (MySql句柄，表名，字段名，查找条件，排序条件)参数名描述MySql句柄...
Linux安装Mysql方法及相关报错处理
Lie_Jiu的博客
02-22 1748
使用Linux安装Mysql详细步骤，及The GPG keys listed for the "MySQL 5.7 Community Server"...报错处理
centeros7安装mysql5.7,CenterOS7在线安装mysql5.7
weixin_34892992的博客
04-01 422
首先对于开源软件自己要学会看官方文档去搞定它，不管官方文档是英文的还是中文的。网上安装mysql的文章有很多，基本是别人经过自己的实践总结的，你按照这个步骤是可以的。表面上你是节省了时间，但你却失去了研究新东西的能力。我分享的是一个依据官方文档和自己的经验在centerOS7上在线安装mysql5.7版本的教程。首先打开mysql官网 https://dev.mysql.com/因为官网是不断更新...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值