数据库基本操作

创建数据库

CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

 

# 授予用户通过外网IP对于该数据库的全部权限  

grant all privileges on woman_test.* to 'root'@'112.65.170.12' identified by 'sss';

 

revoke all privileges on dbname[.tbname] from username;