进入mysql
mysql -u root -p
创建数据库
- CREATE DATABASE IF NOT EXISTS test_db_char
- -> DEFAULT CHARACTER SET utf8
- -> DEFAULT COLLATE utf8_chinese_ci;
查询当前用户能看数据库
show databases;
删除库
Drop database test_db_char;
进入刚创建的数据库
use test_db_char;
创建表
create table test(
//列名 字符格式 约束//注意末尾加逗号,最后一列末尾除外
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
PRIMARY KEY USING BTREE (id)
)
ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic;
查看表结构
desc test;
重命名表
rename table test tests;
删除表
Drop table <表名>
用户创建
用户名:pig 密码: 123456
Host:% 任意远程主机登入
Host:localhost 只能本机登入
Host:ip 指定主机
CREATE USER 'pig'@’%’IDENDIFIED BY '123456';
授权用户
授权单个表
GRANT SELECT, INSERT ON test.user TO 'pig'@'%';
授权所有库所有表
GRANT ALL ON *.* TO 'pig'@'%';
授权单个数据库
GRANT ALL ON maindataplus.* TO 'pig'@'%';
删除用户
DROP USER 'username'@'host';