Linux安装mysql总结

已于 2022-05-28 19:53:53 修改
阅读量746 收藏 3
点赞数
分类专栏： 数据库 文章标签： mysql linux 数据库
于 2022-05-28 19:49:33 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/looken1024/article/details/125021463
版权

1 查看是否已安装mysql，如果已安装先卸载

[work@lsdBKusFRn mysql]$ rpm -qa | grep mysql
mysql-common-8.0.26-1.module_el8.4.0+915+de215114.x86_64
mysql-8.0.26-1.module_el8.4.0+915+de215114.x86_64
mysql57-community-release-el7-10.noarch

可以看到之前有安装过mysql，先将其从系统卸载

[root@lsdBKusFRn ~]# yum remove mysql-common-8.0.26-1.module_el8.4.0+915+de215114.x86_64
Dependencies resolved.
========================================================================================================================================================================
 Package                                       Architecture              Version                                                    Repository                     Size
========================================================================================================================================================================
Removing:
 mysql-common                                  x86_64                    8.0.26-1.module_el8.4.0+915+de215114                       @AppStream                    460 k
Removing dependent packages:
 mysql                                         x86_64                    8.0.26-1.module_el8.4.0+915+de215114                       @AppStream                     63 M
Removing unused dependencies:
 mariadb-connector-c-config                    noarch                    3.1.11-2.el8_3                                             @AppStream                    497  

Transaction Summary
========================================================================================================================================================================
Remove  3 Packages

Freed space: 63 M
Is this ok [y/N]: y
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                                1/1 
  Erasing          : mysql-8.0.26-1.module_el8.4.0+915+de215114.x86_64                                                                                              1/3 
  Erasing          : mysql-common-8.0.26-1.module_el8.4.0+915+de215114.x86_64                                                                                       2/3 
  Erasing          : mariadb-connector-c-config-3.1.11-2.el8_3.noarch                                                                                               3/3 
  Running scriptlet: mariadb-connector-c-config-3.1.11-2.el8_3.noarch                                                                                               3/3 
  Verifying        : mariadb-connector-c-config-3.1.11-2.el8_3.noarch                                                                                               1/3 
  Verifying        : mysql-8.0.26-1.module_el8.4.0+915+de215114.x86_64                                                                                              2/3 
  Verifying        : mysql-common-8.0.26-1.module_el8.4.0+915+de215114.x86_64                                                                                       3/3 

Removed:
  mariadb-connector-c-config-3.1.11-2.el8_3.noarch    mysql-8.0.26-1.module_el8.4.0+915+de215114.x86_64    mysql-common-8.0.26-1.module_el8.4.0+915+de215114.x86_64   

Complete!
[root@lsdBKusFRn ~]# yum remove mysql-8.0.26-1.module_el8.4.0+915+de215114.x86_64
No match for argument: mysql-8.0.26-1.module_el8.4.0+915+de215114.x86_64
No packages marked for removal.
Dependencies resolved.
Nothing to do.
Complete!
[root@lsdBKusFRn ~]# yum remove mysql57-community-release-el7-10.noarch
Dependencies resolved.
========================================================================================================================================================================
 Package                                             Architecture                     Version                             Repository                               Size
========================================================================================================================================================================
Removing:
 mysql57-community-release                           noarch                           el7-10                              @@commandline                            30 k

Transaction Summary
========================================================================================================================================================================
Remove  1 Package

Freed space: 30 k
Is this ok [y/N]: y
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                                1/1 
  Erasing          : mysql57-community-release-el7-10.noarch                                                                                                        1/1 
  Verifying        : mysql57-community-release-el7-10.noarch                                                                                                        1/1 

Removed:
  mysql57-community-release-el7-10.noarch                                                                                                                               

Complete!

执行完卸载命令，我们再确认一下是否已从系统卸载完成

[root@lsdBKusFRn ~]# rpm -qa|grep mysql

没有任何输出，表示已经卸载完成

2 下载官方mysql安装包

按照需求从官网下载相应版本的mysql安装包

