登录mysql:有个初始用户root
创建用户:create user 'BOOKSQL' @ 'localhost' IDENTIFIED BY 'zhang'
创建一个BOOKSQL用户, 密码为zhang
给用户权限:
GRANT ALL privileges
on *.*
to 'BOOKSQL' @ 'localhost'
with grant option
创建数据库:create database TENNIS
选择当前数据库:USE TENNIS , 或者登录的时候指定:mysql -u BOOKSQL -p TENNIS
创建表:create table PLAYERS
(PLAYERNO INTEGER NOT NULL,
NAME, CHAR(15), NOT NULL,
PRIMARY KEY(PLAYERNO))
用数据填充表:INSER INTO PLAYERS VALUES
(6, 'paramter')
赋予用户权限:
grant select
on PLAYERS
to DIANE
将表PLAYSERS的select权限给DIANE
查看系统版本:select @@VERSION
目录表:可以查询,不能使用UPDATE和DELETE