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

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

    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

            • Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              KB_Heinze Karsten Budde
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: