scrapy pymysql访问mysql异常

异常：

 raise errorclass(errno, errval)
pymysql.err.OperationalError: (1045, u"Access denied for user 'root'@'sdzn-cdh-test01' (using password: YES)")
2017-11-28 16:40:50 [twisted] CRITICAL: 

 

方案：

mysql>  GRANT ALL PRIVILEGES ON crawler_result.*  TO 'root'@'sdzn-cdh-test01' identified by  'cys' WITH GRANT OPTION;

Query OK, 0 rows affected (0.00 sec)


mysql> flush privileges;