//生成默认密码,然后登录后修改
grep 'temporary password' /var/log/mysqld.log
mysql -uroot-p//修改全局参数以便修改密码//检查是否安装validate_password插件
SHOW VARIABLES LIKE 'validate_password%';
//修改validate_passwhiord_policy参数的值setglobal validate_password_policy=0;
//设置root账户密码set password for 'root'@'localhost'=password('rootroot');
vim /usr/local/hive-1.2.1/conf/hive-site.xml
//具体配置如下
<configuration><property><name>javax.jdo.option.ConnectionURL</name><value>jdbc:mysql://master:3306/hivecreateDatabaseIfNotExist=true&useSSL=false</value><description>JDBC connect string for a JDBC metastore</description></property><property><name>javax.jdo.option.ConnectionDriverName</name><value>com.mysql.jdbc.Driver</value><description>Driver class name for a JDBC metastore</description></property><property><name>javax.jdo.option.ConnectionUserName</name><value>root</value><description>Username to use against metastore database</description></property><property><name>javax.jdo.option.ConnectionPassword</name><value>rootroot</value><description>password to use against metastore database</description></property><property><name>hive.server2.logging.operation.log.location</name><value>/usr/local/hive-1.2.1/iotmp/operation_logs</value><description>Top level directory where operation logs are stored if logging functionality is enabled</description></property><property><name>hive.exec.scratchdir</name><value>/tmp/hive</value><description>HDFS root scratch dir for Hive jobs which gets created with write all (733) permission. For each connecting user, an HDFS scratch dir: ${hive.exec.scratchdir}/<username> is created, with ${hive.scratch.dir.permission}.</description></property><property><name>hive.exec.local.scratchdir</name><value>/usr/local/hive-1.2.1/iotmp</value><description>Local scratch space for Hive jobs</description></property><property><name>hive.downloaded.resources.dir</name><value>/usr/local/hive-1.2.1/iotmp</value><description>Temporary local directory for added resources in the remote file system.</description></property><property><name>hive.querylog.location</name><value>/usr/local/hive-1.2.1/iotmp</value><description>Location of Hive run time structured log file</description></property></configuration>