Mac 10.11.6 Mysql

1. Download and install Mysql

2. initial password for root@localhost: xt?Y3Y/QalkU

3. entering mysql:

  $ mysql -u root -p 

    entering mysql:  

    (first time reset password)

  mysql> SET PASSWORD = PASSWORD('root');

  mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

  mysql>  flush privileges;  

   (create database/user)

  mysql> create database db_zyGroup;

  mysql> show databases;  

  mysql> create user 'zyGroup' identified by 'zyGroup';

  mysql> select host,user from mysql.user; 

  mysql> grant select,insert,update,delete,create on db_zyGroup.* to zyGroup;

 (create table)

  mysql> use db_zyGroup;

  mysql> create table account(username char(20),password_md5 char(20));

 mysql> reate table image_info(token char(20));

 mysql> insert into account values('group3','group3');