centos7安装mysql5.7

最新推荐文章于 2023-06-27 08:12:23 发布
最新推荐文章于 2023-06-27 08:12:23 发布
阅读量140 收藏
点赞数
分类专栏： mysql 文章标签： mysql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_42392337/article/details/116712740
版权

centos7安装mysql5.7

mysql安装包:
链接：https://pan.baidu.com/s/1FrndAHB_9hPTvZvjgs96Ww
提取码：rycs

1.卸载CentOS7系统自带的mariadb

查看是否存在mariadb

[root@demo software]# rpm -qa | grep mariadb
mariadb-libs-5.5.52-1.el7.x86_64

删除mariadb

[root@demo software]# rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64
[root@demo software]# rpm -qa | grep mariadb
[root@demo software]#

2.解压mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar

[root@demo mysql_package]# tar xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar 
mysql-community-embedded-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
mysql-community-devel-5.7.28-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-5.7.28-1.el7.x86_64.rpm
mysql-community-test-5.7.28-1.el7.x86_64.rpm
mysql-community-common-5.7.28-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.28-1.el7.x86_64.rpm
mysql-community-client-5.7.28-1.el7.x86_64.rpm
mysql-community-server-5.7.28-1.el7.x86_64.rpm

3.依次解压以下rpm包

[root@demo mysql_package]# rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm 
warning: mysql-community-common-5.7.28-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-common-5.7.28-1.e################################# [100%]


[root@demo mysql_package]# rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm 
warning: mysql-community-libs-5.7.28-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-libs-5.7.28-1.el7################################# [100%]

[root@demo mysql_package]# rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm 
warning: mysql-community-client-5.7.28-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-client-5.7.28-1.e################################# [100%]


[root@demo mysql_package]# rpm -ivh mysql-community-devel-5.7.28-1.el7.x86_64.rpm 
warning: mysql-community-devel-5.7.28-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-devel-5.7.28-1.el################################# [100%]

[root@demo mysql_package]# rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm 
warning: mysql-community-server-5.7.28-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-server-5.7.28-1.e################################# [100%]

注意：安装过程可能遇到以下问题【没问题则跳过这一步】

1).缺少libaio

> # rpm -ivh mysql-community-server-5.7.17-1.el7.x86_64.rpm 
>
> 警告：mysql-community-server-5.7.17-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
> 错误：依赖检测失败：
> libaio.so.1()(64bit) 被 mysql-community-server-5.7.17-1.el7.x86_64 需要
> libaio.so.1(LIBAIO_0.1)(64bit) 被 mysql-community-server-5.7.17-1.el7.x86_64 需要
> libaio.so.1(LIBAIO_0.4)(64bit) 被 mysql-community-server-5.7.17-1.el7.x86_64 需要
> net-tools 被 mysql-community-server-5.7.17-1.el7.x86_64 需要
> 解决办法：
> yum install libaio


2)缺少net-tools

> rpm -ivh mysql-community-server-5.7.17-1.el7.x86_64.rpm 
> 警告：mysql-community-server-5.7.17-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
> 错误：依赖检测失败：
> net-tools 被 mysql-community-server-5.7.17-1.el7.x86_64 需要
> 解决办法：

> yum install net-tools



3）缺少numactl

> rpm -ivh mysql-community-server-5.7.17-1.el7.x86_64.rpm 

报错：warning: mysql-community-server-5.7.9-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
        libnuma.so.1()(64bit) is needed by mysql-community-server-5.7.9-1.el6.x86_64
        libnuma.so.1(libnuma_1.1)(64bit) is needed by mysql-community-server-5.7.9-1.el6.x86_64
        libnuma.so.1(libnuma_1.2)(64bit) is needed by mysql-community-server-5.7.9-1.el6.x86_64

# 解决办法：

> yum  install numactl

4.初始化数据库

[root@demo mysql_package]# mysqld --initialize

# 初始化之后会在/var/log/mysqld.log 生成随机密码
[root@demo mysql_package]# cat /var/log/mysqld.log 
2021-04-09T09:03:17.978601Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-04-09T09:03:18.091933Z 0 [Warning] InnoDB: New log files created, LSN=45790
2021-04-09T09:03:18.112196Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-04-09T09:03:18.166873Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 6cf9451e-9912-11eb-9de7-000c29314ed4.
2021-04-09T09:03:18.167740Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-04-09T09:03:18.346865Z 0 [Warning] CA certificate ca.pem is self signed.
2021-04-09T09:03:18.560889Z 1 [Note] A temporary password is generated for root@localhost: QEs44hX64j;L

5.修改数据库目录的所属用户及所属组

