1.創(chuàng)建數(shù)據(jù)庫

create database school;

2.使用數(shù)據(jù)庫

Use school;

3.創(chuàng)建用戶 ?

create user jame@localhost identified by 'jame';

4.授權(quán)用戶(注意這里是用了*哦，自己將school也替換成*號)

grant select,update,insert,create on school.* to jame@localhost identified by 'j ame';

5.取消授權(quán)(現(xiàn)在明白為啥直接敲privilege 沒用了吧？)

revoke select,update,insert,create on school.* from jame@localhost;

6.創(chuàng)建表

create table students(s_name varchar(10) not null,age int(3),sex char(1),heig ht int,s_no varchar(20) not null,primary key(s_no));

7.修改表名

alter table students rename to student;

8.修改列

alter table students change s_name name varchar(20) not null;

9.增加列

alter table student add class varchar(20);

10.刪除列

alter table student drop column class;

11.刪除表

drop table student;

12.刪除用戶

drop user jame;

13.刪除數(shù)據(jù)庫

drop database school;

查看數(shù)據(jù)庫的表結(jié)構(gòu)方法 desc students; 或者 describe students; 另：mysql用戶進入控制臺后無法切換用戶，只能先退出終端，再重新連接。

Mysql 數(shù)據(jù)庫創(chuàng)建基本步驟