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');