mysql创建用户并给与一个完整的数据库，怎么写语句

Question

如题所述

Answer 1

1、用管理员登陆mysql
2、创建数据库create database db01;
3、创建用户
user01只能本地访问
CREATE USER user01@'localhost' IDENTIFIED BY 'password1';
user02可以远程访问
CREATE USER user02@'%' IDENTIFIED BY 'password1';
4、修改user01密码
SET PASSWORD FOR 'user01'@'localhost' = PASSWORD('password2');
5、授权
a)、user01管理db01全部权限
GRANT ALL PRIVILEGES ON db01.* TO user01;
b)、user02查看权限，并修改密码
GRANT SELECT ON *.* TO 'user02'@'%' IDENTIFIED by 'password2';

Answer 2

新建普通用户：CREATE USER 'test1'@'localhost' IDENTIFIED BY 'test1'
数据库创建：CREATE DATABASE example
表的创建：CREATE TABLE example0(id INT,
name VARCHAR(20),
sex BOOLEAN
)

Answer 3

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

Answer 4

creat user bookstoreUSer
for login bookstoreUSer
with default_schema＝dbo
go

Answer 5

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