Author: KennethCheng

MySQL创建数据库、用户创建、授权

创建数据库 以nextcloud_db为例 CREATE DATABASE nextcloud_db; 新建用户 create user 'nextcloud'@'192.168.50.133' identified by 'password';

KennethCheng KennethCheng Published on 2021-06-11

MySQL备份脚本

docker MySQL #!/bin/sh DB_USER="user" DB_PASS="password" DB_NAME=(databases1 databases2 databases3) # Others vars BCK_DIR="备份路径" DATE=`date +%F` # TOD

KennethCheng KennethCheng Published on 2021-06-11

Proxmom VE硬件直通

内核开启IOMMU支持 编辑grub vi /etc/default/grub 将GRUB_CMDLINE_LINUX_DEFAULT="quiet" 改为GRUB_CMDLINE_LINUX_DEFAULT="quiet intel_iommu=on video=efifb:off" 保存后执行

KennethCheng KennethCheng Published on 2020-06-11

Proxmom VE全盘映射

查看硬盘ID ls -l /dev/disk/by-id/ 设置虚拟机硬盘 qm set 108 --sata1 /dev/disk/by-id/ata-WDC_WD40EZRZ-XXXXXXX_WD-XXXXXXXXXXXX qm set 108 --sata2 /dev/disk/by-id/

KennethCheng KennethCheng Published on 2020-06-11

CentOS7上离线安装SQL Server

先下载安装包 点击下载安装包 安装包目录下运行此命令进行安装 yum install mssql-server-15.0.4023.6-2.x86_64.rpm 修改默认数据和日志目录位置 mkdir /data/mssqlserver/data -p chown mssql /data/mssq

KennethCheng KennethCheng Published on 2020-03-25

Linux修改ip

修改配置文件 vi /etc/sysconfig/network-scripts/ifcfg-eth0 配置示例 auto eth0 #静态设置ip iface eth0 inet static #设置ip地址 address 192.168.8.56 #设置子网掩码 netmask 255.

KennethCheng KennethCheng Published on 2020-02-11

Linux解压

tar命令 # 压缩文件 file1 和目录 dir2 到 test.tar.gz tar -zcvf test.tar.gz file1 dir2 # 解压 test.tar.gz(将 c 换成 x 即可) tar -zxvf test.tar.gz # 列出压缩文件的内容 tar -ztvf t

KennethCheng KennethCheng Published on 2020-02-11

Centos部署frp

下载frp 下载链接 做成服务 vi /lib/systemd/system/frpc.service 配置内容

KennethCheng KennethCheng Published on 2019-05-11

Centos换yum源

yum报错 Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile Could not retrieve mirrorlist http://mirrorlist.centos.org/?release=7&a

KennethCheng KennethCheng Published on 2019-02-11

激活Windows

kms激活命令 slmgr -ipk M7XTQ-FN8P6-TTKYV-9D4CC-J462D slmgr -skms kennethcheng.cc:16888 slmgr -ato slmgr -dlv 查看剩余时间 slmgr.vbs -xpr Windows Server 2016 和

KennethCheng KennethCheng Published on 2018-09-11
Previous Next