CentOS 7 日常操作

[huianlei]

CentOS7 yum 安装 MySQL

导读

本文介绍的yum 安装方法为通用安装方法

MySQL yum 源

访问 https://dev.mysql.com/downloads/repo/yum/ 找到对应操作系统的yum 源安装文件

复制到当前最新地址为 https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

安装yum repo

sudo yum install -y https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

列出仓库可用的mysql安装文件

sudo yum repolist all | grep mysql

默认启用的仓库当前为8.0，不是我想要的版本，需要启用想要的版本，禁用当前版本

sudo yum-config-manager --enable mysql56-community
sudo yum-config-manager --disable mysql80-community

安装

sudo yum install mysql-community-server

[huianlei]

启动 MySQL

# CentOS7 把 CentOS6 的 System V init 换成 Systemd 了
# 不建议使用 sudo service mysql start 命令，
# Redirecting to /bin/systemctl start  mysql.service

sudo systemctl start mysql.service

由于MySQL 5.6版本没有对root账号做严格的权限管理，直接使用如下命令本机登录root账号

mysql -uroot

[huianlei]

Yum 安装 Redis

查看已安装redis

sudo yum list installed | grep redis

如已安装,确认是否是自己需要的版本，如不是先卸载再安装指定版本

sudo yum remove redis

查看现有仓库可以提供哪些redis下载

sudo yum search redis

上图中发现有三个redis版本,笔者希望安装redis4.0版本

sudo yum install redis40u

• 默认启动redis

  sudo systemctl start redis.service

• 开启启动

  sudo systemctl enable redis.service
  # 禁用
  sudo systemctl disable redis.service

  

[huianlei]

yum 安装MySQL diff

• 尝试yum search mysqlutilities/mysqldiff 没有匹配到安装包
• Google mysqldif 获得官方下载地址 https://downloads.mysql.com/archives/utilities/ 选择合适的版本复制链接地址
• 使用yum安装，可以自行下载依赖

  sudo yum install https://downloads.mysql.com/archives/get/file/mysql-utilities-1.6.5-1.el7.noarch.rpm

  

如需yum 安装其他软件，思路方法类似，不再单独说明

[huianlei]

MySQL diff 报错

缺少python module 请到以下地址下载安装 mysql-connector-python https://dev.mysql.com/downloads/connector/python/

MySQL diff Unread result found

AnleideMacBook-Pro:antia-server anlei$ mysqldiff --server1=root:123147@localhost --server2=root:123147@localhost --changes-for=server1 --difftype=sql --force --skip-table-options antia_server:antia_test > diff.sql
Traceback (most recent call last):
  File "/usr/local/bin/mysqldiff", line 268, in <module>
    servers = connect_servers(server1_values, server2_values, conn_opts)
  File "/Library/Python/2.7/site-packages/mysql/utilities/common/server.py", line 489, in connect_servers
    source = get_server(src_name, src_dict, quiet, verbose=verbose)
  File "/Library/Python/2.7/site-packages/mysql/utilities/common/server.py", line 336, in get_server
    server_conn.connect()
  File "/Library/Python/2.7/site-packages/mysql/utilities/common/server.py", line 1104, in connect
    res = self.show_server_variable('character_set_client')
  File "/Library/Python/2.7/site-packages/mysql/utilities/common/server.py", line 1391, in show_server_variable
    return self.exec_query("SHOW VARIABLES LIKE '%s'" % variable)
  File "/Library/Python/2.7/site-packages/mysql/utilities/common/server.py", line 1327, in exec_query
    cur.close()
  File "/Library/Python/2.7/site-packages/mysql/connector/cursor.py", line 395, in close
    self._connection.handle_unread_result()
  File "/Library/Python/2.7/site-packages/mysql/connector/connection_cext.py", line 695, in handle_unread_result
    raise errors.InternalError("Unread result found")
mysql.connector.errors.InternalError: Unread result found

[huianlei]

docker CentOS7 容器中安装运行mysql

使用systemctl start mysql.service 无法启动，

• 手动启动

  mysqld --defaults-file=/etc/my.cnf  --user=mysql

• 查找默认密码

  grep 'temporary password' /var/log/mysqld.log

• 修改默认密码

  # 先登录mysql 设置安全参数
  set global validate_password_policy=0;
  set global validate_password_length=6;
  # 退出修改密码
  mysqladmin password -p

[huianlei]

容器中运行CentOS 7 作为虚拟机

• 按章sshd 服务

  yum install openssh-server -y
  # 启用服务
  systemctl enable sshd.service
  # 查看sshd.server unit 配置
  systemctl cat sshd.service
  # 启动服务，默认监听22端口
  systemctl start sshd.service

[huianlei]

https://blog.csdn.net/sl1992/article/details/106017157