1. 使用root进入mysql
mysql -uroot -p123456
2 查看用户表
select host, user, plugin from mysql.user;
// 返回如下 % 是主机地址，可远程 caching_sha2_password 是加密规则
+-----------+------------------+-----------------------+
| host | user | plugin |
+-----------+------------------+-----------------------+
| % | root | caching_sha2_password |
| % | z2 | mysql_native_password |
| % | zhangsan | caching_sha2_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session | caching_sha2_password |
| localhost | mysql.sys | caching_sha2_password |
| localhost | root | caching_sha2_password |
+-----------+------------------+-----------------------+
show databases; // 查看数据库， 除test-v2 数据库，其余四个为 mysql 默认数据库，其中mysql.user表可以操作用户信息
+--------------------+
| Database |
+--------------------+
| test-v2 |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
3. 创建新用户 and 修改用户密码\删除用户
// 创建用户 zhangsan 密码为123456
// 注意修改用户密码、主机也可以用此条命令
CREATE USER IF NOT EXISTS 'zangsan'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
// mysql 返回此行 表示命令成功
Query OK, 0 rows affected (0.17 sec)
// 修改用户密码
alter user 'zhangsan'@'%' identified with caching_sha2_password by '110112';
// 删除用户没有引号
drop user zhangsan;
4. 增加用户权限
// 给用户 zhangsan 权限
grant SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, INDEX,
ALTER,CREATE VIEW, SHOW VIEW, EVENT, TRIGGER, CREATE TABLESPACE
ON *.* TO 'zhangsan'@'%';
-- 查看权限
show grants for zhangsan;
-- 收回用户zhangsan的所有权限
revoke all privileges on *.* from zhangsan;
var code = "2990acd3-900c-458b-8ca6-792d3359c0ca"
