Unable to connect to database on local subnet

[nicklasring]

1. Database version mysqld Ver 5.7.26-29 for debian-linux-gnu on x86_64 (Percona Server (GPL), Release '29', Revision '11ad961')

2. TablePlus version Alpha Build 38

3. Linux distro Debian GNU/Linux 10 (buster), 4.19.0-6-amd64

4. The steps to reproduce this issue: Create a new connection, enter private IP, username,password, database name

Does not work with either MariaDB or MySQL, tested without setting password, dbname and so on. Unable to connect 'Access denied for user @ ip', SSH-tunneling works though.

[thien-do]

Hi @nicklasring , the message comes from the database itself, not from TablePlus. Can you double check that it allows you to access (e.g. accessing from another IP)?

Also have you been able to access the database with another client?

[nicklasring]

Yes there is no issues connecting to the database from other clients and IP's on the local subnet.

[pgalilea]

Same problem here

I can connect using dbeaver or adminer

[nicklasring]

Let's hope it is atleast somewhat usable next patch iteration. Stuck with DBEaver until then :)

[snutij]

Hi, same results that @pgalilea. Works fine with dbeaver ! :)

[huyphams]

Are you using the latest release @snutij ?

[snutij]

@huyphams, TablePlus Alpha 0.1 - Build 84 to be exact, seems the latest release

[beppler]

It appears that if you use localhost on "Database host/socket" TablePlus try to connect using the socket, if you change to 127.0.0.1 or ::1 it connects using sockets.

[huyphams]

Hi @beppler the native library will try to connect using TCP first then if it fails it fallback to the socket. But if you use the IP, it won't do the fallback.

[beppler]

It is weird that when I tried to connect using this information, I received an error mentioning the socket:

Then when I changed it to use ::1, it worked.

[zzqayy]

In linux, when i use mysql-client connect to 127.0.0.1,it's success,but use tableplus,it's failed!