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

Connect-Table-Type MYSQL: access denied when create table

    XMLWordPrintable

Details

    Description

      Hello,

      I want to use a connect-table between two mariaDB databases.
      The target db-server is named host1 and there is a mariaDB db1 with user user1.
      The source db-server is named host2 and there is a mariaDB db2 with user user2.
      user1 is not in db2 and user2 is not in db1.

      When I run the following statement as user1 in db1:

      create or replace table test1
       engine = connect
       table_type = MYSQL
       dbname = db2
       tabname = testtab
       connection = 'mysql://user2:password2@host2';
      

      in db1 table test1 is created.

      When I run the following statement as user1 in db1:

      create or replace table test2
       (column1 int not null,
        column2 varchar)
       engine = connect
       table_type = MYSQL
       dbname = db2
       tabname = testtab
       connection = 'mysql://user2:password2@host2';
      

      I get the error

      SQL-Fehler [1045] [28000]: (conn=95) Access denied for user 'user1'@'%' (using password: YES)
      

      Then I create user user1 in db2 on host2 with all privileges and retry creating the conntect-table. But I get always the error

      SQL-Fehler [1045] [28000]: (conn=95) Access denied for user 'user1'@'%' (using password: YES)
      

      I don't know, what is wrong. Please help me.

      Regards,
      Karsten

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            KB_Heinze Karsten Budde
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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