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

add a configuration to set default_catalog #55069

Open
gwy1995 opened this issue Jan 14, 2025 · 2 comments
Open

add a configuration to set default_catalog #55069

gwy1995 opened this issue Jan 14, 2025 · 2 comments

Comments

@gwy1995
Copy link

gwy1995 commented Jan 14, 2025

Feature request

Is your feature request related to a problem? Please describe.

My starrocks cluster is shared-data on hdfs, when I am using mysql client, I always need to set catalog first.

Describe the solution you'd like

add a configuration to set default_catalog

Describe alternatives you've considered

The init_command parameter in mysql command line tool conflicts with -D parameter, it will return ( 5501, "Unknown database )

Additional context

nothing

@alvin-celerdata
Copy link
Contributor

@gwy1995 You can use Alter User statement to set default catalog for particular users.
https://docs.starrocks.io/docs/sql-reference/sql-statements/account-management/ALTER_USER/

@gwy1995
Copy link
Author

gwy1995 commented Jan 15, 2025

@gwy1995 You can use Alter User statement to set default catalog for particular users. https://docs.starrocks.io/docs/sql-reference/sql-statements/account-management/ALTER_USER/

Thank you for your help. This solved my problem to a certain extent, but there are still some problems. For example, I still cannot use the -D parameter of the mysql command line tool, and the error ERROR 5501 (3F000): Unknown database will still be reported.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants