mysql登录及创建用户，授权

mysql version 5.5.6

mysql
一开始没有密码直接进入： mysql
	use mysql;
	update user set password=password("123456") where user='root';
	flush privileges;
	exit;
新建用户： 用户名buildgw， 密码djs@12316
	MySQL -u root -p 123456
	CREATE USER 'buildgw'@'localhost'  IDENTIFIED BY 'djs@12316';
	exit;
测试： 
    mysql -u buildgw -pdjs@12316
    quit;
创建数据库：
	mysql -uroot -p123456
	create database build charset=utf8;
	show database;

授权：授所有权限给buildgw用户，但是在其他机器登录只可以看到build数据库
	grant all privileges on build.* to "buildgw"@"%" identified by "asdf@1234";
或者GRANT all privileges  ON build.buildapp TO 'buildgw'@'%' IDENTIFIED BY 'asdf@1234' WITH GRANT OPTION;
	flush privileges; 
如果想授权其他机器，
    grant all privileges on *.* to "buildgw"@"%" identified by "djs@12316" with grant option;
    flush privileges;

删除用户：
	mysql -u root -p 
    Delete FROM mysql.user Where User=”buildgw” and Host=”localhost”; 
    flush privileges; 
    drop database testDB;
修改用户密码：
	mysql -u root -p 
    update mysql.user set authentication_string=password(“新密码”) where User=”buildgw” and Host=”localhost”; 
    flush privileges;
修改用户名： 将用户名buildgw改为yunwei
    mysql -uroot -p
    use mysql;  选择数据库
    update user set user="yunwei" where user="buildgw";    


mysql 5.7版本修改密码：
update user set authentication_string=password('123456') where user='root';

MySQL建表，插入数据

CREATE TABLE order_2017
(
`order_id` VARCHAR(20) NOT NULL DEFAULT '' '唯一的订单编号',
`cust_id` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '顾客ID',
`date` date DEFAULT NULL COMMENT '交易日期',
`original_value` DOUBLE(10,2) DEFAULT '0.00' COMMENT '订单原始金额',
`discount` DOUBLE(10,2) DEFAULT '0.00' COMMENT '订单折扣金额',
`items` INT(11) NOT NULL DEFAULT '0' COMMENT '订单购买数量',
PRIMARY KEY (`order_id`)
)
ENGINE=INNODB auto_increment=1 DEFAULT CHARSET=utf8 COMMENT='2017订单表'
;


INSERT INTO order_2017
(`order_id`,`cust_id`,`date`,`original_value`,`discount`,`items` )
VALUES
('001','C6','2017/02/03','199.05','99.03','8'),
;

字段名可以不写，插入多条
INSERT INTO order_2017
VALUES
('002','C6','2017/02/03','199.05','99.03','8'),
('003','C6','2017/02/03','199.05','99.03','8')
;