How can access retail_db db in lab?

Want to run few sql on retail_db db , so how can access retail_db db in lab ?

mysql -h 192.xxx.xxx.xx -u username -p password

enter above command in terminal and access MySQL.
Coming to lab host details, i am not aware, please request from lab subscribers.

if you are talking about the itversity lab then this is syntax
mysql -u retail_dba -h nn01.itversity.com -p

password is itversity.

you can use the same connection parameters in sqoop as well.

1 Like

Thanks :slight_smile: , Now it’s working , earlier also used same credential , don’t know why it was not working .

Does retail_dba have have insert or create table privileges in MySQL retail_db database ?
I am getting below error for export :
Error: java.io.IOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: INSERT command denied to user ‘retail_dba’@‘wn01.itversity.com’ for table ‘departments’ at

Don’t think we have write(insert, update) privileges for retail_db .

no, you only have read access .