java.sql.SQLException: Your password has expired. To log in you must change it using a client that s

java.sql.SQLException: Your password has expired.To log in you must change it using a client that supports expired passwords.

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:Could not create connection to database server. Attempted reconnect 3 times.Giving up

javax.jdo.JDOFatalDataStoreException: Could notcreate connection to database server. Attempted reconnect 3 times. Giving up.

FAILED:ParseException line 2:0 missing EOF at 'show' near 'tables'

FAILED:Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

FAILED:Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

修改root用户的密码；

?

1    2    3    4    5    6

[html]      mysql> update mysql.user set password=PASSWORD('newpassword') where  User='root';      mysql> flush privileges;              mysql> quit

重新启动MySQL

—————————————————————————————————上面方法可行。下面可以操作了

 

查询mysql中user表：

 

发现表中密码过期，密码过期状态（password_expired字段值）是否为Y，Y表示已过期，需要修改为N

这样sqoop就能正常的往mysql中导数据了