學術及資源的交流園地 ^_^

Re-initialize MySQL

 

前言

MySQL8.0 新增 data dictionary的概念, 初始化時默認"lower-case-table-names=0"

如果要更改, 必須 Re-initialize MySQL

更改它會令 Service 不應 start

log

... Different lower_case_table_names settings for server ('1') and data dictionary ('0').
... Data Dictionary initialization failed.
... Aborting

 

CLI - fcgi

 

 

SMTP

 

 

mod_remoteip

最後更新: 2022-09-28

介紹

 

Client -> Proxy(nginx, cloudflare ...) -> Apache

功能

Replaces the original client IP address for the connection

with the useragent IP address list presented by a proxies via the request headers.

Enable this behavior from intermediate hosts (proxies, etc)

與其他 module 的互動

IP address is then used for the

  • mod_authz_host "Require ip" feature,
  • reported by mod_status
  • recorded by mod_log_config %a
    %h     <-- Proxy 的 IP
    %a     <-- Proxy 提供的 RemoteIPHeader 的 IP 值, 如果沒有就相當於 %h

 

RSS feed