mysql 初始化

创建用户

1
2
3
4
5
6
CREATE USER 'juedefansi'@'' IDENTIFIED BY 'juedefansi';
GRANT GRANT OPTION ON *.* TO 'juedefansi'@'';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'juedefansi'@'';

创建数据库

1
2
```
## 创建表

```

分享到 评论