MySQL

1. 查看所有用户
   https://www.linuxprobe.com/mysql-show-all-users.html

   SELECT User, Host FROM mysql.user;
   SELECT DISTINCT User FROM mysql.user;  # 查看所有用户 不重复

2. mysql 8.0 修改密码

   ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

3. mysql 查看用户权限

   SHOW GRANTS FOR 'testuser1'@'localhost';  # 查看权限
   grant all privileges on db_one.* to 'test'@'%';  # 授予权限
   flush privileges;  # 刷新权限