配置mysql 8.0.19允许hive接入:
grant all on . to hive@localhost identified by ‘hive’;
报错:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘identified by hive’ at line 1
查看MYSQL手册:
CREATE USER 'hive'@'localhost' IDENTIFIED BY 'hive';
GRANT ALL ON *.* TO 'hive'@'localhost';
问题解决!
mysql> create user ‘hive’@‘localhost’ identified by ‘hive’;
Query OK, 0 rows affected (0.82 sec)
mysql> grant all on . to ‘hive’@‘localhost’;
Query OK, 0 rows affected (0.23 sec)