rrylee
9/10/2015 - 3:30 PM

创建数据库,指定用户权限

创建数据库,指定用户权限

CREATE DATABASE IF NOT EXISTS table_name COLLATE utf8_general_ci;

CREATE USER 'username'@'host' IDENTIFIED BY 'password';

GRANT SELECT, INSERT, UPDATE, DELETE ON table_name.* TO 'username'@'host';