greptimedb icon indicating copy to clipboard operation
greptimedb copied to clipboard

Use Mysql client connect failed: 'mysql_native_password' cannot be loaded

Open leaf-potato opened this issue 6 months ago • 4 comments

What type of bug is this?

Unexpected error

What subsystems are affected?

Distributed Cluster

Minimal reproduce step

  1. use gtctl create a cluster.
gtctl playground
  1. use mysql client connect to greptimedb.
mysql -h 127.0.0.1 -P 4002

What did you expect to see?

Use Mysql client connect to greptimedb successfully.

What did you see instead?

image

What operating system did you use?

Max OS Ventura 13.4 ARM

What version of GreptimeDB did you use?

0.9.0

Relevant log output and stack trace

ERROR 2059 (HY000): Authentication plugin 'mysql_native_password' cannot be loaded:  
dlopen(/opt/homebrew/Cellar/mysql/9.0.1/lib/plugin/mysql_native_password.so, 0x0002): tried:    
'/opt/homebrew/Cellar/mysql/9.0.1/lib/plugin/mysql_native_password.so' (no such file),  
'/System/Volumes/Preboot/Cryptexes/OS/opt/homebrew/Cellar/mysql/9.0.1/lib/plugin/mysql_native_password.so' (no  
such file), '/opt/homebrew/Cellar/mysql/9.0.1/lib/plugin/mysql_native_password.so' (no such file)

leaf-potato avatar Aug 05 '24 13:08 leaf-potato