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)