Skip to content

Instantly share code, notes, and snippets.

Avatar
💭
🤣

netnr netnr

💭
🤣
View GitHub Profile
@netnr
netnr / win-install-mysql.md
Created Oct 21, 2020
Windows系统安装 MySQL
View win-install-mysql.md
  • 下载地址:https://dev.mysql.com/downloads/mysql
  • 解压包,放置一个目录下(不含中文或空格的路径)
  • bin 同级目录创建 my.ini 文件和 data 文件夹
  • my.ini 文件内容
[mysqld]
# 设置3306端口
port=3306
# 设置mysql的安装目录
basedir=E:\\mysql-8.0.22-winx64
@netnr
netnr / oracle_expdp_impdp.sh
Created Oct 14, 2020
Oracle数据库导入导出
View oracle_expdp_impdp.sh
# 按用户导出
EXPDP USER/PWD@ORCL SCHEMAS=USERR DUMPFILE=DBNAME.dmp LOGFILE=DBNAME.log DIRECTORY=DATA_PUMP_DIR
# 按表名导出
EXPDP USER/PWD@ORCL TABLES=(TABLE1,TABLE2) DUMPFILE=DBNAME.dmp LOGFILE=DBNAME.log DIRECTORY=DATA_PUMP_DIR
# 按用户导入(表覆盖)
IMPDP USER/PWD@ORCL SCHEMAS=USERR DUMPFILE=DBNAME.dmp LOGFILE=DBNAME.log DIRECTORY=DATA_PUMP_DIR TABLE_EXISTS_ACTION=REPLACE
# DIRECTORY 参数说明
select * from dba_directories; -- 查看管理员目录
@netnr
netnr / netsh-http.bat
Created Sep 18, 2020
netsh命令监听IP(可实现IIS、nginx共用80端口)
View netsh-http.bat
:: 显示监听的IP列表
netsh http show iplisten
:: 添加监听IP
netsh http add iplisten ipaddress=127.0.0.1
:: 删除监听IP
netsh http delete iplisten 127.0.0.1
@netnr
netnr / aspnet_regiis.bat
Created Sep 18, 2020
Framework注册IIS
View aspnet_regiis.bat
@echo off
title .NET Framework Register IIS
color 5f
echo.---------- .NET Framework v2 Register IIS
echo.
%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
%windir%\Microsoft.NET\Framework64\v2.0.50727\aspnet_regiis.exe -i
View install-iis.bat
@echo off
title Install IIS
color 5f
echo.---------- Install IIS about 3-5 Minutes
echo.
dism /Online /Enable-Feature /FeatureName:IIS-ApplicationDevelopment /FeatureName:IIS-ASP /FeatureName:IIS-ASPNET /FeatureName:IIS-BasicAuthentication /FeatureName:IIS-CGI /FeatureName:IIS-ClientCertificateMappingAuthentication /FeatureName:IIS-CommonHttpFeatures /FeatureName:IIS-CustomLogging /FeatureName:IIS-DefaultDocument /FeatureName:IIS-DigestAuthentication /FeatureName:IIS-DirectoryBrowsing /FeatureName:IIS-FTPExtensibility /FeatureName:IIS-FTPServer /FeatureName:IIS-FTPSvc /FeatureName:IIS-HealthAndDiagnostics /FeatureName:IIS-HostableWebCore /FeatureName:IIS-HttpCompressionDynamic /FeatureName:IIS-HttpCompressionStatic /FeatureName:IIS-HttpErrors /FeatureName:IIS-HttpLogging /FeatureName:IIS-HttpRedirect /FeatureName:IIS-HttpTracing /FeatureName:IIS-IIS6ManagementCompatibility /FeatureName:IIS-IISCertificateMappingAuthentication /FeatureName:IIS-IPSecurity /F
@netnr
netnr / locale.sh
Created Sep 7, 2020
CentOS 修改语言环境为中文
View locale.sh
locale # 当前语言包
locale -a # 系统拥有语言包(zh_CN.UTF-8是简体中文,如果没有zh_CN.UTF-8,就安装语言包,如果存在可以直接设置)
# CentOS 7
yum install kde-l10n-Chinese # 安装简体中文语言包
# CentOS 8
dnf search langpacks # 搜索语言包
dnf install langpacks-zh_CN.noarch # 安装中文语言
@netnr
netnr / fdisk-lsblk.sh
Created Sep 4, 2020
Linux 挂载磁盘、分区
View fdisk-lsblk.sh
lsblk # 检查磁盘
fdisk -l # 查看所有磁盘信息(含未加载磁盘)
fdisk /dev/sdb # 对磁盘分区,大于2T时,用parted
# 输入 m 显示菜单,选择 n 创建分区,再选择 p(主分区)或 e(扩展分区),再确认 2048 ,再确认(默认整个磁盘)或自定义 +100G,再输入 w
partprobe /dev/sdb # 内核重新读取分区表
mkfs.ext4 /dev/sdb1 # 格式化分区(磁盘分区,非整个磁盘)
mkdir /mnt/package1 # 创建挂载目录
mount /dev/sdb1 /mnt/package1 # 临时挂载目录
vi /etc/fstab # 编辑 永久挂载,追加如下内容:
@netnr
netnr / mysql-datadir.sh
Last active Sep 21, 2020
CentOS 更改 MySQL 数据存储路径(datadir)
View mysql-datadir.sh
# 登录mysql,查看默认存储路径,一般在 /var/lib/mysql
show global variables like '%datadir%';
mkdir -p /package/mysqldata # 新建目录
cp -a -R /var/lib/mysql/* /package/mysqldata/ # 拷贝
chown mysql:mysql /package/mysqldata # 将目录授权给mysql用户组
chmod 750 /package/mysqldata # 更改目录权限
systemctl stop mysqld # 停止mysql服务
vi /etc/my.cnf # 修改datadir socket 为如下:
@netnr
netnr / install-mysql8.md
Last active Sep 21, 2020
CentOS7 安装 MySQL8
View install-mysql8.md

清理

# 查找并删除mysql(原本的残留)
rpm -qa | grep mysql # 查找
yum remove 软件包名 # 删除

# 查找并删除mariaDB
rpm -qa | grep mariadb # 查找
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64 # 删除
@netnr
netnr / update-git.sh
Created Sep 1, 2020
CentOS 升级 git
View update-git.sh
git --version # 当前版本
vi /etc/yum.repos.d/wandisco-git.repo # 启用Wandisco GIT存储库,在此之前我们先写入新yum存储库配置文件,输入以下内容:
[wandisco-git]
name=Wandisco GIT Repository
baseurl=http://opensource.wandisco.com/centos/7/git/$basearch/
enabled=1
gpgcheck=1
gpgkey=http://opensource.wandisco.com/RPM-GPG-KEY-WANdisco
You can’t perform that action at this time.