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 >
