Hi 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?
Please check the /etc/my.cnf or /etc/mysql/my.cnf file on your server, the line : bind-address = 127.0.0.1 has to be commented out. Restart mysql when you changed the file.
The line bind-address = 127.0.0.1 is commented out! Mysql is listenning on all the ip. If I create a user manually and give it access from the remote ip. Every thing work ok but not with user/pass created in ispconfig! I just don't want to recreate all the users! Is it supposed to work out of the box with ispconfig users? S
