xx's blog

mysql5.7.x编码设置为utf8mb4

1. 临时设置编码(重新进入mysql shell后失效)mysql> show variables like '%char%'; +--------------------------+-----------------------------------------------------------+ | Variable_name | Value | +--------------------------+-------------------------------------------
2020-02-12

mac os x从源码编译安装python3.8

1. 下载并解压python3.8源码包https://www.python.org/https://www.python.org/downloads/ 选择XZ compressed source tarball, 拷贝文件绝对路径链接, 用wget命令下载 wget -c https://www.python.org/ftp/python/3.8.0/Python-3.8.0.tar.xz xz -d Python-3.8.0.tar.xz tar -xvf Python-3.8.0.tar 2. 安
2019-10-15

postgresql命令

1. postgresql常用命令进入数据库postgres: $ psql postgres psql (11.2) Type "help" for help. postgres=# 退出postgresql shell: postgres=# exit 创建用户olddriver: postgres=# create user olddriver with password '123456'; CREATE ROLE 删除用户oldriver, 并创建用户olddriver, 将数据库的拥有
2019-08-26

mac os x sublime text 3安装ctags插件实现代码跳转

ctags是一款实现代码跳转的插件,可以提高查看代码的效率. 1. st3安装ctags插件快捷键commands + shift + p 打开 Package Control: Instance Package, 搜索 ctags进行安装ctags插件 2. 安装ctags打开ctags网址下载ctags源码包: http://ctags.sourceforge.net/ 或wget命令下载: wget -c https://jaist.dl.sourceforge.net/project/ctags/c
2019-05-21

linux下安装postgresql

postgresql官方下载: https://www.postgresql.org/download/ 1. for ubuntuhttps://www.postgresql.org/download/linux/ubuntu/ 创建postgresql仓库文件/etc/apt/sources.list.d/pgdg.list, 以添加以下内容: for 18.04: deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main for 16
2019-02-26

linux下安装elasticsearch

1. 安装JDKjdk8下载地址: http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html 安装依赖工具: for ubuntu: sudo apt-get install vim wget lsof curl git for centos: sudo yum install vim wget lsof curl git wget命令下载: wget -c --no-check-certifi
2018-12-24

如何在github提交PR(Pull Request)

拿本人在github上开源的cookiecutter-django为例。 1. fork repositoryFork 开源项目, 单击cookiecutter-django页面顶部附近的Fork按钮, 这将在GitHub服务器上创建您帐户下的代码副本。 2. 克隆代码副本到本地磁盘$ git clone git@github.com:xiongxianzhu/cookiecutter-django.git $ cd cookiecutter-django 3. 创建新分支创建一个新分支来保存您的更改并开
2018-12-13

ubuntu16.04安装mysql5.7.24

参考本人CSDN博客上写的文章: 64位centos6.7安装mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz 1. 下载安装包及安装相关依赖官网: http://dev.mysql.com/downloads/mysql/ mysql搜狐镜像站:http://mirrors.sohu.com/mysql/ mkdir ~/soft/ cd ~/soft/ wget -c http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.24
2018-12-11

linux安装nodejs,npm,cnpm,bower,hexo

nodejs长期LTS稳定版: https://nodejs.org/en/download/ nodejs最新版: https://nodejs.org/en/download/current/ linux选择: Linux Binaries (x64) $ wget -c https://nodejs.org/dist/v10.14.1/node-v10.14.1-linux-x64.tar.xz $ xz -d node-v10.14.1-linux-x64.tar.xz $ tar -xvf nod
2018-12-05

linux源码编译安装nginx1.15.7

1. 源码包准备安装nginx所需工具源码包下载地址: nginx: https://nginx.org/download/pcre: http://www.pcre.org/zlib: https://www.zlib.net/openssl: https://www.openssl.org/ 安装nginx所需源码包: nginx-1.15.7.tar.gz pcre-8.42.tar.gz zlib-1.2.11.tar.gz openssl-1.1.1a.tar.gz 通过wget命令下载:
2018-12-05
123456