Return-Path: X-Original-To: apmail-ambari-user-archive@www.apache.org Delivered-To: apmail-ambari-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 4210217BB4 for ; Thu, 5 Nov 2015 11:11:18 +0000 (UTC) Received: (qmail 56710 invoked by uid 500); 5 Nov 2015 11:11:18 -0000 Delivered-To: apmail-ambari-user-archive@ambari.apache.org Received: (qmail 56682 invoked by uid 500); 5 Nov 2015 11:11:18 -0000 Mailing-List: contact user-help@ambari.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ambari.apache.org Delivered-To: mailing list user@ambari.apache.org Received: (qmail 56672 invoked by uid 99); 5 Nov 2015 11:11:18 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Nov 2015 11:11:18 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 955201809C1 for ; Thu, 5 Nov 2015 11:11:16 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.651 X-Spam-Level: *** X-Spam-Status: No, score=3.651 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, KAM_INFOUSMEBIZ=0.75, SPF_PASS=-0.001, URIBL_BLOCKED=0.001, WEIRD_PORT=0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 4OdcYoSSkvQL for ; Thu, 5 Nov 2015 11:11:01 +0000 (UTC) Received: from mail-io0-f179.google.com (mail-io0-f179.google.com [209.85.223.179]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id 4A03A20ED5 for ; Thu, 5 Nov 2015 11:11:01 +0000 (UTC) Received: by iody8 with SMTP id y8so85525937iod.1 for ; Thu, 05 Nov 2015 03:11:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=fYAz8+TUa5KJbZOAfbzvfdKDfCBlc+goqeFvcolXVgQ=; b=bWRQhXrHZP7hYbFkS7Zv3agbAvItxTITjnNteYAkeSPYTBX8cQNFyRuS1KHLeJDOtx Rgle3blI6mDgA273A7MzzjOJBFOnnfXZ3GYW5D09vEfOZRkecdo3txsqs71FN4WnwQXw OK9EgbCwW76TP4BRl3WWh58Sm1HLFawphEtNGgIPna/T8AWEK9HcFRI9HNeP2QmMfPdY zM5AJkz1j49e82Y8zE3V2YOj7gobGc54u2FNSmV6kWBCqqBaOpKSKWyvriHKeL6CP7VK YqA5P99/D3eaTC40n1X9jbFwdLbZcCYl17vUfgUgFXzbDwQm6/BFgrQCVKb3LGrMI0J/ qpYg== MIME-Version: 1.0 X-Received: by 10.107.169.167 with SMTP id f39mr8600886ioj.104.1446721860289; Thu, 05 Nov 2015 03:11:00 -0800 (PST) Received: by 10.36.42.205 with HTTP; Thu, 5 Nov 2015 03:11:00 -0800 (PST) In-Reply-To: References: Date: Thu, 5 Nov 2015 12:11:00 +0100 Message-ID: Subject: Fwd: Hive service not starting From: Kaliyug Antagonist To: user@ambari.apache.org Content-Type: multipart/alternative; boundary=001a11427cf8924a0e0523c92e60 --001a11427cf8924a0e0523c92e60 Content-Type: text/plain; charset=UTF-8 An update : I executed the following with -verbose. I dunno why I am still getting the access exception : [root@l1033lab ~]# /usr/hdp/current/hive-metastore/bin/schematool -initSchema -dryRun -verbose -dbType mysql -userName hive -password go4hive WARNING: Use "yarn jar" to launch YARN applications. Metastore connection URL: jdbc:mysql:// l1033lab.sss.se.company.com:3306/hive?createDatabaseIfNotExist=true Metastore Connection Driver : com.mysql.jdbc.Driver Metastore connection User: hive org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version. org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version. at org.apache.hive.beeline.HiveSchemaHelper.getConnectionToMetastore(HiveSchemaHelper.java:80) at org.apache.hive.beeline.HiveSchemaTool.getConnectionToMetastore(HiveSchemaTool.java:114) at org.apache.hive.beeline.HiveSchemaTool.testConnectionToMetastore(HiveSchemaTool.java:160) at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:258) at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:244) at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:483) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) at org.apache.hadoop.util.RunJar.main(RunJar.java:136) Caused by: java.sql.SQLException: Access denied for user 'hive'@' l1033lab.sss.se.company.com' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4101) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1300) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154) at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:792) at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:49) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at org.apache.hive.beeline.HiveSchemaHelper.getConnectionToMetastore(HiveSchemaHelper.java:76) ... 11 more ---------- Forwarded message ---------- From: Kaliyug Antagonist Date: Thu, Nov 5, 2015 at 12:06 PM Subject: Hive service not starting To: user@ambari.apache.org I have installed HDP 2.3 using Ambari 2.1.2. When I attempt to start the Hive Metastore, I get : stderr: /var/lib/ambari-agent/data/errors-811.txt Traceback (most recent call last): File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_metastore.py", line 219, in HiveMetastore().execute() File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 219, in execute method(env) File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_metastore.py", line 55, in start self.configure(env) # FOR SECURITY File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive_metastore.py", line 66, in configure hive(name = 'metastore') File "/usr/lib/python2.6/site-packages/ambari_commons/os_family_impl.py", line 89, in thunk return fn(*args, **kwargs) File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/scripts/hive.py", line 292, in hive user = params.hive_user File "/usr/lib/python2.6/site-packages/resource_management/core/base.py", line 154, in __init__ self.env.run() File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 152, in run self.run_action(resource, action) File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 118, in run_action provider_action() File "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py", line 260, in action_run tries=self.resource.tries, try_sleep=self.resource.try_sleep) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 70, in inner result = function(command, **kwargs) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 92, in checked_call tries=tries, try_sleep=try_sleep) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 140, in _call_wrapper result = _call(command, **kwargs_copy) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 291, in _call raise Fail(err_msg) resource_management.core.exceptions.Fail: Execution of 'export HIVE_CONF_DIR=/usr/hdp/current/hive-metastore/conf/conf.server ; /usr/hdp/current/hive-metastore/bin/schematool -initSchema -dbType mysql -userName hive -passWord [PROTECTED]' returned 1. WARNING: Use "yarn jar" to launch YARN applications. Metastore connection URL: jdbc:mysql:// l1033lab.sss.se.company.com:3306/hive?createDatabaseIfNotExist=true Metastore Connection Driver : com.mysql.jdbc.Driver Metastore connection User: hive org.apache.hadoop.hive.me In the Hive config., I have selected 'New MySQL database'. On the machine l1033lab, there is a MySQL running : [root@l1033lab ~]# mysql -u hive Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 441 Server version: 5.1.73 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> mysql> mysql> select User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv from mysql.user; +------+-------------+-------------+-------------+-------------+-------------+ | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | +------+-------------+-------------+-------------+-------------+-------------+ | root | Y | Y | Y | Y | Y | | root | Y | Y | Y | Y | Y | | root | Y | Y | Y | Y | Y | | hive | Y | Y | Y | Y | Y | +------+-------------+-------------+-------------+-------------+-------------+ 4 rows in set (0.00 sec) mysql> mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | +--------------------+ 3 rows in set (0.00 sec) How shall I proceed ? --001a11427cf8924a0e0523c92e60 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
An update : I executed the following with -verbose. I dunn= o why I am still getting the access exception :


[root@l1033lab ~]# /usr/hdp/current/hive-metastore/bin/schemato= ol -initSchema -dryRun -verbose -dbType mysql -userName hive -password go4h= ive
WARNING: Use "yarn jar" to launch YARN applications= .
Metastore connection URL: =C2=A0 =C2=A0 =C2=A0 =C2=A0jdbc:mysql= ://l1033lab.sss.se.company.com:3306/hive?createDatabaseIfNotE= xist=3Dtrue
Metastore Connection Driver : =C2=A0 =C2=A0com.my= sql.jdbc.Driver
Metastore connection User: =C2=A0 =C2=A0 =C2=A0 h= ive
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to= get schema version.
org.apache.hadoop.hive.metastore.HiveMetaExc= eption: Failed to get schema version.
=C2=A0 =C2=A0 =C2=A0 =C2=A0= at org.apache.hive.beeline.HiveSchemaHelper.getConnectionToMetastore(HiveS= chemaHelper.java:80)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hi= ve.beeline.HiveSchemaTool.getConnectionToMetastore(HiveSchemaTool.java:114)=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hive.beeline.HiveSchem= aTool.testConnectionToMetastore(HiveSchemaTool.java:160)
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveS= chemaTool.java:258)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hiv= e.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:244)
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 at org.apache.hive.beeline.HiveSchemaTool.main(HiveSch= emaTool.java:483)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at sun.reflect.Nati= veMethodAccessorImpl.invoke0(Native Method)
=C2=A0 =C2=A0 =C2=A0 = =C2=A0 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorI= mpl.java:57)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at sun.reflect.Delegatin= gMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
= =C2=A0 =C2=A0 =C2=A0 =C2=A0 at java.lang.reflect.Method.invoke(Method.java:= 606)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hadoop.util.RunJar= .run(RunJar.java:221)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.h= adoop.util.RunJar.main(RunJar.java:136)
Caused by: java.sql.SQLEx= ception: Access denied for user 'hive'@'l1033lab.sss.se.company.com' (using passwor= d: YES)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at com.mysql.jdbc.SQLError.cr= eateSQLException(SQLError.java:1073)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 = at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO= .java:3529)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at com.mysql.jdbc.MysqlIO= .checkErrorPacket(MysqlIO.java:935)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 a= t com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4101)
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:130= 0)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at com.mysql.jdbc.ConnectionImpl.c= oreConnect(ConnectionImpl.java:2337)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 = at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370= )
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at com.mysql.jdbc.ConnectionImpl.cr= eateNewIO(ConnectionImpl.java:2154)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 a= t com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at com.mysql.jdbc.JDBC4Connection.<init= >(JDBC4Connection.java:49)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at sun.= reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at sun.reflect.NativeConstructorAccessorImpl.n= ewInstance(NativeConstructorAccessorImpl.java:57)
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(= DelegatingConstructorAccessorImpl.java:45)
=C2=A0 =C2=A0 =C2=A0 = =C2=A0 at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at com.mysql.jdbc.Util.handleNewInstan= ce(Util.java:411)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at com.mysql.jdbc.C= onnectionImpl.getInstance(ConnectionImpl.java:381)
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegistering= Driver.java:305)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at java.sql.DriverMa= nager.getConnection(DriverManager.java:571)
=C2=A0 =C2=A0 =C2=A0 = =C2=A0 at java.sql.DriverManager.getConnection(DriverManager.java:215)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hive.beeline.HiveSchemaHelp= er.getConnectionToMetastore(HiveSchemaHelper.java:76)
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 ... 11 more