[root@demo lib]# chown mysql:mysql -R /var/lib/mysql
[root@demo lib]# ll
total 8
drwxr-xr-x. 2 root    root      55 Apr  9 16:27 alternatives
drwx------. 3 root    root      18 Apr  9 16:29 authconfig
drwxr-xr-x. 2 root    root       6 Nov  7  2016 dbus
drwxr-xr-x. 2 root    root       6 Apr  9 16:29 dhclient
drwxr-xr-x. 2 root    root       6 Nov 12  2016 dnsmasq
drwxr-xr-x. 2 root    root       6 Nov  5  2016 games
drwxr-xr-x. 2 root    root       6 Nov 12  2016 initramfs
drwxr-xr-x. 2 root    root      30 Apr  9 16:27 logrotate
drwx------. 2 root    root       6 Apr  9 16:27 machines
drwxr-xr-x. 2 root    root      37 Apr  9 16:30 misc
drwxr-x--x. 5 mysql   mysql   4096 Apr  9 17:03 mysql
drwxr-x---. 2 mysql   mysql      6 Sep 27  2019 mysql-files
drwxr-x---. 2 mysql   mysql      6 Sep 27  2019 mysql-keyring
drwx------. 2 root    root     262 Apr  9 16:30 NetworkManager
drwxr-xr-x. 2 root    root       6 Nov  6  2016 os-prober
drwxr-xr-x. 2 root    root      27 Apr  9 16:27 plymouth
drwxr-x---. 3 root    polkitd   28 Apr  9 16:27 polkit-1
drwx------. 2 postfix root      25 Apr  9 16:30 postfix
drwxr-xr-x. 2 root    root    4096 Apr  9 16:46 rpm
drwxr-xr-x. 2 root    root       6 Nov  5  2016 rpm-state
drwx------. 2 root    root      29 Apr  9 17:01 rsyslog
drwxr-xr-x. 4 root    root      35 Apr  9 16:27 stateless
drwxr-xr-x. 4 root    root      56 Apr  9 16:27 systemd
drwx------. 2 tss     tss        6 Nov 21  2015 tpm
drwxr-xr-x. 6 root    root      80 Apr  9 16:46 yum

6.启动mysql服务

[root@demo lib]# systemctl start mysqld.service
[root@demo lib]# systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Fri 2021-04-09 17:06:59 CST; 5s ago
  Docs: man:mysqld(8)
        http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 11518 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
  Process: 11500 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 11521 (mysqld)
CGroup: /system.slice/mysqld.service
        └─11521 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid...

Apr 09 17:06:59 demo systemd[1]: Starting MySQL Server...
Apr 09 17:06:59 demo systemd[1]: Started MySQL Server.

7.在/var/log/mysqld.log 找到生成的随机密码，登录mysql，修改密码

[root@demo lib]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.28

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

mysql> set password=password('123456');
Query OK, 0 rows affected, 1 warning (0.00 sec)

8.访问权限，允许远程登陆

mysql> select user,host,authentication_string  from user;
+---------------+-----------+-------------------------------------------+
| user          | host      | authentication_string                     |
+---------------+-----------+-------------------------------------------+
| root          | localhost | *667F407DE7C6AD07358FA38DAED7828A72014B4E |
| mysql.session | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.sys     | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
+---------------+-----------+-------------------------------------------+
3 rows in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> select user,host,authentication_string  from user;
+---------------+-----------+-------------------------------------------+
| user          | host      | authentication_string                     |
+---------------+-----------+-------------------------------------------+
| root          | localhost | *667F407DE7C6AD07358FA38DAED7828A72014B4E |
| mysql.session | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.sys     | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| root          | %         | *667F407DE7C6AD07358FA38DAED7828A72014B4E |
+---------------+-----------+-------------------------------------------+
4 rows in set (0.00 sec)

mysql>

取消无密码登录模式【注意：忘记密码情况下，采取以下操作修改密码】

#（1）注释或者删除/etc/my.cnf文件中的skip-grant-tables配置

#（2）重启mysql服务（systemctl restart mysqld.service）

#（3）重新修改root密码
	mysql> update user set host='%',authentication_string=password('123456') where user='root';
	Query OK, 0 rows affected, 1 warning (0.02 sec)
	Rows matched: 1  Changed: 0  Warnings: 1
	
	mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

#（4）重启mysql服务（systemctl restart mysqld.service）

​

