MySQL 登录权限设置SQL语句

1. 创建hive用户

create user 'hive'@'master' identified by 'hive';

2. 对hive用户赋予权限

grant all privileges on *.* to 'hive'@'master' identified by 'hive' with grant option;

浏览权限记录

mysql> show grants for hive@'master';

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

| Grants for hive@master |

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

| GRANT ALL PRIVILEGES ON *.* TO 'hive'@'master' IDENTIFIED BY PASSWORD '*4DF1D66463C18D44E3B001A8FB1BBFBEA13E27FC' WITH GRANT OPTION |

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

1 row in set (0.00 sec)

3. 刷新权限

flush privileges;

4. 登录测试

mysql -h master -uhive -phive

5. 查看用户的账号信息和密码

mysql> select host,user,password from user where user='hive';

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

| host | user | password |

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

| localhost | hive | *4DF1D66463C18D44E3B001A8FB1BBFBEA13E27FC |

| master | hive | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |

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

2 rows in set (0.00 sec)

6. 更新账号的密码

mysql> update user set password=password('hive') where user='hive' and host='master';

Query OK, 1 row affected (0.13 sec)

.....