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?
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?
Did you specify any IP addresses for the remote access?
|All times are GMT +2. The time now is 20:45.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.