1
SELECT user, host FROM mysql.user;

1
ALTER USER '用户名'@'主机名' IDENTIFIED BY '新密码';
2
-- 常用主机名：localhost, %

1
CREATE USER '用户名'@'主机名' IDENTIFIED BY '密码';

1
CREATE DATABASE 数据库名;

1
-- 赋予权限
2
GRANT 权限 ON 数据库名.表名 TO '用户名'@'主机名';
3
-- ALL PRIVILEGES  所有权限
4
-- GRANT ALL PRIVILEGES ON 数据库名.* TO 'user'@'%';
5

6
-- 刷新权限
7
FLUSH PRIVILEGES;
8

9
-- 验证
10
SHOW GRANTS FOR '用户名'@'主机名';

1
CREATE TABLE `chat_group`(
2
    `id` INT AUTO_INCREMENT PRIMARY KEY,
3
    `user_id` VARCHAR(40) NOT NULL UNIQUE,
4
    `nickname` VARCHAR(100) NOT NULL,
5
    `card` VARCHAR(100),
6
    `role` VARCHAR(40)
7
);

1
DROP TABLE 表名;

1
DELETE FROM users WHERE id = 1;