简述mysql权限验证的过程_MYSQL-用户权限的验证过程(转)-阿里云开发者社区

[root@brucetest7 ~]# mysql -ubruce -p -h10.20.0.231

Enter password:

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

Your MySQL connection id is 8

Server version: 5.5.20-log MySQL Community Server (GPL)

This software comes with ABSOLUTELY NO WARRANTY. This is free software,

and you are welcome tomodify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c'to clear the current inputstatement.

MySQL [(none)]> show grants;

+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Grants for @% |

+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| GRANT SELECT ON*.* TO''@'%' IDENTIFIED BY PASSWORD '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257' |

| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATEROUTINE, EVENT, TRIGGER ON `test`.* TO''@'%' |

| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATETEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATEROUTINE, EVENT, TRIGGER ON `test\_%`.* TO''@'%' |

+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

MySQL [(none)]> select user(), current_user();

+-------------------+----------------+

| user() | current_user() |

+-------------------+----------------+

| bruce@10.20.0.232 | @% |

+-------------------+----------------+

1 row in set (0.00 sec)