Mysql Access denied with right username and password in pyspider

[Alex W]

I have set all of them in my code, but it still showed a wrong msg when i start pyspider with 'pyspider -c config.json'.

Even though I can handle mysql with the username and password by terminal and client, pyspider still can not work!

[Roy Binux]

Why error message said nzhg@localhost instead of 127.0.0.1? The permission to login for localhost and 127.0.0.1 are different in MySQL.

--
You received this message because you are subscribed to the Google Groups "pyspider-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pyspider-user...@googlegroups.com.
To post to this group, send email to pyspide...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pyspider-users/1d308d01-8ccd-415c-b4e8-d98a8a01630d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Reid Du]

this problem comes from mysql 5.7 ,you can have two  solutions:

1) use  mysql <= 5.6

2) add data user  from  127.0.0.1 and localhost,both is needed .

在 2018年12月16日星期日 UTC+8下午9:24:21，Alex W写道：