创建一个远程连接用户,‘hadoop’@’%’(hadoop是用户名,%是允许任意远程主机连接)
mysql> create user 'hadoop'@'%' identified by '123456';
Query OK, 0 rows affected (0.08 sec)
mysql> grant all PRIVILEGES on hadoop.* to 'hadoop'@'%' with grant option;
Query OK, 0 rows affected (0.09 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
mysql>
允许本地连接
mysql> create user 'hadoop'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.13 sec)
mysql> grant all PRIVILEGES on hadoop.* to 'hadoop'@'localhost' with grant option;
Query OK, 0 rows affected (0.10 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.18 sec)
mysql>
备注:hadoop.* 中hadoop是数据库名称,*是任意表名,即表示将hadoop数据库的所有表操作权限授予
【参考】