mysql建库建表


```
CREATE USER 'user'@'%' IDENTIFIED BY '123456';

CREATE DATABASE IF NOT EXISTS dbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS dbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS dbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
GRANT all privileges ON dbname.* TO 'user'@'%';
GRANT all privileges ON dbname.* TO 'user'@'%';
GRANT all privileges ON dbname.* TO 'user'@'%';
FLUSH PRIVILEGES;
posted @ 2018-05-17 16:43  明天OoO你好  阅读(267)  评论(0编辑  收藏  举报