[root@lsdBKusFRn ~]# wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
--2022-05-28 18:12:48--  https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
Resolving dev.mysql.com (dev.mysql.com)... 137.254.60.11
Connecting to dev.mysql.com (dev.mysql.com)|137.254.60.11|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm [following]
--2022-05-28 18:12:49--  https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
Resolving repo.mysql.com (repo.mysql.com)... 23.58.116.230
Connecting to repo.mysql.com (repo.mysql.com)|23.58.116.230|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 25680 (25K) [application/x-redhat-package-manager]
Saving to: ‘mysql57-community-release-el7-11.noarch.rpm’

mysql57-community-release-el7-11.noarch.r 100%[=====================================================================================>]  25.08K   130KB/s    in 0.2s    

2022-05-28 18:12:50 (130 KB/s) - ‘mysql57-community-release-el7-11.noarch.rpm’ saved [25680/25680]

3 安装mysql

执行安装mysql源命令

[root@lsdBKusFRn ~]# yum -y localinstall mysql57-community-release-el7-11.noarch.rpm
Last metadata expiration check: 0:19:31 ago on Sat 28 May 2022 05:53:32 PM CST.
Dependencies resolved.
========================================================================================================================================================================
 Package                                              Architecture                      Version                           Repository                               Size
========================================================================================================================================================================
Installing:
 mysql57-community-release                            noarch                            el7-11                            @commandline                             25 k

Transaction Summary
========================================================================================================================================================================
Install  1 Package

Total size: 25 k
Installed size: 31 k
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                                1/1 
  Installing       : mysql57-community-release-el7-11.noarch                                                                                                        1/1 
  Verifying        : mysql57-community-release-el7-11.noarch                                                                                                        1/1 

Installed:
  mysql57-community-release-el7-11.noarch                                                                                                                               

Complete!

再安装mysql服务器

[root@lsdBKusFRn ~]# yum -y install mysql-community-server
Last metadata expiration check: 0:19:36 ago on Sat 28 May 2022 05:53:34 PM CST.
Dependencies resolved.
========================================================================================================================================================================
 Package                                         Architecture                    Version                               Repository                                  Size
========================================================================================================================================================================
Installing:
 mysql-community-server                          x86_64                          5.7.38-1.el7                          mysql57-community                          178 M
Installing dependencies:
 mysql-community-client                          x86_64                          5.7.38-1.el7                          mysql57-community                           28 M
 mysql-community-common                          x86_64                          5.7.38-1.el7                          mysql57-community                          311 k
 mysql-community-libs                            x86_64                          5.7.38-1.el7                          mysql57-community                          2.6 M

Transaction Summary
========================================================================================================================================================================
Install  4 Packages

Total size: 208 M
Installed size: 890 M
Downloading Packages:
[SKIPPED] mysql-community-client-5.7.38-1.el7.x86_64.rpm: Already downloaded                                                                                           
[SKIPPED] mysql-community-common-5.7.38-1.el7.x86_64.rpm: Already downloaded                                                                                           
[SKIPPED] mysql-community-libs-5.7.38-1.el7.x86_64.rpm: Already downloaded                                                                                             
[SKIPPED] mysql-community-server-5.7.38-1.el7.x86_64.rpm: Already downloaded                                                                                           
MySQL 5.7 Community Server                                                                                                               27 MB/s |  27 kB     00:00    
GPG key at file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql (0x5072E1F5) is already installed
The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package.
Check that the correct key URLs are configured for this repository.. Failing package is: mysql-community-client-5.7.38-1.el7.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Public key for mysql-community-common-5.7.38-1.el7.x86_64.rpm is not installed. Failing package is: mysql-community-common-5.7.38-1.el7.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Public key for mysql-community-libs-5.7.38-1.el7.x86_64.rpm is not installed. Failing package is: mysql-community-libs-5.7.38-1.el7.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Public key for mysql-community-server-5.7.38-1.el7.x86_64.rpm is not installed. Failing package is: mysql-community-server-5.7.38-1.el7.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
The downloaded packages were saved in cache until the next successful transaction.
You can remove cached packages by executing 'yum clean packages'.
Error: GPG check FAILED

