sql语句整合_自己以后整理

GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'user1'@'localhost';
CREATE USER user01@'%' IDENTIFIED BY 'password1';
GRANT ALL PRIVILEGES ON db01.* TO user01;
GRANT SELECT  ON *.* TO 'user02'@'%' IDENTIFIED by 'password2';


DROP DATABASE IF EXISTS userdb;
CREATE DATABASE userdb;
USE userdb;
CREATE TABLE user(
id int(11)NOT NULL AUTO_INCREMENT, 
userName varchar(20) DEFAULT NULL, 
userPwd varchar(20) DEFAULT NULL, 
PRIMARY KEY (id) 
)ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO user(id,userName,userPwd)VALUES(1,'admin','admin');


grant all on 数据库.* to 用户名@'主机' IDENTIFIED by 'password'