解决MacOS中Terminal第一次打开卡顿几秒的BUG

$ sudo xcode-select -p

$ sudo xcode-select -switch /Library/Developer/CommandLineTools

$ sudo xcode-select -p

解决BigSur Arduino ESP8266编译错误

vi ~/Library/Arduino15/packages/esp8266/hardware/esp8266/2.7.4/tools/pyserial/serial/tools/list_ports_osx.py

#iokit = ctypes.cdll.LoadLibrary(ctypes.util.find_library('IOKit'))
#cf = ctypes.cdll.LoadLibrary(ctypes.util.find_library('CoreFoundation'))
iokit = ctypes.cdll.LoadLibrary('/System/Library/Frameworks/IOKit.framework/IOKit')
cf = ctypes.cdll.LoadLibrary('/System/Library/Frameworks/CoreFoundation.framework/CoreFoundation')

解决BigSur Arduino esp32 编译错误

cp ~/Library/Arduino15/packages/esp32/hardware/esp32/1.0.4/tools/esptool.py ~/Library/Arduino15/packages/esp32/tools/esptool_py/2.6.1/esptool.py

chmod 755 ~/Library/Arduino15/packages/esp32/tools/esptool_py/2.6.1/esptool.py

vi  /Library/Arduino15/packages/esp32/hardware/esp32/1.0.4/platform.txt

#tools.esptool_py.cmd=esptool
tools.esptool_py.cmd=esptool.py

sudo pip3 install pyserial

MacOs下git,maven,port,terminal使用代理

1 git

//全局配置
git config --global http.proxy socks5://127.0.0.1:1087
//编辑全局配置文件
git config --global -e
//取消全局配置
git config --global --unset http.proxy

2 maven

~/.m2/setting.xml

 <proxies>
     <proxy>
      <id>optional</id>
      <active>true</active>
      <protocol>http</protocol>
      <host>127.0.0。1</host>
      <port>1087</port>
      <nonProxyHosts>repo.njava.com</nonProxyHosts>
    </proxy>
</proxies>

//命令行方式
mvn clean compile -Dhttps.proxyHost=127.0.0.1 -Dhttps.proxyPort=1087

3 mac port

 /opt/local/etc/macports/macports.conf 

proxy_override_env yes 
proxy_http 127.0.0.1:1087

4 terminal

//1 命令行
export http_proxy=http://127.0.0.1:1087
//2 配置文件.bashrc或者.zshrc
export http_proxy="http://127.0.0.1:1087"
export https_proxy="http://127.0.0.1:1087"

2017 china region mysql dump

to ck

2017 china region mysql dump

region
school

mysql5.5远程主从设置

主机：10.0.0.1
从机：10.0.0.2

1 主机设置
1.1 配置文件/etc/mysql/my.cnf

server-id               = 1
log_bin                 = /var/log/mysql/mysql-bin.log
expire_logs_days        = 2
max_binlog_size         = 100M

binlog_ignore_db = mysql
binlog_ignore_db = information_schema
binlog_ignore_db = performance_schema

binlog_do_db = testcase
binlog_do_db = db100
binlog_do_db = db200

1.2 mysql控制台命令启动master模式

     mysql>GRANT replication slave on *.* to 'slave2'@'10.0.0.2' IDENTIFIED BY 'password';
     mysql>SHOW master status;

2 从机设置
2.1 从机配置

server-id               = 2
log_bin                 = /var/log/mysql/mysql-bin.log
expire_logs_days        = 2
max_binlog_size         = 100M

2.2 从机控制台命令

     mysql>slave stop；
     mysql>change master to master_host='10.0.0.1', master_port=3306, master_user='slave2', master_password='password', master_log_file='mysql-bin.000011', master_log_pos=189;
     mysql>slave start；
     mysql>show slave status \G;

3mysql远程账号设置

mysql>grant all privileges on *.* to njava@10.0.0.1 identified by "password" with grant option;