创建数据库
create database 数据库名;
获取操作权限
grant all privileges on 数据库.* to 数据库@localhost identified by "密码" ;
获取远程访问操作权限
grant select,insert,update,delete,create,drop,alter on 数据库.* to 数据库@'%' identified by '密码';
获取本机操作权限
grant select,insert,update,delete,create,drop,alter on 数据库.* to 数据库@'127.0.0.1' identified by '密码';
刷新权限(必须),否则不生效
flush privileges;