注意到这一步有可能会报错：Error: GPG check FAILED，解决办法如下：添加–nogpgcheck参数

[root@lsdBKusFRn ~]# yum -y install mysql-community-server –nogpgcheck
Last metadata expiration check: 0:20:06 ago on Sat 28 May 2022 05:53:34 PM CST.
No match for argument: –nogpgcheck
Error: Unable to find a match: –nogpgcheck
[root@lsdBKusFRn ~]# yum install mysql-community-server --nogpgcheck
Last metadata expiration check: 0:20:17 ago on Sat 28 May 2022 05:53:34 PM CST.
Dependencies resolved.
========================================================================================================================================================================
 Package                                         Architecture                    Version                               Repository                                  Size
========================================================================================================================================================================
Installing:
 mysql-community-server                          x86_64                          5.7.38-1.el7                          mysql57-community                          178 M
Installing dependencies:
 mysql-community-client                          x86_64                          5.7.38-1.el7                          mysql57-community                           28 M
 mysql-community-common                          x86_64                          5.7.38-1.el7                          mysql57-community                          311 k
 mysql-community-libs                            x86_64                          5.7.38-1.el7                          mysql57-community                          2.6 M

Transaction Summary
========================================================================================================================================================================
Install  4 Packages

Total size: 208 M
Installed size: 890 M
Is this ok [y/N]: y
Downloading Packages:
[SKIPPED] mysql-community-client-5.7.38-1.el7.x86_64.rpm: Already downloaded                                                                                           
[SKIPPED] mysql-community-common-5.7.38-1.el7.x86_64.rpm: Already downloaded                                                                                           
[SKIPPED] mysql-community-libs-5.7.38-1.el7.x86_64.rpm: Already downloaded                                                                                             
[SKIPPED] mysql-community-server-5.7.38-1.el7.x86_64.rpm: Already downloaded                                                                                           
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                                1/1 
  Installing       : mysql-community-common-5.7.38-1.el7.x86_64                                                                                                     1/4 
  Installing       : mysql-community-libs-5.7.38-1.el7.x86_64                                                                                                       2/4 
  Running scriptlet: mysql-community-libs-5.7.38-1.el7.x86_64                                                                                                       2/4 
  Installing       : mysql-community-client-5.7.38-1.el7.x86_64                                                                                                     3/4 
  Running scriptlet: mysql-community-server-5.7.38-1.el7.x86_64                                                                                                     4/4 
  Installing       : mysql-community-server-5.7.38-1.el7.x86_64                                                                                                     4/4 
  Running scriptlet: mysql-community-server-5.7.38-1.el7.x86_64                                                                                                     4/4 
