Access denied for user 'xxx'@'xxxxxx'

Question

I have a software which communicate with a remote mysql server. After updating the mysql on the remote host I get

2014-07-04 10:11:39.8750Access denied for user 'xxx'@'xxxxxx' (using password: YES)

When I try to connect to the remote mysql from the computer that running the software with the same user and pass there is no problem to connect. Any ideas?

Answer 1

You have to configure the user ACL. Probably your user currently can access to db only from localhost. You have to grant access from the remote machine client IP. Example:

GRANT ALL PRIVILEGES ON *.* TO 'user'@'%'

for all privileges from all ip addresses. You can also replace the '%' with you remote machine IP