ishtaka

# install pyenv
brew install pyenv

# install python via pyenv
pyenv install $(pyenv install -l | grep -v - | tail -1)
pyenv rehash
pyenv global $(pyenv install -l | grep -v - | tail -1)

# install pipenv
pip install --upgrade pip

ishtaka

# php version
PHP_VERSION="7.2.2"

# install phalcon
git clone --depth=1 git://github.com/phalcon/cphalcon.git
cd cphalcon/build/
./install

# enable phalcon
cd ~/.phpbrew/php/php-${PHP_VERSION}/var/

ishtaka

# install phpbrew
brew tap homebrew/php
brew install phpbrew

# initialization
phpbrew init
echo "source $HOME/.phpbrew/bashrc" >> ~/.bash_profile
source ~/.bash_profile

# build and install php

ishtaka

# download http://tomcat.apache.org/
cd /tmp
wget http://ftp.tsukuba.wide.ad.jp/software/apache/tomcat/tomcat-8/v8.0.3/bin/apache-tomcat-8.0.3.tar.gz

# make group and user for tomcat 
groupadd -g 1001 tomcat
useradd -u 1001 -g tomcat -s /bin/bash tomcat

# install tomcat
su - tomcat

ishtaka

# install rbenv via anyenv
anyenv install rbenv

# install ruby via rbenv
rbenv install $(rbenv install -l | grep -v - | tail -1)
rbenv rehash
#rbenv global $(rbenv install -l | grep -v - | tail -1)

# install bundler
gem install bundler

ishtaka

# ルートユーザのパスワード設定
SET PASSWORD FOR root@localhost=PASSWORD('**password**');

# MySQLに接続できるユーザの表示
USE mysql
SELECT host,user,password from user;

# パスワード無しのユーザ(匿名ユーザ)の削除
DELETE FROM user WHERE user="";

ishtaka

wget http://sourceforge.net/projects/paco/files/paco/2.0.9/paco-2.0.9.tar.bz2
tar xvf paco-2.0.9.tar.bz2
cd paco-2.0.9
./configure --disable-gpaco
make
make install
make logme

#How to use
# install

ishtaka

<?php

$json_string = file_get_contents('php://input');

echo $json_string;
$obj = json_decode($json_string);
var_dump($obj);

ishtaka

# 一般ユーザuserの作成
useradd user
# passwd centos　←　centosのパスワード設定
passwd user
# New UNIX password: 　←　centosのパスワード応答
# Retype new UNIX password: 　←　centosのパスワード応答(確認)
# ユーザuserの削除
userdel -r user

ishtaka

SELECT table_name, column_name FROM information_schema.columns WHERE column_name ='検索するカラム名';