mysql 備忘録

*install  

   sudo apt-get -y install mysql-server

* command 

** DB 作成(data1)

    create databases data1 default character set utf8

** DB 確認

    show databases ;

** Table 作成 (Members)

    create table Members(menberId  int,mail varchar(255),pass binary(40));

** Table確認

    show tables;

** Account作成

    CREATE USER user IDENTIFIED BY [PASSWORD] 'password';

*Tool
**workbench
>| 
sudo apt-get install -y mysql-workbench 
|<
参考：MySQL :: MySQL Workbench :: 2.4.1 Installing