[MXS-2172] mysql cli\shell Created: 2018-11-16  Updated: 2019-10-28  Resolved: 2019-10-28

Status: Closed
Project: MariaDB MaxScale
Component/s: Authenticator
Affects Version/s: 2.2.16
Fix Version/s: 2.4.0

Type: Bug Priority: Major
Reporter: Eric Crepeau Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Environment:

OS X and Windows clients



 Description   

Able to access DBs thru various DB clients, but unable to access using the mysql cli or shell.

Running MaxScale 2.2 connecting to an Aurora Mysql 5.6 backend.

When trying to connect with various accounts from the cli receive:

ERROR 1045 (28000): Access denied for user 'username'@'::ffff:10.X.X.X' (using password: NO)

Username and IP info redacted. Curious is even though password is be supplied deny is saying using password: NO

Command being issued is:

mysql -h maxscale.ourdomain.com -u username -p

Note: user is not root

Pointing the host directly to the aurora host allows access.



 Comments   
Comment by Eric Crepeau [ 2018-11-16 ]

Dropping back to older 5.X version of client works. Above issue was occurring with client version 8.

Comment by markus makela [ 2018-11-16 ]

ecrepeau@sesac.com was it the MySQL 8.0 default authentication plugin that caused it or was it something else? Is this bug still relevant and it is strictly about the MySQL 8.0 command line cliebt?

Comment by markus makela [ 2019-10-28 ]

Most likely fixed by MXS-2369.

Generated at Thu Feb 08 04:12:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.