search

StarRocks / starrocks

StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries.
https://starrocks.io
Apache License 2.0
8.73k stars 1.75k forks source link

Issue connecting to starrocks via MySQLWorkbench #19397

Open alberttwong opened 1 year ago

alberttwong commented 1 year ago

works fine if you connect via CLI

atwong@Alberts-MBP ~ % /Applications/MySQLWorkbench.app/Contents/MacOS/mysql -h
127.0.0.1 -P9030 -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 58
Server version: 5.1.0 StarRocks version UNKNOWN

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

However it doesn't work using MySQLWorkbench (v 8.0.32) on Mac Ventura 13.2.1

Screenshot 2023-03-11 at 8 26 18 PM
ghost commented 1 year ago

mysqlworkbench is using latest protocol which SR does not support yet.

github-actions[bot] commented 1 year ago

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!

alberttwong commented 1 year ago

still an issue.

github-actions[bot] commented 6 months ago

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!

alberttwong commented 6 months ago

it works in dbeaver as of Jan 2024 so I'm assuming it works for mysqlworkbench.

github-actions[bot] commented 6 hours ago

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!