MySQL

http://umatomakun.hatenablog.com/entry/2014/04/25/223240


Install in Terminal

Version Check
   $ sudo apt-get update
   $ apt-cache show mysql-server | grep Version

Install
   $ sudo apt-get install mysql-server
   $ mysql --version

Configuration
   $ cd /etc/mysql
   $ cp my.cnf my.cnf.org


Character Code Setup
   $ sudo vi my.cnf


Add Below Section

[client]
default-character-set = utf8

[mysqld]
skip-character-set-client-handshake
character-set-server  = utf8
collation-server      = utf8_general_ci
init-connect          = SET NAMES utf8


Restart MySQL
   $ sudo service mysql restart


Login to MySQL
   $ mysql -u root -p


Check Status of MySQL
   mysql> status


Start, Stop and Re-start,
   $ sudo service mysql start
   $ sudo service mysql stop
   $ sudo service mysql restart

Check Process,
   $ ps aux | grep mysqld


GUI for MySQL
   $ sudo apt-get install mysql-workbench

https://www.adminer.org/


テーブルの作成
http://charlie1012.hatenablog.jp/entry/2015/09/05/170000