ERROR 3680 (HY000): Failed to create schema directory 'hive' (errno: 13 - Permission denied)

There may be a permissions issue with the MySQL data directory. You could try setting the permissions as follows (adjust the path to your data directory)

注意需要提升权限 sudo

chown -R mysql:mysql /usr/local/mysql/data