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

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

  1. spazio

    spazio Member

    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?
     
  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 = 127.0.0.1

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

    spazio Member

    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
     
  4. falko

    falko Super Moderator ISPConfig Developer

    Did you specify any IP addresses for the remote access?
     

Share This Page