Unable to connect to MySql DB

Hello Durga Sir and Team ,

I am unable to access to MySQL DB.

I Tried with different ways like.

mysql -u root -p ( Password which was copied to the clipbord )
mysql -u retail_dba -p ( Password which was copied to the clipbord )
mysql -u amit0900 -p ( Password which was copied to the clipbord )

Still I am not successful to connect to the MySql Console. Please Help me.

Regards ,
Amit

Please follow this video. MySQL DB is on host nn01.itversity.com

I am getting error in it.
Can you check the syntax and let me know please …

Thanks in Advance !!!

Username: retail_dba
Password: itversity

mysql -u retail_dba -h nn01.itversity.com -p

1 Like

Hello,

I also tried to connect to MySql Db using above credential but its faling

Yes Got it.
Instead of connecting to host gw01, try connecting to above mentioned host nn01.
mysql -u retail_dba -h nn01. itversity.com -p

Thanks

I am getting below error:

[praveenv@gw01 ~]$ sqoop import --connect “jdbc:mysql://nn01.itversity.com:3306/retail_db” --username retail_dba --password itveristy --table orders --num-mappers 1 --as-textfile --fiel
ds-terminated-by ‘|’ --lines-terminated-by '\n’
Warning: /usr/hdp/2.5.0.0-1245/accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
16/12/09 12:48:56 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.5.0.0-1245
16/12/09 12:48:56 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
16/12/09 12:48:56 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
16/12/09 12:48:56 INFO tool.CodeGenTool: Beginning code generation
16/12/09 12:48:56 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Access denied for user ‘retail_dba’@‘gw01.itversity.com’ (using password: YES)
java.sql.SQLException: Access denied for user ‘retail_dba’@‘gw01.itversity.com’ (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)

You have typo error for password “itversity”. Sine you didn’t specify the target directory --target-dir

Default it will create folder with table name in your User ID
e.g /user/praveen/orders

1 Like

Thank you gnanaprakasam. I got it.