Mysql - 随笔分类(第6页) - jinzhenshui

Mysql：来源于Mariadb的【审计】插件：server_audit

摘要：一：直接从mariadb的GA版本中提取server_audit{.so|.dll}，根据测试，不支持 Mysql 8+ 主要的、最近的版本都已经是 1.4.4+：完整的功能了。 CONNECT, QUERY, TABLE, QUERY_DDL, QUERY_DML, QUERY_DCL, QU 阅读全文

posted @ 2020-03-14 18:51 jinzhenshui 阅读(1210) 评论(0) 推荐(0)

Mysql：--init-file && --init-connect

摘要：init_file PropertyValue Command-Line Format --init-file=file_name System Variable init_file Scope Global Dynamic No SET_VAR Hint Applies No Type File 阅读全文

posted @ 2020-03-13 21:33 jinzhenshui 阅读(362) 评论(0) 推荐(0)

Mysql：8.0.19：Upgrading Mysql：升级

摘要：2.11 Upgrading MySQL 2.11.1 Before You Begin 2.11.2 Upgrade Paths 2.11.3 What the MySQL Upgrade Process Upgrades 2.11.4 Changes in MySQL 8.0 2.11.5 Pr 阅读全文

posted @ 2020-03-13 20:26 jinzhenshui 阅读(1613) 评论(0) 推荐(0)

Mysql：8.0.19：新特性、过期、已经删除的

摘要：1.4 What Is New in MySQL 8.0 1.5 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0 1.4 What Is New in MySQL 8.0 This 阅读全文

posted @ 2020-03-13 20:18 jinzhenshui 阅读(1148) 评论(0) 推荐(0)

Mysql：5.5-5.6：Components & Plugins

摘要：5.5 MySQL Server Components 5.5.1 Installing and Uninstalling Components 5.5.2 Obtaining Server Component Information 5.5.3 Error Log Components MySQL 阅读全文

posted @ 2020-03-13 19:51 jinzhenshui 阅读(417) 评论(0) 推荐(0)

Mysql：As of 8.0.16：--validate-config：新增的服务器配置验证特效：good！

摘要：5.1.3 Server Configuration Validation As of MySQL 8.0.16, MySQL Server supports a --validate-config option that enables the startup configuration to b 阅读全文

posted @ 2020-03-13 19:24 jinzhenshui 阅读(415) 评论(0) 推荐(0)

Mysql：FIPS：Federal Information Processing Standards 140-2：世上有不透风的墙么？！

摘要：6.5 FIPS Support MySQL supports FIPS mode, if compiled using OpenSSL 1.0.2, and an OpenSSL library and FIPS Object Module are available at runtime. FI 阅读全文

posted @ 2020-03-13 19:16 jinzhenshui 阅读(237) 评论(0) 推荐(0)

Mysql：6.4.2-6.4.8：Security Plugins & Component & Enterprise-Extend

摘要：6.4.2 The Connection-Control Plugins 6.4.3 The Password Validation Component 6.4.4 The MySQL Keyring 6.4.5 MySQL Enterprise Audit 6.4.6 The Audit Mess 阅读全文

posted @ 2020-03-13 19:06 jinzhenshui 阅读(2478) 评论(0) 推荐(0)

Mysql：Using Encrypted Connection：SSL、TLS、SSH：通讯安全

摘要：6.3 Using Encrypted Connections 6.3.1 Configuring MySQL to Use Encrypted Connections 6.3.2 Encrypted Connection TLS Protocols and Ciphers 6.3.3 Creati 阅读全文

posted @ 2020-03-13 18:31 jinzhenshui 阅读(798) 评论(0) 推荐(0)

Mysql：Authentication Plugins：插件式（权限）认证

摘要：6.4 Security Components and Plugins 6.4.1 Authentication Plugins 6.4.2 The Connection-Control Plugins 6.4.3 The Password Validation Component 6.4.4 Th 阅读全文

posted @ 2020-03-13 18:18 jinzhenshui 阅读(2808) 评论(0) 推荐(0)

Mysql：通过SSH隧道方式实现安全通讯

摘要：6.3.4 Connecting to MySQL Remotely from Windows with SSH This section describes how to get an encrypted connection to a remote MySQL server with SSH. 阅读全文

posted @ 2020-03-13 13:36 jinzhenshui 阅读(399) 评论(0) 推荐(0)

Mysql：Chapter 6 Security（直接复制的）

摘要：Chapter 6 Security Table of Contents 6.1 General Security Issues 6.1.1 Security Guidelines 6.1.2 Keeping Passwords Secure 6.1.3 Making MySQL Secure Ag 阅读全文

posted @ 2020-03-13 13:31 jinzhenshui 阅读(457) 评论(0) 推荐(0)

Mysql：logging 安全问题：server & client

摘要：6.1.2.3 Passwords and Logging Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. If such statements 阅读全文

posted @ 2020-03-13 13:13 jinzhenshui 阅读(354) 评论(0) 推荐(0)

Mysql：set password

摘要：13.7.1.10 SET PASSWORD Statement SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN CURRENT PASSWORD] auth_option: { = 'auth_ 阅读全文

posted @ 2020-03-13 11:57 jinzhenshui 阅读(594) 评论(0) 推荐(0)

Mysql： DNS Lookup Optimization and the Host Cache：skip-host-cache\skip-name-resolve

摘要：8.12.4.2 DNS Lookup Optimization and the Host Cache The MySQL server maintains a host cache in memory that contains information about clients: IP addr 阅读全文

posted @ 2020-03-13 11:09 jinzhenshui 阅读(528) 评论(0) 推荐(0)

Mysql：skip-name-reslove

摘要：skip_name_resolve PropertyValue Command-Line Format --skip-name-resolve[={OFF|ON}] System Variable skip_name_resolve Scope Global Dynamic No SET_VAR H 阅读全文

posted @ 2020-03-13 10:55 jinzhenshui 阅读(345) 评论(0) 推荐(0)

Mysql 8.0.19：skip-grant-table：新变化：坑

摘要：--skip-grant-tables PropertyValue Command-Line Format --skip-grant-tables[={OFF|ON}] Type Boolean Default Value OFF This option affects the server sta 阅读全文

posted @ 2020-03-13 10:37 jinzhenshui 阅读(1152) 评论(0) 推荐(0)

Mysql：就地升级：mysql_upgrade

摘要：重点来了：完整的物理备份。参数配置 [mysqld] # 最基本的配置了 basedir=D:/mysql-5.7.29-winx64 datadir=D:/mysql-5.7.29-winx64/data # 临时升级检测用 innodb-buffer-pool-size=2G #可选，默认很阅读全文

posted @ 2020-03-12 12:46 jinzhenshui 阅读(3800) 评论(0) 推荐(0)

偶记：mysql5.7的官方doc也有错误啊：写的是vc runtime 2010，但实际上必须是 vc runtime 2013。坑

摘要：如题阅读全文

posted @ 2018-09-17 13:46 jinzhenshui 阅读(388) 评论(0) 推荐(0)

mysqlpump：更加合理的mysql数据库逻辑备份工具

posted @ 2018-09-11 10:38 jinzhenshui 阅读(341) 评论(0) 推荐(0)

随笔分类 - Mysql