---------- Forwarded message ----------
From: Kaliyug Antagonist <kaliyugantagonist@gmail.com>
Date: = Thu, Nov 5, 2015 at 12:06 PM
Subject: Hive service not starting
To: <= a href=3D"mailto:user@ambari.apache.org">user@ambari.apache.org

=
I have installed HDP 2.3 using Ambari 2.1.2.

<= /div>
When I attempt to start the Hive Metastore, I get :
stderr: =C2=A0 /var/lib/ambari-agent/data/errors-811.txt

Traceback (most recent call last):
=C2=A0= File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/pac= kage/scripts/hive_metastore.py", line 219, in <module>
=C2=A0 =C2=A0 HiveMetastore().execute()
=C2=A0 File "/usr/l= ib/python2.6/site-packages/resource_management/libraries/script/script.py&q= uot;, line 219, in execute
=C2=A0 =C2=A0 method(env)
= =C2=A0 File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2= .0/package/scripts/hive_metastore.py", line 55, in start
=C2= =A0 =C2=A0 self.configure(env) =C2=A0# FOR SECURITY
=C2=A0 File &= quot;/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/sc= ripts/hive_metastore.py", line 66, in configure
=C2=A0 =C2= =A0 hive(name =3D 'metastore')
=C2=A0 File "/usr/lib= /python2.6/site-packages/ambari_commons/os_family_impl.py", line 89, i= n thunk
=C2=A0 =C2=A0 return fn(*args, **kwargs)
=C2=A0= File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/pac= kage/scripts/hive.py", line 292, in hive
=C2=A0 =C2=A0 user = =3D params.hive_user
=C2=A0 File "/usr/lib/python2.6/site-pa= ckages/resource_management/core/base.py", line 154, in __init__
<= div>=C2=A0 =C2=A0 self.env.run()
=C2=A0 File "/usr/lib/pytho= n2.6/site-packages/resource_management/core/environment.py", line 152,= in run
=C2=A0 =C2=A0 self.run_action(resource, action)
=C2=A0 File "/usr/lib/python2.6/site-packages/resource_management/cor= e/environment.py", line 118, in run_action
=C2=A0 =C2=A0 pro= vider_action()
=C2=A0 File "/usr/lib/python2.6/site-packages= /resource_management/core/providers/system.py", line 260, in action_ru= n
=C2=A0 =C2=A0 tries=3Dself.resource.tries, try_sleep=3Dself.res= ource.try_sleep)
=C2=A0 File "/usr/lib/python2.6/site-packag= es/resource_management/core/shell.py", line 70, in inner
=C2= =A0 =C2=A0 result =3D function(command, **kwargs)
=C2=A0 File &qu= ot;/usr/lib/python2.6/site-packages/resource_management/core/shell.py"= , line 92, in checked_call
=C2=A0 =C2=A0 tries=3Dtries, try_sleep= =3Dtry_sleep)
=C2=A0 File "/usr/lib/python2.6/site-packages/= resource_management/core/shell.py", line 140, in _call_wrapper
=C2=A0 =C2=A0 result =3D _call(command, **kwargs_copy)
=C2=A0 = File "/usr/lib/python2.6/site-packages/resource_management/core/shell.= py", line 291, in _call
=C2=A0 =C2=A0 raise Fail(err_msg)
resource_management.core.exceptions.Fail: Execution of 'export = HIVE_CONF_DIR=3D/usr/hdp/current/hive-metastore/conf/conf.server ; /usr/hdp= /current/hive-metastore/bin/schematool -initSchema -dbType mysql -userName = hive -passWord [PROTECTED]' returned 1. WARNING: Use "yarn jar&quo= t; to launch YARN applications.
Metastore Connection Driver : com.mysql.jdbc.Driver
Metastore connection User:= hive





