Mysql remote access - ERROR 1045 (28000): Access denied for user
Ubuntu + mysql + ispconfig3
Even if the database remote access is enable in ispconfig3 I always get this error when I try to access from another server consol or 3rd party software.
ERROR 1045 (28000): Access denied for user 'user'@'xx.xx.xx.xx' (using password: YES)
Everything works great on localhost consol.
I tried with a couple of database, users and even with root user. Always the same thing.
If I log with phpmyadmin locally, everything is ok.
There must be something that need to be turned on.
I check in the manual but there is no other mention other than the check box enable remote access.Did I miss something?
What do I need to do to remotely access a database from another server/pc?