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.
Thanks , 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 .