mysql安装使用--2 用户管理
1 修改mysql.user表
添加用户
mysql> INSERT INTO mysql.user (Host,User,Password) VALUES (\'%\',\'system\', PASSWORD(\'manager\'));
mysql> FLUSH PRIVILEGES
2 create 和 grant命令省略
3 user表内容
MySQL用户名由两部分组成：(user, host)，二者是联合主键。
describe mysql.user;
Field | Type | Null | Key | Default | Extra |
+------------------------+-----------------------------------+------+-----+---------+-------+
| Host | char(60) | NO | PRI | | |
| User | char(16) | NO | PRI | |
%表示对应user可以从任意地址登录,localhost表示只能本地登录
select * from user limit 10;
+--------------+---------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv
| Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv
| ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string |
+--------------+---------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+
| localhost | root | *949B9BA5F728DDB5C35A6BF29CF896B9A1F5E7E3 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
Y | | | | | 0 | 0 | 0 | 0 | | |
| % | **** | *2F2DBDE71A51D19B22DB0D5665E8F4F4DFDA8C6A | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
Y | | | | | 0 | 0 | 0 | 0 | | |
| 192.168.3.11 | root | *949B9BA5F728DDB5C35A6BF29CF896B9A1F5E7E3 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
Y | | | | | 0 | 0 | 0 | 0 | | |
| ::1 | root | *949B9BA5F728DDB5C35A6BF29CF896B9A1F5E7E3 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
Y | | | | | 0 | 0 | 0 | 0 | | |
| 192.168.3.13 | repl | *FD571203974BA9AFE270FE62151AE967ECA5E0AA | N | N | N | N | N | N | N | N | N | N | N | N | N | N
| N | N | N | N | N | Y | N | N | N | N | N | N | N | N |
N | | | | | 0 | 0 | 0 | 0 | | NULL |
| % | read | *DEE0C5DA1B54F7D4BA0B60BDE7B6D50BBFA3B8AF | Y | N | N | N | N | N | N | N | N | N | N | N | N | N
| N | N | N | N | N | N | N | N | N | N | N | N | N | N |
N | | | | | 0 | 0 | 0 | 0 | | NULL |
+--------------+---------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+
6 rows in set (0.00 sec)
