Hive Metastore canary创建数据库失败

今天上班时打开CM管理界面，看到

• Hive Metastore Server 运行状况 不良

：查看日志

Retrying creating default database after error: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost:3306/hive?useUnicode=true&characterEncoding=UTF-8, username = root. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

原来是昨天通过CM页面修改hive的配置文件时，hive的

Hive Metastore 数据库密码

javax.jdo.option.ConnectionPassword

被修改成CM管理员账户的密码了，改成mysql数据的密码，问题解决ok