GRANT ALL on MySQL


1 Answer(s)


hi John,

Yes, whenever we do an import/export using Sqoop we have to supply a valid username who is existing within Mysql and this username and password need to be supplied to connect to Mysql. By default 'root' user exists within Mysql.

sqoop import --connect jdbc:mysql://localhost/db1 --username root --password root --table tableName --target-dir /home/cloudera/tableName

Thanks