I am getting below error while connecting to mysql hosted on GoDaddy.
pymysql.err.OperationalError: (1045, u"Access denied for user 'ms_dev'@'static.18.104.22.168.clients.your-server.de' (using password: YES)")
I have added static.22.214.171.124.clients.your-server.de on godaddy to allow database from this address but again when I run the spider again the address changed.
Can anyone help me on this?
What are you trying to do? Write the results from the Spider directly to your MySQL database? Have you tested by wildcarding the IP (allow all) if the connection goes fine? Perhaps Scrapinghub has an IP range, but I remember it is tricky to give the specific Scrapinghub range.