Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4961

COM_REGISTER_SLAVE failed: Access denied for user 'xxxx'@'localhost'

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Incomplete
    • Affects Version/s: 5.5.32
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      OpenVZ Container on Proxmox VE 3.1 (http://www.proxmox.com/)

      Description

      Setup replication and test that it work.
      Create ssh tunnel with stunnel.
      Test that the tunnel works with:
      mysql -u root -h 10.0.0.1 -P 3310 -p
      mysql -u root -h 127.0.0.1 -P 3310 -p

      This DO NOT work
      mysql -u root -h localhost -P 3310 -p

      Change replication:
      stop slave;
      Change master to master_host='10.0.0.1', master_user='xxxx', master_port=3310 ...;
      start slave;
      Last IO Error = ... Access denied for user 'xxxx'@'localhost' ...

      The problem seems to be that it tries to connect to localhost in stead of the server ip (10.0.0.1).

      Localhost is a problem as explained in the article at:
      http://pve.proxmox.com/wiki/Stunnel_in_DAB_appliances
      Near the following position:
      If we use localhost instead of the IP (192.168.5.45) in the above mysql connect string, we will get an error like:

      I believe MariaDB it is trying to use a local socket and not 127.0.01 or 10.0.0.1

        Attachments

          Activity

            People

            Assignee:
            knielsen Kristian Nielsen
            Reporter:
            pierre.se.pos Pierre Joubert
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.