mysql 账号权限过期_老师，帮我看下mysql8.0 收回用户权限失效

最新推荐文章于 2022-03-01 11:14:12 发布

内寻读书

最新推荐文章于 2022-03-01 11:14:12 发布

阅读量159

点赞数

文章标签： mysql 账号权限过期

本文链接：https://blog.csdn.net/weixin_35054319/article/details/113418200

版权

[imooc@localhost ~]$ mysql -uroot -p -h******

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 8

Server version: 8.0.16 MySQL Community Server - GPL

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> use mysql

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show grants;

±-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Grants for root@% |

| 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, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON . TO root@% WITH GRANT OPTION |

1 row in set (0.00 sec)

mysql> create user ‘imooc’@’%’ identified by ‘132456’;

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

mysql> set global validate_password=0;

ERROR 1193 (HY000): Unknown system variable 'validate_password’

mysql> set global validate_password.policy=0;

Query OK, 0 rows affected (0.00 sec)

mysql> set global validate_password.length=1;

Query OK, 0 rows affected (0.00 sec)

mysql> create user ‘imooc’@’%’ identified by ‘132456’;

ERROR 1396 (HY000): Operation CREATE USER failed for ‘imooc’@’%‘

mysql> drop user ‘imooc’@’%’;

Query OK, 0 rows affected (0.07 sec)

mysql> create user ‘imooc’@’%’ identified by ‘132456’;

Query OK, 0 rows affected (0.11 sec)

mysql> ALTER USER ‘root’@’%’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;

Query OK, 0 rows affected (0.07 sec)

mysql> ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘lq_mysql2019CN’;