CREATE CATALOG 报错[Err] 5087 - errCode = 2, detailMessage = Access denied for user 'cbm' to catalog 'test'

Viewed 28

CREATE CATALOG test PROPERTIES (
"type"="jdbc",
"user"="*",
"password"="
",
"jdbc_url" = "jdbc:mysql://localhost:3306/test",
"driver_url" = "mysql-connector-java-8.0.25.jar",
"driver_class" = "com.mysql.cj.jdbc.Driver"
)
创建CREATE CATALOG 报错SQL 错误 [5087] [42000]: errCode = 2, detailMessage = Access denied for user 'cbm' to catalog 'mysql'

1 Answers

cbm 用户没有 test 权限,或者mysql 没有 test 库,检查一下