CREATE DATABASE IF NOT EXISTS dbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;grant all on dbname.* to 'yachen'@'%' identified by 'pwd'; grant all on dbname.* to &...
CREATE DATABASE IF NOT EXISTS dbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;grant all on dbname.* to 'yachen'@'%' identified by 'pwd'; grant all on dbname.* to &...
版本号Debian 9的MariaDB 10.1。进入/etc/mysql一番研究可以发现mysql-server端的配置都在/etc/mysql/mariadb.conf.d/50-server.conf里，其中有这么一行# Instead of skip-networking the default is now to listen only on # localhost which i...
之前写了个用php_ftp的脚本用于每天备份网站根目录:https://memo.xuchen.wang/archives/13.html。一直以来觉得ftp实在是太蠢了，实在受不了了，加上我现在存放备份的vps换到了一个没独立ip的nat服务器(gullo2刀的，极力推荐)，把之前的脚本拖出来改了改换成了ssh和scp，破费。<?php date_default_timezo...
以512m为例cd /var/ dd if=/dev/zero of=swapfile bs=1024 count=524288 chmod 600 swapfile /sbin/mkswap swapfile /sbin/swapon swapfile查看现有swap:/sbin/swapon -s记得将swap文件信息加入/etc/fstabecho "/var/swapfil...
今天发现一个软件Dependency Walker在Windows下可以以树状形式理清exe和dll等二进制文件的链接库依赖关系，详见官网。http://www.dependencywalker.com/