关于#hive#的问题：Access denied for user 'root'@'node1' to database 'hive3'SQL Error code

Question

Underlying cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException : Access denied for user 'root'@'node1' to database 'hive3'
SQL Error code: 1044
Use --verbose for detailed stacktrace.
*** schemaTool failed ***

Answer 1

没有数据库的读写权限，记得给这个用户授权。

上述错误是因为 mysql 服务器中 'hive'@'localhost' 的权限不足。以 root 身份启动 mysql shell，然后在那里执行以下授权选项

$ mysql -u root -p -hlocalhost
Enter password: 

mysql> GRANT ALL PRIVILEGES ON *.* TO  'root'@'node1'  IDENTIFIED BY 'password';
mysql> FLUSH PRIVILEGES;