Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Not a Bug
-
10.3.11
-
CentOS Linux release 7.5.1804 (Core)
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