Thank you for the replies. Looks like there was something wrong with the way I created myfirstdb database. Now I can list the tables. The import part is failing with the same issue.
I'll let you know if I I fix it. Thanks again, Chalcy On Wed, Jul 18, 2012 at 11:10 PM, abhijeet gaikwad <[email protected]>wrote: > Hi Chalcy, > Can you try using connection string in this format: > > http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html > > E.g. jdbc:mysql://localhost/myfirstdb?user=root&password=mypassword > > Thanks, > Abhijeet > On 19 Jul 2012 07:56, "[email protected]" <[email protected]> wrote: > >> Hi,Chalcy, >> >> You should grant privileges to the user. >> >> GRANT ALL PRIVILEGES ON *.* TO '%'@'%'; >> GRANT ALL PRIVILEGES ON *.* TO ''@'%'; >> >> if it doesn't work, you should use the true ip of database like: >> jdbc:mysql://192.168.10.12/databases. >> >> good luck. >> >> andy >> http://abloz.com >> >> >> >> 2012/7/19 Chalcy <[email protected]> >> >>> Hi, >>> >>> I am trying to set up a stand alone hadoop cluster and sqoop. I >>> installed mysql, mysql driver, created a new database and a new table and >>> gave permissions etc., >>> >>> I could do the below, >>> mysql --host=localhost --database=myfirstdb --user=root >>> --password=mypassword >>> >>> Then I do show databases and I get all the dbs including myfirstdb. >>> >>> Then tried to sqoop like below, >>> sqoop list-tables --verbose --connect >>> jdbc:mysql://localhost/myfirstdb;username=root;password=mypassword; >>> >>> >>> This errors out and I'll the stack trace below. It seems like not >>> finding the database. >>> >>> Any suggestion is helpful. >>> >>> Thanks, >>> Chalcy >>> >>> ERROR manager.CatalogQueryManager: Failed to list tables >>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied >>> for user ''@'localhost' to database 'myfirstdb' >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native >>> Method) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:513) >>> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) >>> at com.mysql.jdbc.Util.getInstance(Util.java:386) >>> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919) >>> at >>> com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1694) >>> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1244) >>> at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2397) >>> at >>> com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2430) >>> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2215) >>> at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813) >>> at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:513) >>> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) >>> at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) >>> at >>> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334) >>> at java.sql.DriverManager.getConnection(DriverManager.java:582) >>> at java.sql.DriverManager.getConnection(DriverManager.java:207) >>> at >>> com.cloudera.sqoop.manager.SqlManager.makeConnection(SqlManager.java:662) >>> at >>> com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:53) >>> at >>> com.cloudera.sqoop.manager.CatalogQueryManager.listTables(CatalogQueryManager.java:102) >>> at com.cloudera.sqoop.tool.ListTablesTool.run(ListTablesTool.java:51) >>> at com.cloudera.sqoop.Sqoop.run(Sqoop.java:146) >>> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) >>> at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182) >>> at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221) >>> at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230) >>> at com.cloudera.sqoop.Sqoop.main(Sqoop.java:239) >>> 12/07/18 16:10:36 ERROR sqoop.Sqoop: Got exception running Sqoop: >>> java.lang.RuntimeException: >>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied >>> for user ''@'localhost' to database 'myfirstdb' >>> java.lang.RuntimeException: >>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied >>> for user ''@'localhost' to database 'myfirstdb' >>> at >>> com.cloudera.sqoop.manager.CatalogQueryManager.listTables(CatalogQueryManager.java:118) >>> at com.cloudera.sqoop.tool.ListTablesTool.run(ListTablesTool.java:51) >>> at com.cloudera.sqoop.Sqoop.run(Sqoop.java:146) >>> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) >>> at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182) >>> at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221) >>> at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230) >>> at com.cloudera.sqoop.Sqoop.main(Sqoop.java:239) >>> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: >>> Access denied for user ''@'localhost' to database 'myfirstdb' >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:513) >>> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) >>> at com.mysql.jdbc.Util.getInstance(Util.java:386) >>> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919) >>> at >>> com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1694) >>> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1244) >>> at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2397) >>> at >>> com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2430) >>> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2215) >>> at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813) >>> at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native >>> Method) >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:513) >>> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) >>> at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) >>> at >>> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334) >>> at java.sql.DriverManager.getConnection(DriverManager.java:582) >>> at java.sql.DriverManager.getConnection(DriverManager.java:207) >>> at >>> com.cloudera.sqoop.manager.SqlManager.makeConnection(SqlManager.java:662) >>> at >>> com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:53) >>> at >>> com.cloudera.sqoop.manager.CatalogQueryManager.listTables(CatalogQueryManager.java:102) >>> ... 7 more >>> lat-lomoore:~ cmalduraipandian$ >>> Click here to Reply or Forward >>> >> >>
