摘要:create user xiaoming identified by 123; password xiaoming; drop user xiaoming; grant connect to xiaoming [with admin option]; conn xiaoming/123 grant resource to xiaoming;//可以建表了 create table te...
阅读全文
摘要:virtualbox host-only 单网卡上网1.在host主机上共享互联网到virtualbox host-only- network 网卡上(右键共享选 host-only)2.host-only ip 从192.168.137.1改为 192.168.56.1 3.在guest电脑上 r
阅读全文
摘要:conn passw start/@ xx.sql eidt xx.sql 说明:可以替代变量,而该变量在执行时,需要用户输入。select * from emp where job='&job'; select * from v$nls_parameters本地环境变量,设置NLS_LANG =
阅读全文
摘要:cluster 内容改变 就要用inotify 内核通知 1. LB 负载均衡 ,提高并发能力 2. primary standby =>HA 高可用cluster ,heatbeat 提高可用性 appServer1, appServer2,appServer3 health check:健康检查 NFS 资源文件,供app server 共用 aapserver连同一db server或d...
阅读全文
摘要:mariadb master/slave replicationhttps://mariadb.com/kb/en/mariadb/setting-up-replication/master :10.109.68.101[mariadb]log-binserver_id=1log-basename=
阅读全文
摘要:muti host vi phpmyadmin/config.inc.php add i++; $cfg['Servers'][$i]['verbose'] = 'Database Server 2'; $cfg['Servers'][$i]['host'] = '192.168.1.102'; $
阅读全文
摘要:soft: wget https://dl.google.com/linux/direct/google-chrome-stable_current_x86_64.rpm idea plugin: scala https://plugins.jetbrains.com/plugin/?idea&id
阅读全文
摘要:https://docs.docker.com/registry/deploying/ docker run -d -p 5000:5000 --restart=always --name registry \ -v /home/anjun/a/data/docker_registry:/var/l
阅读全文
摘要:/etc/yum.repos.d/wandisco-svn.repo [WandiscoSVN] name=Wandisco SVN Repo baseurl=http://opensource.wandisco.com/centos/$releasever/svn-1.9/RPMS/$basear
阅读全文
摘要:引起nginx 403 forbidden通常是三种情况:一是缺少索引文件,二是权限问题,三是SELinux状态
阅读全文
摘要:systemctl set-default multi-user.target systemctl set-default graphical.target 如何找出配置文件 rpm -qc samba-common samba rpm -e samba == yum remove samba ca
阅读全文
摘要:http{ log_format mydebug '$document_root$fastcgi_script_name > $request'; } server{ access_log /xx mydebug }
阅读全文
摘要:https://github.com/docker/compose/releases https://download.openvz.org/template/precreated/
阅读全文
摘要:sudo docker run --name oraclexe -d -p 49160:22 -p 1521:1521 wnameless/oracle-xe-11g docker https://github.com/GoogleCloudPlatformhttps://dev.aliyun.co
阅读全文
摘要:https://www.virtualbox.org/manual/ch06.html [nat]VBoxManage modifyvm "VM name" --natpf1 "guestssh,tcp,127.0.0.1,2222,,22"VBoxManage modifyvm "VM name"
阅读全文
摘要:wget https://dl.google.com/linux/direct/google-chrome-stable_current_x86_64.rpm yum install ibus ibus-table-wubi* yum install ./google-chrome-stable_c
阅读全文
摘要:sudo apt install language-pack-zh-hant language-pack-zh-hans
阅读全文
摘要:sudo alien --scripts -d sqldeveloper-4.0.0.13.80-1.noarch.rpm sudo dpkg -i xxx.deb mkdir ~/.sqldeveloper /opt/sqldeveloper/sqldeveloper.sh
阅读全文
摘要:yum -y install tftp-serveryum -y install xinetdyum -y install syslinuxcp /usr/share/syslinux/pxelinux.0 /var/lib/tftpboot/mkdir -p /var/pxe/centos7mkd
阅读全文
摘要:man dhcpd.conf # vim /etc/dhcp/dhcpd.conf#不进行DDNS的更新ddns-update-style none;#不允许客户机更新DNS记录ignore client-updates;#与下面的range配合声明可分配IP的范围subnet 192.168.56
阅读全文
摘要:yum install mariadb-server mariadb http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-server-5.7.14-1.el7.x86_64.rpmuse mysql;update user se
阅读全文
摘要:down genymotion-arm-translation https://www.dropbox.com/s/tdye2pobix70gqw/%5BTechBae.com%5DGenymotion-ARM-Translation_v1.1.zip?dl=0
阅读全文
摘要:https://cr.console.aliyun.com/#/accelerator https://www.daocloud.io/mirror.html#accelerator-doc curl -sSL http://acs-public-mirror.oss-cn-hangzhou.ali
阅读全文
摘要:1. linux下先装好 http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html rpm -ivh oracle-instantclient11.2-basic-12.1.0.2.0.x86_64.rpmrpm -iv
阅读全文
摘要:http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html rpm -ivh oracle-instantclient11.2-basic-12.1.0.2.0.x86_64.rpmrpm -ivh oracle-inst
阅读全文
摘要:include_once IA_ROOT . '/lib/log/PDOHandler.php';use Monolog\Logger; $loger = new Logger('name');$pdo = new PDO('mysql:host=xxxxx;dbname=weishop;charset=utf8', 'username', 'password');$dd = new PDOHan...
阅读全文
摘要:<!-- 私有仓库 --> <repositories> <repository> <id>public</id> <!--这个ID需要与你的组group ID一致--> <name>Public Repository</name> <url>http://192.168.11.105:8082/n
阅读全文
摘要:<mirror> <id>CN</id> <name>OSChina Central</name> <url>http://maven.oschina.net/content/groups/public/</url> <mirrorOf>central</mirrorOf></mirror><mir
阅读全文
摘要:ngninxuser _www _www;fastcgi_pass unix:/tmp/php-fmp.sock; php-fpm.conf listen=/tmp/php-fmp.sock 下面几行没有 502错listen.owner=_wwwlisten.group=_wwwlisten.mo
阅读全文
摘要:删除重复记录 DELETE n1 FROM user n1, user n2 WHERE n1.id > n2.id AND n1.tel = n2.tel DELETE FROM user WHERE id NOT IN (SELECT * FROM (SELECT MIN(n.id) FROM user n GROUP BY n.tel ) x)
阅读全文
摘要:eclipse plugin url : http://goclipse.github.io/releases/ 1. recive post json data func UserCreate(w http.ResponseWriter, r *http.Request) { result, er
阅读全文
摘要:本机只要 一行 xdebug.remote_enable=1 非本机 1. xdebug.remote_host=10.109.68.127 开发机的IP 2. PATH MAP要作
阅读全文
摘要:yum install epel-release
阅读全文
摘要:http://blog.csdn.net/shuideyidi/article/details/46891559 1、按WIN+R,在运行框中输入“gpedit.msc” 确认;2、打开本地策略组编辑器后依次展开 :“计算机配置”-》“管理模板”-》“windows组件”-》“windows ins
阅读全文
摘要:解压后 etc/hadoop中的配置 1. hadoop-env.sh 检查JAVA_HOME http://hadoop.apache.org/docs/stable/hadoop-project-dist/hadoop-common/SingleCluster.html sbin/start-dfs.sh NameNode - http://localhost:50070/ ...
阅读全文
摘要:ip addr flush eth0 清除IPcentos ssh 无密码登陆关键 1 /etc/sshd_config RSAAuthentication yesPubkeyAuthentication yes AuthorizedKeysFile .ssh/authorized_keys $ch
阅读全文
摘要:--- ip: "192.168.10.10" networks: - type: "public_network" ip: "10.109.68.147" bridge: "Realtek PCIe GBE Family Controller" memory: 2048 cpus: 1 provider: virtua...
阅读全文
摘要:centos yum install net-tools #ifconfig yum install bind-utils #dig nslookup hostip addr showvi /etc/sysconfig/network-scripts/ifcfg-enp0s3IPADDR = "[在
阅读全文
摘要:一 概念 1 数据字典 2 数据文件 3 控制文件,记录物理结构 4 日志文件 5 表空间 最大的逻辑结构,组强数据和空间分配,可看成数据库对象的容器 SYSTEM,SYSAUX,TEMP 类型 状态:read-write/read-only/offline 作用: 6 段 segment 包含表空间中一种指定类型的逻辑存储结构,是数据区的集合,每个段分配给特定的数据结构,...
阅读全文
摘要:python3 学习笔记 // r 不转义 print(r'\\t\t') //'''多行 print('''afa afa afaff''') 10//3 =>3 内存中统一用unicode编码 当需要保存到硬盘或者需要传输的时候,就转换为UTF-8编码 Python 3版本中,字符串 str 类型 是以Unicode编码的 ord/ch...
阅读全文
摘要:client $time = time() + 5*60; //UNIX timestamp plus a few minutes $apikey = ‘1839390183ABC389101323123’; $hash = hash_hmac(‘ripemd160’, $time, $apikey); You would then append that hash to the...
阅读全文
摘要:windows docker-toolbox sh start.sh ssh account : docker/tcuser docker-machine.exe ip sudo systemctl start/stop/restart/status docker 镜像操作 sudo docker pull mysql sudo docker pull redis sudo...
阅读全文