[root@l1033lab ~]# mysql -u hive
Welcome to the MyS= QL monitor.=C2=A0 Commands end with ; or \g.
Your MySQL connectio= n id is 441
Server version: 5.1.73 Source distribution
=
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All = rights reserved.

Oracle is a registered trademark = of Oracle Corporation and/or its
affiliates. Other names may be t= rademarks of their respective
owners.

Ty= pe 'help;' or '\h' for help. Type '\c' to clear the= current input statement.

mysql>
mysq= l>
mysql> select User,Select_priv,Insert_priv,Update_priv,D= elete_priv,Create_priv from mysql.user;
+------+-------------+---= ----------+-------------+-------------+-------------+
| User | Se= lect_priv | Insert_priv | Update_priv | Delete_priv | Create_priv |
+------+-------------+-------------+-------------+-------------+--------= -----+
| root | Y =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Y =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Y =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Y =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Y =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
| root | Y =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Y =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 | Y =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Y =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 | Y =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
| r= oot | Y =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Y =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 | Y =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Y =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 | Y =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
| hive | Y = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Y =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |= Y =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Y =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 | Y =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
+------+------------= -+-------------+-------------+-------------+-------------+
4 rows= in set (0.00 sec)

mysql>
mysql> s= how databases;
+--------------------+
| Database =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
+--------------------+
|= information_schema |
| mysql =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0|
| test =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 |
+--------------------+
3 rows in set (0.00 sec= )

How shall I proceed ?

=


--001a11427cf8924a0e0523c92e60--