MySQL 登录权限设置SQL语句

最新推荐文章于 2024-06-14 08:00:00 发布

weixin_34402408

最新推荐文章于 2024-06-14 08:00:00 发布

阅读量121

点赞数

文章标签：数据库大数据 python

原文链接：https://my.oschina.net/u/658658/blog/377381

版权

2019独角兽企业重金招聘Python工程师标准>>>

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

转载于:https://my.oschina.net/u/658658/blog/377381