JasonZ_1
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
Centos 7安装MySQL 5.7
05-24
本文将详细介绍 Centos 7 安装 MySQL 5.7 的步骤，包括下载并添加存储库、安装 MySQL 5.7 包、启动 MySQL Server、开机启动 MySQL Server、查看 MySQL Server 运行状况、获取 MySQL Server 的初始密码、提高 MySQL ...
【mysq】远程访问权限（允许远程连接）
sayyy的专栏
07-10 768
前言 mysql 5.6 centos 7.0 默认情况下，mysql帐号不允许从远程登陆，只能在localhost登录。 在开发环境中，允许任意ip可以连接数据库。生成环境中，应使用白名单方式，指定允许的ip。 登陆mysql数据库 mysql -u root -p 查看user表 mysql> use mysql; Database changed mys...
Mysql 5.7 (Windows) root开启远程连接
itas109的专栏
12-13 8740
Mysql 5.7在windows上安装完毕之后，默认只能在本地使用，那么如何远程使用mysql进行连接呢？本文将介绍远程连接的详细步骤
Mysql5.7for window 修改系统密码+允许远程访问
liu_yulong的专栏
10-11 332
1.关闭mysql net stop mysql 2.在my.ini中mysqld下添加 skip-grant-tables 完整的my.ini [client] # 设置mysql客户端默认字符集 default-character-set=utf8 [mysqld] #设置3306端口 port = 3306 # 设置mysql的安装目录 这块换成自己解压的路径 basedir=D:\\App\\mysql-5.7.28-winx64 #datadir=D:\\App\\mysql-5.
错误：依赖检测失败：mysql-community-common(x86-64) = 5.7.28-1.el7 被 mysql-community-server-5.7.28-1.el7.x86_
weixin_47340211的博客
04-21 838
然后再 sudo rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm。hive安装过程中安装mysql时候，会出现依赖问题。如果报错如标题所示，只需要升级一下。
在CentOS中安装MySQL报错： Failing package is: mysql-community-common-5.7.42-1.el7.x86_64 GPG Keys are conf
best_dayc_cm的博客
05-22 1828
执行数据库安装命令yum -y install mysql-community-server 时，未安装成功。
Centos7安装MySQL5.7
最新发布
04-15
在本教程中，我们将深入探讨如何在CentOS 7操作系统上安装MySQL 5.7，这是一个保姆级别的指南，旨在确保每个步骤都清晰易懂。MySQL是世界上最流行的开源关系型数据库管理系统，而CentOS 7是一个稳定的Linux发行版，...
Centos7安装mysql5.7yum list installed - grep mysql
01-27
在CentOS7上安装MySQL 5.7是一个常见的任务，特别是在搭建服务器环境时。本文将详细解释如何通过YUM在CentOS7上安装MySQL 5.7.11，并涵盖安装过程中的关键步骤。 首先，我们需要确保系统中没有预装的MySQL。运行`...
CentOS7安装mysql5.7解压缩版简明教程
01-10
本文实例讲述了CentOS7安装mysql5.7解压缩版的方法。分享给大家供大家参考，具体如下： 1.下载安装包 http://dev.mysql.com/downloads/mysql/#downloads 推荐下载通用安装方法的TAR包 2.检查库文件是否存在，如有...
Centos7安装Mysql5.7安装包
05-24
本文将详细介绍如何在CentOS 7上安装MySQL 5.7的安装包，包括必要的准备工作、安装步骤以及注意事项。 **一、安装前准备** 1. **更新系统**: 在安装任何新软件之前，首先要确保系统是最新的，可以通过`sudo yum ...
在centOS 7安装mysql 5.7的详细教程
01-21
参考官方文档：...比如在centOS 7安装mysql 5.7 [mysql57-community] name=MySQL 5.7 Community Server baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/ enabled=1 gpgcheck=0
Centos7安装mysql5.7.doc
08-31
在本文中，我们将详细探讨如何在CentOS 7操作系统上安装MySQL 5.7数据库管理系统。MySQL是一个流行的开源关系型数据库管理系统（RDBMS），在Linux系统中广泛使用。以下是安装MySQL 5.7的步骤： 1. **准备工作**： ...
centOS7安装mysql5.7手册v3.docx
08-18
在Linux（CentOS7）环境下安装和配置MySQL5.7.26是一个系统性的过程，以下是一步步的详细步骤： 1. **卸载系统自带的MariaDB**：首先，检查系统中是否已安装了MariaDB，使用`rpm -qa | grep mariadb`命令。如果存在...
centos7二进制安装MySQL5.7.docx
03-06
CentOS 7上二进制安装MySQL 5.7的过程涉及多个步骤，这些步骤确保了数据库服务能够正确、稳定地运行。以下是对整个过程的详细解释： 1. **安装依赖包**： 在安装MySQL之前，需要确保系统中有必要的依赖库。在...
安装mysql数据库及问题解决方法
couyifu7209的博客
03-27 172
1、mysql官网下载安装包，官网地址：www.mysql.com [root@seiang software]# ll total 580020 -rw-r--r--. 1...
Centos7 安装 MySQL5.7 步骤
热门推荐
巧克力配酸奶的博客
02-25 1万+
本文记录了两种方式来安装mysql一、使用yum源方式安装二、使用本地tar文件方式安装。
Linux MySQL下载&安装
hello world
12-04 5909
Linux Centos 7系统安装MySQL
Mysql_5.7下载及安装（CentOS7）
阿轩的博客
06-27 1110
Mysql_5.7安装
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值