Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Creating mycsql cdc gives an error, but the user has privileges #12499

Closed
caohb1985 opened this issue Sep 23, 2023 · 4 comments
Closed

Creating mycsql cdc gives an error, but the user has privileges #12499

caohb1985 opened this issue Sep 23, 2023 · 4 comments
Labels
type/bug Something isn't working
Milestone

Comments

@caohb1985
Copy link

Describe the bug

SQL 错误 [XX000]: ERROR: ExecuteError: internal error: source cannot pass validation: INVALID_ARGUMENT: MySQL user doesn't have enough privileges: [RELOAD, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT, SELECT]

Error message/log

No response

To Reproduce

No response

Expected behavior

No response

How did you deploy RisingWave?

No response

The version of RisingWave

No response

Additional context

No response

@caohb1985 caohb1985 added the type/bug Something isn't working label Sep 23, 2023
@github-actions github-actions bot added this to the release-1.3 milestone Sep 23, 2023
@StrikeW StrikeW changed the title 创建mycsql cdc 报错,但是用户是有权限的 Creating mycsql cdc gives an error, but the user has privileges Sep 23, 2023
@StrikeW
Copy link
Contributor

StrikeW commented Sep 23, 2023

Hi could you provide the log of connector node and the version of your mysql version?

@fuyufjh
Copy link
Member

fuyufjh commented Oct 10, 2023

Please reopen if have any updates

@fuyufjh fuyufjh closed this as not planned Won't fix, can't repro, duplicate, stale Oct 10, 2023
@liweilun1
Copy link

I have the same problem
mysql version: 5.7.44
risingwave image tag: nightly-20231031
risingwave-operator image tag: latest

i use this command to grant user privilege
GRANT ALL ON . TO 'szxy_test'@'%';
FLUSH PRIVILEGES;

and use this command create table
CREATE TABLE kubelog_mysql_cdc_source (
container_log_count bigint,
container string,
PRIMARY KEY (container)
) WITH (
connector = 'mysql-cdc',
hostname = 'mysql1.mysql',
port = '3306',
username = 'szxy_test',
password = 'xxx.',
database.name = 'kubelog_count',
table.name = 'kubelog_count',
server.id = '5454'
);

@StrikeW
Copy link
Contributor

StrikeW commented Nov 1, 2023

This is a known issue of the ambiguity of the GRANT ALL in mysql 5.7 and 8.0. Please grant the required privilege explicitly according to our document.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

No branches or pull requests

4 participants