Mysql remote access - ERROR 1045 (28000): Access denied for user

Discussion in 'Installation/Configuration' started by spazio, Sep 10, 2012.

  1. spazio

    spazio Member

    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?
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Please check the /etc/my.cnf or /etc/mysql/my.cnf file on your server, the line :

    bind-address =

    has to be commented out. Restart mysql when you changed the file.
  3. spazio

    spazio Member

    The line bind-address = 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?

  4. falko

    falko Super Moderator ISPConfig Developer

    Did you specify any IP addresses for the remote access?

Share This Page