mysql_user.sql

CREATE USER 'hive'@'localhost' IDENTIFIED BY 'pwd';
CREATE USER 'hive'@'hostxxx' IDENTIFIED BY 'pwd';
GRANT ALL ON hive.* TO 'hive'@'localhost';
GRANT ALL ON hive.* TO 'hive'@'hostxx';
flush privileges;

CREATE USER 'root'@'%';
GRANT ALL PRIVILEGES ON *.* to 'root'@'%' WITH GRANT OPTION;
SET PASSWORD FOR 'root'@'%' = PASSWORD('hortonworks');
SET PASSWORD = PASSWORD('hortonworks');
FLUSH PRIVILEGES;

CREATE USER 'testsqoop'@'localhost' IDENTIFIED BY 'pwd';
CREATE USER 'testsqoop'@'%' IDENTIFIED BY 'pwd';
GRANT ALL PRIVILEGES ON *.* TO 'testsqoop'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'testsqoop'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit