创建用户本地访问
CREATE USER 'hive'@'hadoop01' IDENTIFIED BY "123456";
grant all privileges on *.* to hive@hadoop01 identified by '123456';
CREATE USER 'hive1'@'localhost' IDENTIFIED BY "123456";
grant all privileges on *.* to hive1@localhost identified by '123456';
创建用户远程访问
create user hive02@'%' identified by '123456'
GRANT ALL PRIVILEGES ON *.* TO hive02@"%" IDENTIFIED BY "123456";
mysql创建用户本地/远程访问
最新推荐文章于 2024-02-01 09:54:13 发布