查询所有用户的详细信息
[root@ns1 ~]# mysql -uroot -p123 -e "select * from mysql.user \G;" *************************** 1. row *************************** Host: localhost User: root Password: *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: Y References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y Create_view_priv: Y Show_view_priv: Y Create_routine_priv: Y Alter_routine_priv: Y Create_user_priv: Y Event_priv: Y Trigger_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 max_user_connections: 0
查询所有用户的部分信息
[root@ns1 ~]# mysql -uroot -p123 -e "select User, Host, Password from mysql.user;" +--------+-----------+-------------------------------------------+ | User | Host | Password | +--------+-----------+-------------------------------------------+ | root | localhost | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | root | ns1 | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | root | 127.0.0.1 | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | zabbix | localhost | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | test1 | localhost | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | test2 | localhost | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | +--------+-----------+-------------------------------------------+
显示所有的用户(不重复)
[root@ns1 ~]# mysql -uroot -p123 -e "select distinct User from mysql.user;" +--------+ | User | +--------+ | root | | test1 | | test2 | | zabbix | +--------+
转载于:https://blog.51cto.com/quliren/1907921