GRANT ALL on MySQL
1 Answer(s)
DeZyre Support
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
Aug 05 2014 08:10 AM
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