开发者学堂课程【大数据 Hive 教程精讲：Apache Hive--安装部署-mysql 版安装】学习笔记，与课程紧密联系，让用户快速学习知识。
课程地址：https://developer.aliyun.com/learning/course/90/detail/1364
Apache Hive--安装部署-mysql 版安装
内容介绍：
Hive 安装部署
一、Hive 安装部署
Mysql的安装方式：
Yuma 安装 mysql:
yum install mysql mysql-server mysql-devel
完成后，用/etc/init.d/mysqld start启动 mysql
启动 mysql 控制台:
mysql
mysql>; USE mysql;
mysql>;UPDATE user SET Password=PASSWORD ( 'newpassword') WHERE user='root' ;mysql>; FLUSH PRIVILEGES;
允许远程登录
mysql -u root -p
Enter Password:
mysql>GCRANT ALI PRIVILEGES ON*.* TO '用户名'@'云’IDENTIFIED BY'密码’WITH GRANT OPTION;
完成后就能远程管理 mysql 了。
mysql服务名字service mysqld start
GRANT ALT PRIVILEGES ON *.* To 'root'@ '号’工DENTIFIED BY'密码’WITH GRANT OPTION;
Node-1
updating for dependencies :
e2fsprogs x86_64 1.41.12-23.el6 base 554 k
e2fsprogs-7ibs x86_64 1.41.12-23.ei6 base 121 k
krb5-7ibs x86_64 1.10.3-65.e16 base 675 k
krb5-workstation x86_64 1.10.3-65.ei6 base 814 k
7ibcom_err x86_64 1.41.12-23.e16 base 38 k
7ibselinux x86_64 2.0.94-7.e16 base
109 k
7ibse7inux-uti1s x86_64 2.0.94-7.ei6 base 82 k
1ibss x86_64 1.4i.12-23.e16 base 42 k
mysq1-7ibs x86_64 5.1.73-8.e16_8 base 1.2 M
openss1 x86_64 1.0.1e-57.ei6 base 1.5 M
Transaction summary
Instaii 12 Package(s)
Upgrade 10Package(s)
Tota7 down 1oad size: 17M
Is this ok [y/N]: y
Licensed to the Apache software Foundation (ASF) under oneor more contributor 1icense _agreements. see the NOTICE filedistributed with this work for additional information
regarding copyright ownership. The ASF 1icenses this fileto you under the Apache License，Version 2.0 (the
"License"); you may not use this file except in compliancewith the License. "You may obtain a copy of
the License at
http : //www.apache.org/licenses/LICENSE-2.0
Un1ess required by app1icab1e law or agreed to in writing，softwaredistributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND，either express or implied.see the License for the specific 1anguage governing permissions and
7imitations under the License.
set Hive and Hadoop environment variables here.These variab1es can be usedto contro1 the execution of Hive. It should be used by admins to configurehive-env.sh" 54L，2378c
<configuration>
<property>
<name>javax.jdo.option. ConnectionURL</name>
<value>jdbc:mysal://localhost:3306/hivg2createDatabaseIfNotExist=true</value><description>JDBC connect string for aDBc 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>root</value>
<description>password to use against metastore database</description></property>
</ configuration>
at org.apache.hadoop.hive.c1i.c1iDriver.executeDriver(C11Driver.java:736)at org.apache.hadoop.hive.c1i.cliDriver.run(c1iDriver.java:681)
at org.apache.hadoop.hive.c1i.cliDriver.main(cliDriver.java:6
21)at sun.ref1ect.NativeMethodAccessorImp1.invokeo(Native Method)
at sun.reflect.NativeMethodAccessorImp1.invoke(NativeMethodAccessorImp1.ja
at sun.reflect.DelegatingMethodAccessorImp1.invoke(DelegatingMethodAccesso
r工mp1.java:43)
at java.1ang.ref1ect.Method.invoke(Method.java:497)at org.apache.hadoop.uti1.RunJar.run (RunJar.java:221)at org.apache.hadoop.uti7.RunJar.main(Runar.java:136)
FAILED:ParseException line 1:5 cannot recognize input near 'show' 'itcast’'<EOF>' in ddTstatement
hive> show databases ;oK
defau1titcast
ime taken: 0.286 seconds ,Fetched: 2 row(s)hive>