常用数据库操作

创建数据库并指定使用UTF-8编码

CREATE DATABASE `mydb` CHARACTER SET utf8 COLLATE utf8_general_ci;

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

GRANT privileges ON databasename.tablename TO 'username'@'host';

FLUSH PRIVILEGES;