[/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        : mysql-community-client-5.7.38-1.el7.x86_64                                                                                                     1/4 
  Verifying        : mysql-community-common-5.7.38-1.el7.x86_64                                                                                                     2/4 
  Verifying        : mysql-community-libs-5.7.38-1.el7.x86_64                                                                                                       3/4 
  Verifying        : mysql-community-server-5.7.38-1.el7.x86_64                                                                                                     4/4 

Installed:
  mysql-community-client-5.7.38-1.el7.x86_64              mysql-community-common-5.7.38-1.el7.x86_64              mysql-community-libs-5.7.38-1.el7.x86_64             
  mysql-community-server-5.7.38-1.el7.x86_64             

Complete!

4 启动mysql

执行启动mysql命令

[root@lsdBKusFRn ~]# systemctl start mysqld.service

没有报错，没有输出，表示启动成功，执行以下命令验证是否已启动

[root@lsdBKusFRn ~]# service mysqld status
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Sat 2022-05-28 18:31:01 CST; 1min 15s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 234488 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
  Process: 234416 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 234491 (mysqld)
    Tasks: 28 (limit: 6010)
   Memory: 362.4M
   CGroup: /system.slice/mysqld.service
           └─234491 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

May 28 18:30:19 lsdBKusFRn systemd[1]: Starting MySQL Server...
May 28 18:31:01 lsdBKusFRn systemd[1]: Started MySQL Server.

当有以上输出时，表示mysql已成功启动

5 设置mysql登录密码

系统默认为root生成一个临时密码，查找方式如下：

[root@lsdBKusFRn ~]# grep 'temporary password' /var/log/mysqld.log
2022-05-28T10:30:58.944136Z 1 [Note] A temporary password is generated for root@localhost: PBtw&U5%7u>t

得到root密码是：PBtw&U5%7u>t，用该密码登录

[root@lsdBKusFRn ~]# mysql -hlocalhost -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.7.38

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>

如果需要修改root密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'QwerQwer@@@750';
Query OK, 0 rows affected (0.00 sec)

至此mysql安装完成，且可以正常登录

looken1024
关注
  • 0
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
第十六章 使用MariaDB数据库管理系统
龙狼刺的博客
05-17 1031
数据库是指按照某些特定结构来存储数据资料的数据仓库。在当今这个大数据技术迅速崛起的年代，互联网上每天都会生成海量的数据信息，数据库技术也从最初只能存储简单的表格数据的单一集中存储模式，发展到了现如今存储海量数据的大型分布式模式。在信息化社会中，能够充分有效地管理和利用各种数据，挖掘其中的价值，是进行科学研究与决策管理的重要前提。同时，数据库技术也是管理信息系统、办公自动化系统、决策支持系统等各类信息系统的核心组成部分，是进行科学研究和决策管理的重要技术手段。
centos8Linux搭建mysql5.7.26
qq_42712168的博客
02-03 201
Linux搭建mysql5.7.26 一. 查询是否搭建过mysql并删除之前的版本 1. 检查是否已经安装过mysql（新系统可能有自带的），执行以下命令： rpm -qa | grep -i mysql 2. 如果出现类似以下内容，请先执行删除命令 3. 删除命令 rpm -e --nodeps perl-DBD-MySQL-4.046-3.module_el8.1.0+203+e45423dc.x86_64 4. 再次执行检查命令，如出现下图内容，表示...
安装rpm包时提示错误：依赖检测失败
m0_71837291的博客
07-11 1万+
解决办法1，卸载mariadb -client-plugins并再次安装失败的rpm包 解决办法2，最后面加--nodeps --force
centos8.4安装mysql8
放飞梦想的专栏
01-17 1149
1.查看本机是否安装mysql rpm -qa | grep mysql 如果安装了，如下命令卸载： yum remove -y XXX包 rm -rf /var/lib/mysql && rm -rf /etc/my.cnf && rm -rf /usr/share/mysql find / -name mysql 2.安装rpm包 yum localinstall rpm包 3.安装服务 yum install mysql-server 4.查看mysql是否安装成
Linux下安装MySQL.docx
11-29
Linux 下安装 MySQL Linux 是一个开源的操作系统， MySQL 是一个开源的关系数据库管理系统。在 Linux 系统中安装 MySQL 是一个非常重要的步骤。本文将一步步指导您如何在 Linux 系统中安装 MySQL。 查找以前是否...
Linux安装MySQL相关总结文档
06-29
linux安装Mysql不兼容的解决办法。 Linux下查看Mysql的安装路径。 Linux完全删除MySQL
如何在Linux下安装MySQL 5.pdf
09-14
"MySQL 在 Linux 下的安装和使用" 本文主要介绍了如何在 Linux 下安装 MySQL 5.0，包括下载安装文件、安装 MySQL 服务器和客户端 serta 使用 MySQL 的基本选项。 一、MySQL 的安装 在 Linux 下安装 MySQL 需要...
linux上安装Mysql的问题总结
08-21
关于在linux服务器上安装高版本Mysql遇到的一系列问题总结
Linux下安装MySQL-总结
12-02
mysql-errmsg-8.0.26-1.module_el8.4.0+915+de215114.aarch64.rpm
12-04
离线安装包，亲测可用
mysql-connector-java-3.1.11-bin.jar
07-01
mysql数据库驱动
CentOS8系统下安装MySQL8.x遇到的坑
qq_38817391的博客
12-12 2583
CentOS8系统下安装MySQL8.x遇到的坑 前言：我们知道在Linux环境下默认是区分大小写的，而MySQL在官方文档中明确表示了，一旦MySQL启动后，将无法再进行配置，只能进行重装，如果数据不重要倒是无所谓，但是如果有重要数据那是真的大坑。 如果启动之后再去更改/etc/my.cnf，那么重启MySQL就会出现如下错误： Job for mysqld.service failed be...
CENTOS上的网络安全工具（七）MYSQL也不能少
lhyzws的专栏
05-24 1399
记录了在CENTOS8上在线以及离线安装mysql数据的过程，并简述了配置vscode进行远程数据库编程的基本操作。
今天遇到的mysql8.0的新特性（坑）和解决办法
热门推荐
白日梦想家的博客
05-29 4万+
一、创建用户和授权      在mysql8.0创建用户和授权和之前不太一样了，其实严格上来讲，也不能说是不一样,只能说是更严格,mysql8.0需要先创建用户和设置密码,然后才能授权。#先创建一个用户create user 'hong'@'%' identified by '123123';#再进行授权grant all privileges on *.* to 'hong'@'%' with ...
MYSQL 安装时出现的问题error: Failed dependencies
80后大叔爱学习
09-18 3万+
1、错误1：error: Failed dependencies: mysql-community-common(x86-64) >= 5.7.9 is needed by mysql-community-libs-5.7.23-1.el7.x86_64 mariadb-libs is obsoleted by mysql-community-libs-5.7...
数据库:MySQL和MariaDB的JDBC连接
岁月求索
05-26 2万+
目录 QUESTION:MySQL和MariaDB的JDBC连接？ ANSWER: 区别与联系： MySQL： MariaDB： java连接mariaDB数据库的设置：(tomcat 8) 第一种方法：使用tomcat自带的mysql-connector-java-5.1.40-bin.jar： 第二种，使用mariadb的jdbc Driver： QUESTION:My...
java连接mariaDB的设置
小旋锋 的博客
10-07 3万+
java连接mariaDB数据库的设置：(tomcat 8) 第一种方法：使用tomcat自带的mysql-connector-java-5.1.40-bin.jar java代码中的设置： driver驱动类为：com.mysql.jdbc.Driver url为jdbc:mysql://localhost:3306/dbName ··· String driver =“c
linux安装mysql8.0 yum
最新发布
07-29
要在Linux上使用yum安装MySQL 8.0，你可以按照以下步骤进行操作： 1. 首先，你需要访问MySQL官方网站的安装教程，链接为\[1\]。这个教程提供了关于在Linux上安装MySQL的详细说明。 2. 根据你的Linux系统版本，选择合适的MySQL版本。例如，如果你的系统是CentOS 7.6，你可以使用命令`yum localinstall https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm`来安装MySQL的yum数据源。请确保在安装过程中按照提示输入两次"y"来确认安装。 3. 如果你的Linux系统已经安装了Docker，你也可以考虑使用Docker来安装MySQL。你可以参考\[3\]中提供的Docker安装MySQL 8并配置远程连接的教程。 总结起来，要在Linux上使用yum安装MySQL 8.0，你需要先安装MySQL的yum数据源，然后根据系统版本选择合适的MySQL版本进行安装。希望这些信息对你有帮助。 \[1\] https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html#yum-repo-installing-mysql \[2\] 引用内容中没有提供相关信息 \[3\] 引用内容中没有提供相关信息 #### 引用[.reference_title] - *1* [Linux基于yum安装mysql8](https://blog.csdn.net/shenya2/article/details/81322036)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item] - *2* *3* [linux yum安装mysql8](https://blog.csdn.net/qq_26462567/article/details/102475057)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item] [ .reference_list ]

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

looken1024

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值