could not use requested auth plugin '': this authentication plugin is not supported

[dwlnetnl]

Issue description

After upgrading from version 1.3 to 1.4, I got log messages about an authentication plugin not supported. Nothing is changed on the server side of things.

Error log

could not use requested auth plugin '': this authentication plugin is not supported
unknown auth plugin:

Configuration

Driver version (or git SHA): d523deb

Go version: 1.10.3

Server version: MySQL 5.5.59-cll

Server OS: unknown

[kwoodhouse93]

I'm seeing a similar problem, although with a different plugin that apparently cannot be used.

[mysql] 2018/07/02 17:10:36 driver.go:120: could not use requested auth plugin 'mysql_native_password': this user requires mysql native password authentication.

The change appears to have been introduced by affd4c9, as earlier revisions have no such problem despite no changes to the server or the client code. I also noticed this when upgrading from 1.3.0 to 1.4.0.

Server version: mysql:5.7 docker image
Go version: go version go1.10 linux/amd64

[mathewvp]

Same issue for Server version: 5.1.66-0+squeeze1-log

https://github.com/go-sql-driver/mysql/blob/master/packets.go#L236

returns an empty plugin which causes the warning

[karstenkoehler]

There was another issue on this topic about a month ago. This is already closed, even though I do not think that the discussion has produced any result. There is a separate branch created by @julienschmidt that has solved the problem, at least in my case. Maybe you can try if that branch works for you too.

Go version: go version go1.9.6 linux/amd64
Server version: 5.1.73
Server OS: centos-release-6-9

[mathewvp]

This branch solved it for me. Would it be merged to master?

go version go1.10.2 windows/amd64
Server version: 5.1.66-0+squeeze1-log

[apptut]

I encounter this problem again -_- !。why not merge this fixed to master?

[julienschmidt]

Opened a pull request for that branch: #835

[julienschmidt]

Continue discussion here: #815