I would like to ask what management tools everyone is using to connect to the TiDB database

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 想问下各位大佬用的什么管理工具连的TIDB数据库

| username: TiDBer_菜鸟

Since Navicat released a commercial version, the cracked version that the company used before can no longer be used. I want to ask everyone, besides Navicat, what other visual management tools can connect to TiDB? I tried DBeaver and SQLyog but couldn’t connect, so I want to ask what management tools you all are using.

| username: WalterWj | Original post link

DBeaver and SQLyog should be able to connect.

| username: 裤衩儿飞上天 | Original post link

Most MySQL clients available on the market can connect. If you can’t connect, it might be due to a configuration error or network issues.

| username: TiDBer_菜鸟 | Original post link

Does DBeaver use the MySQL driver? When connecting, it appends the IP address to the username, causing access to be denied.

| username: WalterWj | Original post link

It seems like there’s an issue with your configuration…

| username: TiDBer_菜鸟 | Original post link

The network is definitely fine, and I haven’t changed any configurations. I can connect using Navicat, but I get rejected when using DBeaver.

| username: tidb菜鸟一只 | Original post link

Try SQLyog, the connection method is the same as Navicat.

| username: TiDBer_菜鸟 | Original post link

How should I configure it? I’m using the default configuration.

| username: 裤衩儿飞上天 | Original post link

Please share how you connected and configured the connection. Also, try using telnet to check if it’s reachable.

| username: TiDBer_菜鸟 | Original post link

I don’t know why there is an extra IP address that I don’t recognize.

| username: Kongdom | Original post link

I’ve always used DBeaver.

| username: Kongdom | Original post link

This IP is your local IP, right?

| username: WalterWj | Original post link

| username: buddyyuan | Original post link

I use Beekeeper, an open-source software. It’s extremely minimalist and can’t do anything other than writing SQL.

| username: TiDBer_菜鸟 | Original post link

It’s not my local IP… that’s why I’m so puzzled.

| username: ealam_小羽 | Original post link

If it’s the company network, it might be the company’s external IP.

| username: TiDBer_菜鸟 | Original post link

No, I’m connected to a VPN, and the VPN address is not this one.

| username: Jiawei | Original post link

Check your outbound IP on ipip.net.

| username: TiDBer_菜鸟 | Original post link

The image is not visible. Please provide the text you need translated.

| username: TiDBer_菜鸟 | Original post link

There is no IP address like the one in the picture.