热门标签
热门文章
- 1Running as user "root" and group "root". This could be dangerous. tshark: Lua: Error during loading:_wireshark running as user "root" and group "root".
- 2小程序——图片上传预览及后台接口存储_微信小程序上传图片时不需要调接口吗,上传完了以后只需要调一个保存的接口
- 3idea2020.2.3中gradle配置说明_idea gradle参数说明
- 4外包干了一个月，忘记Git怎么使用了...
- 5SharePreferences使用总结,优缺点（包含升级篇，深入理解，面试必读）
- 6【技能提升】想知道如何免证书打包ipa
- 7C++学习（四二零）如何查看手机的架构abi_c++ 获取android abi
- 8解决pycharm中报ModuleNotFoundError: No module named ‘tensorflow‘错误_modulenotfounderror: no module named 'tensorflow
- 9汇编语言代码转换_汇编语言转化
- 10html隐藏地址栏,javascript – 如何隐藏移动浏览器的地址栏？
当前位置: article > 正文
mysql服务
作者：Cpp五条 | 2024-03-28 21:48:20
赞
踩
mysql服务
常见的关系型数据库管理系统：
- MySQL：MySQL，MariaDB，Percona-Server
- PostgreSQL：简称为pgsql
- Oracle
- MSSQL
mysql的安装
- 源代码：编译安装
- 二进制格式的程序包：展开至特定路径，并经过简单配置后即可使用
- 程序包管理器管理的程序包
配置mysql的yum源
- [root@xk ~]# cd /etc/yum.repos.d/
- [root@xk yum.repos.d]# ls
- [root@xk yum.repos.d]# yum list all|grep mysql
- [root@xk yum.repos.d]# cd
- [root@xk ~]# rpm -Uvh http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
- Retrieving http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
- warning: /var/tmp/rpm-tmp.eUeMx4: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
- Verifying... ################################# [100%]
- Preparing... ################################# [100%]
- Updating / installing...
- 1:mysql57-community-release-el7-10 ################################# [100%]
- [root@xk ~]# ls /etc/yum.repos.d/
- mysql-community.repo mysql-community-source.repo
- [root@xk ~]# yum clean all
- 15 files removed
- [root@xk ~]# yum makecache
- MySQL Connectors Community 1.4 kB/s | 53 kB 00:38
- MySQL Tools Community 682 kB/s | 778 kB 00:01
- MySQL 5.7 Community Server 1.7 MB/s | 2.8 MB 00:01
- Metadata cache created.
- [root@xk ~]# yum list all|grep mysql
- mysql57-community-release.noarch el7-10 @System
- mysql-community-client.i686 5.7.40-1.el7 mysql57-community
- mysql-community-client.x86_64 5.7.40-1.el7 mysql57-community
- mysql-community-common.i686 5.7.40-1.el7 mysql57-community
- mysql-community-common.x86_64 5.7.40-1.el7 mysql57-community
- mysql-community-devel.i686 5.7.40-1.el7 mysql57-community
- mysql-community-devel.x86_64 5.7.40-1.el7 mysql57-community
- mysql-community-embedded.i686 5.7.40-1.el7 mysql57-community
- mysql-community-embedded.x86_64 5.7.40-1.el7 mysql57-community
- mysql-community-embedded-compat.i686 5.7.40-1.el7 mysql57-community
- mysql-community-embedded-compat.x86_64 5.7.40-1.el7 mysql57-community
- mysql-community-embedded-devel.i686 5.7.40-1.el7 mysql57-community
- mysql-community-embedded-devel.x86_64 5.7.40-1.el7 mysql57-community
- mysql-community-libs.i686 5.7.40-1.el7 mysql57-community
- mysql-community-libs.x86_64 5.7.40-1.el7 mysql57-community
- mysql-community-libs-compat.i686 5.7.40-1.el7 mysql57-community
- mysql-community-libs-compat.x86_64 5.7.40-1.el7 mysql57-community
- mysql-community-release.noarch el7-5 mysql-connectors-community
- mysql-community-release.noarch el7-5 mysql-tools-community
- mysql-community-server.x86_64 5.7.40-1.el7 mysql57-community
- mysql-community-test.x86_64 5.7.40-1.el7 mysql57-community
- mysql-connector-c++.x86_64 8.0.31-1.el7 mysql-connectors-community
- mysql-connector-c++-devel.x86_64 8.0.31-1.el7 mysql-connectors-community
- mysql-connector-c++-jdbc.x86_64 8.0.31-1.el7 mysql-connectors-community
- mysql-connector-j.noarch 1:8.0.31-1.el7 mysql-connectors-community
- mysql-connector-java.noarch 1:8.0.30-1.el7 mysql-connectors-community
- mysql-connector-odbc.x86_64 8.0.31-1.el7 mysql-connectors-community
- mysql-connector-odbc-setup.x86_64 8.0.31-1.el7 mysql-connectors-community
- mysql-connector-python.noarch 2.0.4-1.el7 mysql-connectors-community
- mysql-connector-python.x86_64 8.0.23-1.el7 mysql-connectors-community
- mysql-connector-python-cext.x86_64 8.0.21-1.el7 mysql-connectors-community
- mysql-connector-python3.x86_64 8.0.31-1.el7 mysql-connectors-community
- mysql-connector-python3-cext.x86_64 8.0.21-1.el7 mysql-connectors-community
- mysql-ref-manual-5.5-en-html-chapter.noarch 1-20170320 mysql57-community
- mysql-ref-manual-5.5-en-pdf.noarch 1-20170320 mysql57-community
- mysql-ref-manual-5.7-en-html-chapter.noarch 1-20220831 mysql57-community
- mysql-ref-manual-5.7-en-pdf.noarch 1-20220831 mysql57-community
- mysql-router.x86_64 8.0.12-1.el7 mysql-tools-community
- mysql-router-community.x86_64 8.0.31-1.el7 mysql-tools-community
- mysql-shell.x86_64 8.0.31-1.el7 mysql-tools-community
- mysql-utilities.noarch 1.6.5-1.el7 mysql-tools-community
- mysql-utilities-extra.noarch 1.5.6-1.el7 mysql-tools-community
- mysql-workbench-community.x86_64 8.0.22-1.
配置阿里云的基础源
- [root@xk ~]# curl -o /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-vault-8.5.2111.repo
- % Total % Received % Xferd Average Speed Time Time Time Current
- Dload Upload Total Spent Left Speed
- 100 2495 100 2495 0 0 12475 0 --:--:-- --:--:-- --:--:-- 12412
- [root@xk ~]# sed -i -e '/mirrors.cloud.aliyuncs.com/d' -e '/mirrors.aliyuncs.com/d' /etc/yum.repos.d/CentOS-Base.repo
- [root@xk ~]# yum clean all
- 15 files removed
- [root@xk ~]# yum makecache
- CentOS-8.5.2111 - Base - mirrors.aliyun.com 1.5 MB/s | 4.6 MB 00:03
- CentOS-8.5.2111 - Extras - mirrors.aliyun.com 64 kB/s | 10 kB 00:00
- CentOS-8.5.2111 - AppStream - mirrors.aliyun.com 2.4 MB/s | 8.4 MB 00:03
- MySQL Connectors Community 173 kB/s | 53 kB 00:00
- MySQL Tools Community 1.3 MB/s | 778 kB 00:00
- MySQL 5.7 Community Server 2.2 MB/s | 2.8 MB 00:01
- Metadata cache created.
- [root@xk ~]#
安装wget
- [root@xk ~]# yum -y install wget
- Last metadata expiration check: 0:17:05 ago on Tue 27 Dec 2022 08:37:02 PM CST.
- Dependencies resolved.
- ========================================================================================================
- Package Architecture Version Repository Size
- ========================================================================================================
- Installing:
- wget x86_64 1.19.5-10.el8 AppStream 734 k
- Installing dependencies:
- libmetalink x86_64 0.1.3-7.el8 base 32 k
-
- Transaction Summary
- ========================================================================================================
- Install 2 Packages
-
- Total download size: 766 k
- Installed size: 2.8 M
- Downloading Packages:
- (1/2): libmetalink-0.1.3-7.el8.x86_64.rpm 177 kB/s | 32 kB 00:00
- (2/2): wget-1.19.5-10.el8.x86_64.rpm 959 kB/s | 734 kB 00:00
- --------------------------------------------------------------------------------------------------------
- Total 999 kB/s | 766 kB 00:00
- Running transaction check
- Transaction check succeeded.
- Running transaction test
- Transaction test succeeded.
- Running transaction
- Preparing : 1/1
- Installing : libmetalink-0.1.3-7.el8.x86_64 1/2
- Installing : wget-1.19.5-10.el8.x86_64 2/2
- Running scriptlet: wget-1.19.5-10.el8.x86_64 2/2
- Verifying : libmetalink-0.1.3-7.el8.x86_64 1/2
- Verifying : wget-1.19.5-10.el8.x86_64 2/2
-
- Installed:
- libmetalink-0.1.3-7.el8.x86_64 wget-1.19.5-10.el8.x86_64
-
- Complete!
- [root@xk ~]#
下载五个包并查看
- [root@xk src]# wget http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-client-5.7.40-1.el7.x86_64.rpm http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-common-5.7.40-1.el7.x86_64.rpm http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-devel-5.7.40-1.el7.x86_64.rpm http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-libs-5.7.40-1.el7.x86_64.rpm http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-server-5.7.40-1.el7.x86_64.rpm
- --2022-12-27 21:03:17-- http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-client-5.7.40-1.el7.x86_64.rpm
- Resolving repo.mysql.com (repo.mysql.com)... 23.36.48.238
- Connecting to repo.mysql.com (repo.mysql.com)|23.36.48.238|:80... connected.
- HTTP request sent, awaiting response... 200 OK
- Length: 29373184 (28M) [application/x-redhat-package-manager]
- Saving to: ‘mysql-community-client-5.7.40-1.el7.x86_64.rpm’
-
- mysql-community-client-5. 100%[=====================================>] 28.01M 3.79MB/s in 8.3s
-
- 2022-12-27 21:03:25 (3.38 MB/s) - ‘mysql-community-client-5.7.40-1.el7.x86_64.rpm’ saved [29373184/29373184]
-
- --2022-12-27 21:03:25-- http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-common-5.7.40-1.el7.x86_64.rpm
- Reusing existing connection to repo.mysql.com:80.
- HTTP request sent, awaiting response... 200 OK
- Length: 318744 (311K) [application/x-redhat-package-manager]
- Saving to: ‘mysql-community-common-5.7.40-1.el7.x86_64.rpm’
-
- mysql-community-common-5. 100%[=====================================>] 311.27K --.-KB/s in 0.07s
-
- 2022-12-27 21:03:26 (4.30 MB/s) - ‘mysql-community-common-5.7.40-1.el7.x86_64.rpm’ saved [318744/318744]
-
- --2022-12-27 21:03:26-- http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-devel-5.7.40-1.el7.x86_64.rpm
- Reusing existing connection to repo.mysql.com:80.
- HTTP request sent, awaiting response... 200 OK
- Length: 4426916 (4.2M) [application/x-redhat-package-manager]
- Saving to: ‘mysql-community-devel-5.7.40-1.el7.x86_64.rpm’
-
- mysql-community-devel-5.7 100%[=====================================>] 4.22M 5.36MB/s in 0.8s
-
- 2022-12-27 21:03:26 (5.36 MB/s) - ‘mysql-community-devel-5.7.40-1.el7.x86_64.rpm’ saved [4426916/4426916]
-
- --2022-12-27 21:03:26-- http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-libs-5.7.40-1.el7.x86_64.rpm
- Reusing existing connection to repo.mysql.com:80.
- HTTP request sent, awaiting response... 200 OK
- Length: 2744456 (2.6M) [application/x-redhat-package-manager]
- Saving to: ‘mysql-community-libs-5.7.40-1.el7.x86_64.rpm’
-
- mysql-community-libs-5.7. 100%[=====================================>] 2.62M 5.91MB/s in 0.4s
-
- 2022-12-27 21:03:27 (5.91 MB/s) - ‘mysql-community-libs-5.7.40-1.el7.x86_64.rpm’ saved [2744456/2744456]
-
- --2022-12-27 21:03:27-- http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql-community-server-5.7.40-1.el7.x86_64.rpm
- Reusing existing connection to repo.mysql.com:80.
- HTTP request sent, awaiting response... 200 OK
- Length: 187168492 (178M) [application/x-redhat-package-manager]
- Saving to: ‘mysql-community-server-5.7.40-1.el7.x86_64.rpm’
-
- mysql-community-server-5. 100%[=====================================>] 178.50M 3.78MB/s in 51s
-
- 2022-12-27 21:04:18 (3.49 MB/s) - ‘mysql-community-server-5.7.40-1.el7.x86_64.rpm’ saved [187168492/187168492]
-
- FINISHED --2022-12-27 21:04:18--
- Total wall clock time: 1m 1s
- Downloaded: 5 files, 214M in 1m 1s (3.52 MB/s)
- [root@xk src]# ls
- debug mysql-community-devel-5.7.40-1.el7.x86_64.rpm
- kernels mysql-community-libs-5.7.40-1.el7.x86_64.rpm
- mysql-community-client-5.7.40-1.el7.x86_64.rpm mysql-community-server-5.7.40-1.el7.x86_64.rpm
- mysql-community-common-5.7.40-1.el7.x86_64.rpm
vim编辑修改为x86-64
- [root@xk src]# cd
- [root@xk ~]# cd /etc/yum.repos.d/
- [root@xk yum.repos.d]# ls
- CentOS-Base.repo mysql-community.repo mysql-community-source.repo
- [root@xk yum.repos.d]# yum -y install vim
- Last metadata expiration check: 0:31:01 ago on Tue 27 Dec 2022 08:37:02 PM CST.
- Package vim-enhanced-2:8.0.1763-16.el8.x86_64 is already installed.
- Dependencies resolved.
- Nothing to do.
- Complete!
- [root@xk yum.repos.d]# vim mysql-community.repo
-
- [mysql57-community]
- name=MySQL 5.7 Community Server
- baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/
- enabled=1
- gpgcheck=1
- gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
清理缓存重建
- [root@xk ~]# yum clean all
- 33 files removed
- [root@xk ~]# yum makecache
- CentOS-8.5.2111 - Base - mirrors.aliyun.com 3.2 MB/s | 4.6 MB 00:01
- CentOS-8.5.2111 - Extras - mirrors.aliyun.com 59 kB/s | 10 kB 00:00
- CentOS-8.5.2111 - AppStream - mirrors.aliyun.com 2.4 MB/s | 8.4 MB 00:03
- MySQL Connectors Community 107 kB/s | 53 kB 00:00
- MySQL Tools Community 761 kB/s | 778 kB 00:01
- MySQL 5.7 Community Server 1.5 MB/s | 2.8 MB 00:01
- Metadata cache created.
- [root@xk src]# yum -y localinstall *.rpm
- Last metadata expiration check: 0:04:23 ago on Tue 27 Dec 2022 09:13:22 PM CST.
- Dependencies resolved.
- ========================================================================================================
- Package Arch Version Repository Size
- ========================================================================================================
- Installing:
- mysql-community-client x86_64 5.7.40-1.el7 @commandline 28 M
- mysql-community-common x86_64 5.7.40-1.el7 @commandline 311 k
- mysql-community-devel x86_64 5.7.40-1.el7 @commandline 4.2 M
- mysql-community-libs x86_64 5.7.40-1.el7 @commandline 2.6 M
- mysql-community-server x86_64 5.7.40-1.el7 @commandline 178 M
- Installing dependencies:
- libpkgconf x86_64 1.4.2-1.el8 base 35 k
- ncurses-compat-libs x86_64 6.1-9.20180224.el8 base 328 k
- net-tools x86_64 2.0-0.52.20160912git.el8 base 322 k
- perl-Carp noarch 1.42-396.el8 base 30 k
- perl-Data-Dumper x86_64 2.167-399.el8 base 58 k
- perl-Digest noarch 1.17-395.el8 AppStream 27 k
- perl-Digest-MD5 x86_64 2.55-396.el8 AppStream 37 k
- perl-Encode x86_64 4:2.97-3.el8 base 1.5 M
- perl-Errno x86_64 1.28-420.el8 base 76 k
- perl-Exporter noarch 5.72-396.el8 base 34 k
- perl-File-Path noarch 2.15-2.el8 base 38 k
- perl-File-Temp noarch 0.230.600-1.el8 base 63 k
- perl-Getopt-Long noarch 1:2.50-4.el8 base 63 k
- perl-HTTP-Tiny noarch 0.074-1.el8 base 58 k
- perl-IO x86_64 1.38-420.el8 base 142 k
- perl-MIME-Base64 x86_64 3.15-396.el8 base 31 k
- perl-Net-SSLeay x86_64 1.88-1.module_el8.3.0+410+ff426aa3 AppStream 379 k
- perl-PathTools x86_64 3.74-1.el8 base 90 k
- perl-Pod-Escapes noarch 1:1.07-395.el8 base 20 k
- perl-Pod-Perldoc noarch 3.28-396.el8 base 86 k
- perl-Pod-Simple noarch 1:3.35-395.el8 base 213 k
- perl-Pod-Usage noarch 4:1.69-395.el8 base 34 k
- perl-Scalar-List-Utils x86_64 3:1.49-2.el8 base 68 k
- perl-Socket x86_64 4:2.027-3.el8 base 59 k
- perl-Storable x86_64 1:3.11-3.el8 base 98 k
- perl-Term-ANSIColor noarch 4.06-396.el8 base 46 k
- perl-Term-Cap noarch 1.17-395.el8 base 23 k
- perl-Text-ParseWords noarch 3.30-395.el8 base 18 k
- perl-Text-Tabs+Wrap noarch 2013.0523-395.el8 base 24 k
- perl-Time-Local noarch 1:1.280-1.el8 base 34 k
- perl-URI noarch 1.73-3.el8 AppStream 116 k
- perl-Unicode-Normalize x86_64 1.25-396.el8 base 82 k
- perl-constant noarch 1.33-396.el8 base 25 k
- perl-interpreter x86_64 4:5.26.3-420.el8 base 6.3 M
- perl-libnet noarch 3.11-3.el8 AppStream 121 k
- perl-libs x86_64 4:5.26.3-420.el8 base 1.6 M
- perl-macros x86_64 4:5.26.3-420.el8 base 72 k
- perl-parent noarch 1:0.237-1.el8 base 20 k
- perl-podlators noarch 4.11-1.el8 base 118 k
- perl-threads x86_64 1:2.21-2.el8 base 61 k
- perl-threads-shared x86_64 1.58-2.el8 base 48 k
- pkgconf x86_64 1.4.2-1.el8 base 38 k
- pkgconf-m4 noarch 1.4.2-1.el8 base 17 k
- pkgconf-pkg-config x86_64 1.4.2-1.el8 base 15 k
- Installing weak dependencies:
- perl-IO-Socket-IP noarch 0.39-5.el8 AppStream 47 k
- perl-IO-Socket-SSL noarch 2.066-4.module_el8.3.0+410+ff426aa3 AppStream 298 k
- perl-Mozilla-CA noarch 20160104-7.module_el8.3.0+416+dee7bcef AppStream 15 k
- Enabling module streams:
- perl 5.26
- perl-IO-Socket-SSL 2.066
- perl-libwww-perl 6.34
-
- Transaction Summary
- ========================================================================================================
- Install 52 Packages
-
- Total size: 227 M
- Total download size: 13 M
- Installed size: 956 M
- Downloading Packages:
- (1/47): libpkgconf-1.4.2-1.el8.x86_64.rpm 6.7 kB/s | 35 kB 00:05
- (2/47): ncurses-compat-libs-6.1-9.20180224.el8.x86_64.rpm 60 kB/s | 328 kB 00:05
- (3/47): net-tools-2.0-0.52.20160912git.el8.x86_64.rpm 58 kB/s | 322 kB 00:05
- (4/47): perl-Data-Dumper-2.167-399.el8.x86_64.rpm 387 kB/s | 58 kB 00:00
- (5/47): perl-Carp-1.42-396.el8.noarch.rpm 68 kB/s | 30 kB 00:00
- (6/47): perl-Exporter-5.72-396.el8.noarch.rpm 199 kB/s | 34 kB 00:00
- (7/47): perl-Errno-1.28-420.el8.x86_64.rpm 422 kB/s | 76 kB 00:00
- (8/47): perl-File-Path-2.15-2.el8.noarch.rpm 182 kB/s | 38 kB 00:00
- (9/47): perl-File-Temp-0.230.600-1.el8.noarch.rpm 310 kB/s | 63 kB 00:00
- (10/47): perl-HTTP-Tiny-0.074-1.el8.noarch.rpm 352 kB/s | 58 kB 00:00
- (11/47): perl-IO-1.38-420.el8.x86_64.rpm 961 kB/s | 142 kB 00:00
- (12/47): perl-Getopt-Long-2.50-4.el8.noarch.rpm 189 kB/s | 63 kB 00:00
- (13/47): perl-MIME-Base64-3.15-396.el8.x86_64.rpm 154 kB/s | 31 kB 00:00
- (14/47): perl-PathTools-3.74-1.el8.x86_64.rpm 465 kB/s | 90 kB 00:00
- (15/47): perl-Encode-2.97-3.el8.x86_64.rpm 1.3 MB/s | 1.5 MB 00:01
- (16/47): perl-Pod-Escapes-1.07-395.el8.noarch.rpm 118 kB/s | 20 kB 00:00
- (17/47): perl-Pod-Perldoc-3.28-396.el8.noarch.rpm 473 kB/s | 86 kB 00:00
- (18/47): perl-Pod-Usage-1.69-395.el8.noarch.rpm 245 kB/s | 34 kB 00:00
- (19/47): perl-Scalar-List-Utils-1.49-2.el8.x86_64.rpm 310 kB/s | 68 kB 00:00
- (20/47): perl-Pod-Simple-3.35-395.el8.noarch.rpm 836 kB/s | 213 kB 00:00
- (21/47): perl-Socket-2.027-3.el8.x86_64.rpm 547 kB/s | 59 kB 00:00
- (22/47): perl-Term-ANSIColor-4.06-396.el8.noarch.rpm 249 kB/s | 46 kB 00:00
- (23/47): perl-Term-Cap-1.17-395.el8.noarch.rpm 102 kB/s | 23 kB 00:00
- (24/47): perl-Storable-3.11-3.el8.x86_64.rpm 343 kB/s | 98 kB 00:00
- (25/47): perl-Text-ParseWords-3.30-395.el8.noarch.rpm 143 kB/s | 18 kB 00:00
- (26/47): perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch.rpm 187 kB/s | 24 kB 00:00
- (27/47): perl-Unicode-Normalize-1.25-396.el8.x86_64.rpm 710 kB/s | 82 kB 00:00
- (28/47): perl-constant-1.33-396.el8.noarch.rpm 234 kB/s | 25 kB 00:00
- (29/47): perl-Time-Local-1.280-1.el8.noarch.rpm 146 kB/s | 34 kB 00:00
- (30/47): perl-macros-5.26.3-420.el8.x86_64.rpm 221 kB/s | 72 kB 00:00
- (31/47): perl-parent-0.237-1.el8.noarch.rpm 98 kB/s | 20 kB 00:00
- (32/47): perl-podlators-4.11-1.el8.noarch.rpm 423 kB/s | 118 kB 00:00
- (33/47): perl-threads-2.21-2.el8.x86_64.rpm 269 kB/s | 61 kB 00:00
- (34/47): perl-libs-5.26.3-420.el8.x86_64.rpm 1.2 MB/s | 1.6 MB 00:01
- (35/47): perl-threads-shared-1.58-2.el8.x86_64.rpm 233 kB/s | 48 kB 00:00
- (36/47): pkgconf-1.4.2-1.el8.x86_64.rpm 359 kB/s | 38 kB 00:00
- (37/47): pkgconf-m4-1.4.2-1.el8.noarch.rpm 129 kB/s | 17 kB 00:00
- (38/47): pkgconf-pkg-config-1.4.2-1.el8.x86_64.rpm 154 kB/s | 15 kB 00:00
- (39/47): perl-Digest-1.17-395.el8.noarch.rpm 233 kB/s | 27 kB 00:00
- (40/47): perl-Digest-MD5-2.55-396.el8.x86_64.rpm 284 kB/s | 37 kB 00:00
- (41/47): perl-IO-Socket-IP-0.39-5.el8.noarch.rpm 250 kB/s | 47 kB 00:00
- (42/47): perl-Mozilla-CA-20160104-7.module_el8.3.0+416+dee7bcef.noarch. 77 kB/s | 15 kB 00:00
- (43/47): perl-IO-Socket-SSL-2.066-4.module_el8.3.0+410+ff426aa3.noarch. 650 kB/s | 298 kB 00:00
- (44/47): perl-URI-1.73-3.el8.noarch.rpm 494 kB/s | 116 kB 00:00
- (45/47): perl-Net-SSLeay-1.88-1.module_el8.3.0+410+ff426aa3.x86_64.rpm 799 kB/s | 379 kB 00:00
- (46/47): perl-libnet-3.11-3.el8.noarch.rpm 590 kB/s | 121 kB 00:00
- (47/47): perl-interpreter-5.26.3-420.el8.x86_64.rpm 1.5 MB/s | 6.3 MB 00:04
- --------------------------------------------------------------------------------------------------------
- Total 1.1 MB/s | 13 MB 00:11
- Running transaction check
- Transaction check succeeded.
- Running transaction test
- Transaction test succeeded.
- Running transaction
- Preparing : 1/1
- Installing : perl-Digest-1.17-395.el8.noarch 1/52
- Installing : perl-Digest-MD5-2.55-396.el8.x86_64 2/52
- Installing : perl-Data-Dumper-2.167-399.el8.x86_64 3/52
- Installing : perl-libnet-3.11-3.el8.noarch 4/52
- Installing : perl-Net-SSLeay-1.88-1.module_el8.3.0+410+ff426aa3.x86_64 5/52
- Installing : perl-URI-1.73-3.el8.noarch 6/52
- Installing : perl-Pod-Escapes-1:1.07-395.el8.noarch 7/52
- Installing : perl-Time-Local-1:1.280-1.el8.noarch 8/52
- Installing : perl-IO-Socket-IP-0.39-5.el8.noarch 9/52
- Installing : perl-Mozilla-CA-20160104-7.module_el8.3.0+416+dee7bcef.noarch 10/52
- Installing : perl-IO-Socket-SSL-2.066-4.module_el8.3.0+410+ff426aa3.noarch 11/52
- Installing : perl-Term-ANSIColor-4.06-396.el8.noarch 12/52
- Installing : perl-Term-Cap-1.17-395.el8.noarch 13/52
- Installing : perl-File-Temp-0.230.600-1.el8.noarch 14/52
- Installing : perl-Pod-Simple-1:3.35-395.el8.noarch 15/52
- Installing : perl-HTTP-Tiny-0.074-1.el8.noarch 16/52
- Installing : perl-podlators-4.11-1.el8.noarch 17/52
- Installing : perl-Pod-Perldoc-3.28-396.el8.noarch 18/52
- Installing : perl-Text-ParseWords-3.30-395.el8.noarch 19/52
- Installing : perl-Pod-Usage-4:1.69-395.el8.noarch 20/52
- Installing : perl-MIME-Base64-3.15-396.el8.x86_64 21/52
- Installing : perl-Storable-1:3.11-3.el8.x86_64 22/52
- Installing : perl-Getopt-Long-1:2.50-4.el8.noarch 23/52
- Installing : perl-Errno-1.28-420.el8.x86_64 24/52
- Installing : perl-Socket-4:2.027-3.el8.x86_64 25/52
- Installing : perl-Encode-4:2.97-3.el8.x86_64 26/52
- Installing : perl-Exporter-5.72-396.el8.noarch 27/52
- Installing : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 28/52
- Installing : perl-macros-4:5.26.3-420.el8.x86_64 29/52
- Installing : perl-parent-1:0.237-1.el8.noarch 30/52
- Installing : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch 31/52
- Installing : perl-Unicode-Normalize-1.25-396.el8.x86_64 32/52
- Installing : perl-File-Path-2.15-2.el8.noarch 33/52
- Installing : perl-IO-1.38-420.el8.x86_64 34/52
- Installing : perl-PathTools-3.74-1.el8.x86_64 35/52
- Installing : perl-constant-1.33-396.el8.noarch 36/52
- Installing : perl-threads-1:2.21-2.el8.x86_64 37/52
- Installing : perl-threads-shared-1.58-2.el8.x86_64 38/52
- Installing : perl-libs-4:5.26.3-420.el8.x86_64 39/52
- Installing : perl-Carp-1.42-396.el8.noarch 40/52
- Installing : perl-interpreter-4:5.26.3-420.el8.x86_64 41/52
- Installing : mysql-community-common-5.7.40-1.el7.x86_64 42/52
- Installing : mysql-community-libs-5.7.40-1.el7.x86_64 43/52
- Running scriptlet: mysql-community-libs-5.7.40-1.el7.x86_64 43/52
- Installing : pkgconf-m4-1.4.2-1.el8.noarch 44/52
- Installing : net-tools-2.0-0.52.20160912git.el8.x86_64 45/52
- Running scriptlet: net-tools-2.0-0.52.20160912git.el8.x86_64 45/52
- Installing : ncurses-compat-libs-6.1-9.20180224.el8.x86_64 46/52
- Installing : mysql-community-client-5.7.40-1.el7.x86_64 47/52
- Installing : libpkgconf-1.4.2-1.el8.x86_64 48/52
- Installing : pkgconf-1.4.2-1.el8.x86_64 49/52
- Installing : pkgconf-pkg-config-1.4.2-1.el8.x86_64 50/52
- Installing : mysql-community-devel-5.7.40-1.el7.x86_64 51/52
- Running scriptlet: mysql-community-server-5.7.40-1.el7.x86_64 52/52
- Installing : mysql-community-server-5.7.40-1.el7.x86_64 52/52
- Running scriptlet: mysql-community-server-5.7.40-1.el7.x86_64 52/52
- [/usr/lib/tmpfiles.d/mysql.conf:23] Line references path below legacy directory /var/run/, updating /var/run/mysqld → /run/mysqld; please update the tmpfiles.d/ drop-in file accordingly.
-
- Verifying : libpkgconf-1.4.2-1.el8.x86_64 1/52
- Verifying : ncurses-compat-libs-6.1-9.20180224.el8.x86_64 2/52
- Verifying : net-tools-2.0-0.52.20160912git.el8.x86_64 3/52
- Verifying : perl-Carp-1.42-396.el8.noarch 4/52
- Verifying : perl-Data-Dumper-2.167-399.el8.x86_64 5/52
- Verifying : perl-Encode-4:2.97-3.el8.x86_64 6/52
- Verifying : perl-Errno-1.28-420.el8.x86_64 7/52
- Verifying : perl-Exporter-5.72-396.el8.noarch 8/52
- Verifying : perl-File-Path-2.15-2.el8.noarch 9/52
- Verifying : perl-File-Temp-0.230.600-1.el8.noarch 10/52
- Verifying : perl-Getopt-Long-1:2.50-4.el8.noarch 11/52
- Verifying : perl-HTTP-Tiny-0.074-1.el8.noarch 12/52
- Verifying : perl-IO-1.38-420.el8.x86_64 13/52
- Verifying : perl-MIME-Base64-3.15-396.el8.x86_64 14/52
- Verifying : perl-PathTools-3.74-1.el8.x86_64 15/52
- Verifying : perl-Pod-Escapes-1:1.07-395.el8.noarch 16/52
- Verifying : perl-Pod-Perldoc-3.28-396.el8.noarch 17/52
- Verifying : perl-Pod-Simple-1:3.35-395.el8.noarch 18/52
- Verifying : perl-Pod-Usage-4:1.69-395.el8.noarch 19/52
- Verifying : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 20/52
- Verifying : perl-Socket-4:2.027-3.el8.x86_64 21/52
- Verifying : perl-Storable-1:3.11-3.el8.x86_64 22/52
- Verifying : perl-Term-ANSIColor-4.06-396.el8.noarch 23/52
- Verifying : perl-Term-Cap-1.17-395.el8.noarch 24/52
- Verifying : perl-Text-ParseWords-3.30-395.el8.noarch 25/52
- Verifying : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch 26/52
- Verifying : perl-Time-Local-1:1.280-1.el8.noarch 27/52
- Verifying : perl-Unicode-Normalize-1.25-396.el8.x86_64 28/52
- Verifying : perl-constant-1.33-396.el8.noarch 29/52
- Verifying : perl-interpreter-4:5.26.3-420.el8.x86_64 30/52
- Verifying : perl-libs-4:5.26.3-420.el8.x86_64 31/52
- Verifying : perl-macros-4:5.26.3-420.el8.x86_64 32/52
- Verifying : perl-parent-1:0.237-1.el8.noarch 33/52
- Verifying : perl-podlators-4.11-1.el8.noarch 34/52
- Verifying : perl-threads-1:2.21-2.el8.x86_64 35/52
- Verifying : perl-threads-shared-1.58-2.el8.x86_64 36/52
- Verifying : pkgconf-1.4.2-1.el8.x86_64 37/52
- Verifying : pkgconf-m4-1.4.2-1.el8.noarch 38/52
- Verifying : pkgconf-pkg-config-1.4.2-1.el8.x86_64 39/52
- Verifying : perl-Digest-1.17-395.el8.noarch 40/52
- Verifying : perl-Digest-MD5-2.55-396.el8.x86_64 41/52
- Verifying : perl-IO-Socket-IP-0.39-5.el8.noarch 42/52
- Verifying : perl-IO-Socket-SSL-2.066-4.module_el8.3.0+410+ff426aa3.noarch 43/52
- Verifying : perl-Mozilla-CA-20160104-7.module_el8.3.0+416+dee7bcef.noarch 44/52
- Verifying : perl-Net-SSLeay-1.88-1.module_el8.3.0+410+ff426aa3.x86_64 45/52
- Verifying : perl-URI-1.73-3.el8.noarch 46/52
- Verifying : perl-libnet-3.11-3.el8.noarch 47/52
- Verifying : mysql-community-client-5.7.40-1.el7.x86_64 48/52
- Verifying : mysql-community-common-5.7.40-1.el7.x86_64 49/52
- Verifying : mysql-community-devel-5.7.40-1.el7.x86_64 50/52
- Verifying : mysql-community-libs-5.7.40-1.el7.x86_64 51/52
- Verifying : mysql-community-server-5.7.40-1.el7.x86_64 52/52
-
- Installed:
- libpkgconf-1.4.2-1.el8.x86_64
- mysql-community-client-5.7.40-1.el7.x86_64
- mysql-community-common-5.7.40-1.el7.x86_64
- mysql-community-devel-5.7.40-1.el7.x86_64
- mysql-community-libs-5.7.40-1.el7.x86_64
- mysql-community-server-5.7.40-1.el7.x86_64
- ncurses-compat-libs-6.1-9.20180224.el8.x86_64
- net-tools-2.0-0.52.20160912git.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-420.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-420.el8.x86_64
- perl-IO-Socket-IP-0.39-5.el8.noarch
- perl-IO-Socket-SSL-2.066-4.module_el8.3.0+410+ff426aa3.noarch
- perl-MIME-Base64-3.15-396.el8.x86_64
- perl-Mozilla-CA-20160104-7.module_el8.3.0+416+dee7bcef.noarch
- perl-Net-SSLeay-1.88-1.module_el8.3.0+410+ff426aa3.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-Text-Tabs+Wrap-2013.0523-395.el8.noarch
- perl-Time-Local-1:1.280-1.el8.noarch
- perl-URI-1.73-3.el8.noarch
- perl-Unicode-Normalize-1.25-396.el8.x86_64
- perl-constant-1.33-396.el8.noarch
- perl-interpreter-4:5.26.3-420.el8.x86_64
- perl-libnet-3.11-3.el8.noarch
- perl-libs-4:5.26.3-420.el8.x86_64
- perl-macros-4:5.26.3-420.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
- pkgconf-1.4.2-1.el8.x86_64
- pkgconf-m4-1.4.2-1.el8.noarch
- pkgconf-pkg-config-1.4.2-1.el8.x86_64
-
- Complete!
查看服务已存在
- [root@xk src]# cd
- [root@xk ~]# systemctl status mysqld
- ● mysqld.service - MySQL Server
- Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
- Active: inactive (dead)
- Docs: man:mysqld(8)
- http://dev.mysql.com/doc/refman/en/using-systemd.html
关闭防火墙
- [root@xk ~]# systemctl disable --now firewalld
- Removed /etc/systemd/system/multi-user.target.wants/firewalld.service.
- Removed /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
- [root@xk ~]# vim /etc/selinux/config
- # This file controls the state of SELinux on the system.
- # SELINUX= can take one of these three values:
- # enforcing - SELinux security policy is enforced.
- # permissive - SELinux prints warnings instead of enforcing.
- # disabled - No SELinux policy is loaded.
- SELINUX=disabled
- # SELINUXTYPE= can take one of these three values:
- # targeted - Targeted processes are protected,
- # minimum - Modification of targeted policy. Only selected processes are protected.
- # mls - Multi Level Security protection.
- SELINUXTYPE=targeted
[root@xk ~]# setenforce 0临时启动和开机自启
- [root@xk ~]# systemctl start mysqld
- [root@xk ~]# systemctl enable mysqld
查看发现已经启动且开机自启
- [root@xk ~]# systemctl status mysqld
- ● mysqld.service - MySQL Server
- Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
- Active: active (running) since Tue 2022-12-27 21:24:42 CST; 1min 34s ago
- Docs: man:mysqld(8)
- http://dev.mysql.com/doc/refman/en/using-systemd.html
- Main PID: 27371 (mysqld)
- Tasks: 27 (limit: 5790)
- Memory: 286.8M
- CGroup: /system.slice/mysqld.service
- └─27371 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
-
- Dec 27 21:24:40 xk systemd[1]: Starting MySQL Server...
- Dec 27 21:24:42 xk systemd[1]: Started MySQL Server.
端口号3066已经监听
- [root@xk ~]# ss -antl
- State Recv-Q Send-Q Local Address:Port Peer Address:Port Process
- LISTEN 0 128 0.0.0.0:22 0.0.0.0:*
- LISTEN 0 80 *:3306 *:*
- LISTEN 0 128 [::]:22 [::]:*
在日志找到临时密码
- [root@xk ~]# grep password /var/log/mysqld.log
- 2022-12-27T13:24:40.769060Z 1 [Note] A temporary password is generated for root@localhost: <kh7Y19bHJqJ
用获取的密码临时登录mysql
- [root@xk ~]# mysql -urroot -p'<kh7Y19bHJqJ'
- mysql: [Warning] Using a password on the command line interface can be insecure.
- ERROR 1045 (28000): Access denied for user 'rroot'@'localhost' (using password: YES)
- [root@xk ~]# mysql -uroot -p'<kh7Y19bHJqJ'
- mysql: [Warning] Using a password on the command line interface can be insecure.
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 3
- Server version: 5.7.40
-
- Copyright (c) 2000, 2022, Oracle and/or its affiliates.
-
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
-
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
-
- mysql>
改密码
- mysql> set password = password("Xukang123!");
- Query OK, 0 rows affected, 1 warning (0.00 sec)
-
- mysql> quit
- Bye
验证密码是否设置成功
- [root@xk ~]# mysql -uroot -p'Xukang123!'
- mysql: [Warning] Using a password on the command line interface can be insecure.
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 4
- Server version: 5.7.40 MySQL Community Server (GPL)
-
- Copyright (c) 2000, 2022, Oracle and/or its affiliates.
-
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
-
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
-
- mysql>
删掉yum源和多余文件
- [root@xk ~]# rpm -qa|grep mysql
- mysql-community-libs-5.7.40-1.el7.x86_64
- mysql-community-client-5.7.40-1.el7.x86_64
- mysql-community-devel-5.7.40-1.el7.x86_64
- mysql57-community-release-el7-10.noarch
- mysql-community-common-5.7.40-1.el7.x86_64
- mysql-community-server-5.7.40-1.el7.x86_64
- [root@xk ~]# rpm -e mysql57-community-release-el7-10.noarch
- warning: /etc/yum.repos.d/mysql-community.repo saved as /etc/yum.repos.d/mysql-community.repo.rpmsave
- [root@xk ~]# rpm -qa|grep mysql
- mysql-community-libs-5.7.40-1.el7.x86_64
- mysql-community-client-5.7.40-1.el7.x86_64
- mysql-community-devel-5.7.40-1.el7.x86_64
- mysql-community-common-5.7.40-1.el7.x86_64
- mysql-community-server-5.7.40-1.el7.x86_64
- [root@xk ~]# cd /etc/yum.repos.d/
- [root@xk yum.repos.d]# ls
- CentOS-Base.repo mysql-community.repo.rpmsave
- [root@xk yum.repos.d]# rm -f mysql-community.repo.rpmsave
- [root@xk yum.repos.d]# ls
- CentOS-Base.repo
- [root@xk yum.repos.d]#
设置安全初始化
- [root@xk ~]# mysql_secure_installation
-
- Securing the MySQL server deployment.
-
- Enter password for user root:
- The 'validate_password' plugin is installed on the server.
- The subsequent steps will run with the existing configuration
- of the plugin.
- 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) : n
-
- ... 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) : 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) : 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.
-
- Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
- Success.
-
- All done!
再次验证
- [root@xk ~]# mysql -uroot -p'Xukang123!'
- mysql: [Warning] Using a password on the command line interface can be insecure.
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 9
- Server version: 5.7.40 MySQL Community Server (GPL)
-
- Copyright (c) 2000, 2022, Oracle and/or its affiliates.
-
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
-
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
-
- mysql>
测试链接
给予权限
- mysql> grant all on *.* to 'root'@'192.168.154.1' identified by 'Xukang123!';
- Query OK, 0 rows affected, 1 warning (0.00 sec)
-
- mysql> flush privileges;
- Query OK, 0 rows affected (0.00 sec)
-
- mysql>
使用workbeach远程登录
使用Navicat远程登录
成功
声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Cpp五条/article/detail/331653
推荐阅读
相关标签
