记录安装hive和mysql的那些坑

1.先装mysql再装hive

2.根据这篇博文安装mysql：https://www.jianshu.com/p/276d59cbc529
安装过程debug：https://blog.csdn.net/zxlhaoren/article/details/88022523
Remove Your MySQL Config File很有用

3.查询错误日志：/usr/local/mysql/data/hadoop01.err
使用命令/usr/local/mysql/support-files/mysql.server start启动服务器出错时可以查询错误日志
出现错误：
[ERROR] Can't start server : Bind on unix socket: Address already in use
[ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
[ERROR] COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1'
解决：更改/tmp/mysql.sock的权限
chown -R mysql.mysql tmp/mysql.sock
之后可成功启动服务器

4.启动hive时报错：java.net.ConnectException: Call From hadoop03/192.168.192.103 to hadoop01:9000 failed
解决方法：没启动hdfs。用命令start-dfs.sh启动。

<