mysql5.7 unknown auth plugin

[gocuntian]

Issue description

Tell us what should happen and what happens instead
mysql5.7 unknown auth plugin

Example code

// version go1.10.2 darwin/amd64
db, err := sql.Open("mysql", "admin:admin@tcp(127.0.0.1:9696)/test")
	if err != nil {
		fmt.Println("failed to open database:", err.Error())
		return
	}
	defer db.Close()

	rows, err := db.Query("SELECT id,str FROM test_shard_hash")
	if err != nil {
		fmt.Println("fetech data failed:", err.Error())
		return
	}
	defer rows.Close()
	for rows.Next() {
		var id int
		var str string
		rows.Scan(&id, &str)
		fmt.Println("uid:", id, "name:", str)
	}

Error log

[mysql] 2018/06/06 22:15:07 auth.go:293: unknown auth plugin:
[mysql] 2018/06/06 22:15:07 driver.go:120: could not use requested auth plugin '': this authentication plugin is not supported

Configuration

• Driver version (or git SHA): origin/master

• Go version:go1.10.2 darwin/amd64

• Server version:MySQL 5.7

• Server OS: macOS 10.13.4 (17E202)

[julienschmidt]

The following section is also for a good reason in the issue template:

### Configuration
*Driver version (or git SHA):*

*Go version:* run `go version` in your console

*Server version:* E.g. MySQL 5.6, MariaDB 10.0.20

*Server OS:* E.g. Debian 8.1 (Jessie), Windows 10

[julienschmidt]

My guess is that your master branch is not the latest version. Please check the specific version with git rev-parse HEAD and sync and try again with the newer version if necessary.

[xinzongyan]

hello,I also have this problem. Do you have resolved?

[gocuntian]

no

[julienschmidt]

Does this branch fix the issue for you? https://github.com/go-sql-driver/mysql/tree/empty_auth

[julienschmidt]

In any case, it would be great if you could insert a simple print(data) after this block

mysql/packets.go

Lines 157 to 167 in d523deb

	func (mc *mysqlConn) readHandshakePacket() ([]byte, string, error) {
	data, err := mc.readPacket()
	if err != nil {
	// for init we can rewrite this to ErrBadConn for sql.Driver to retry, since
	// in connection initialization we don't risk retrying non-idempotent actions.
	if err == ErrInvalidConn {
	return nil, "", driver.ErrBadConn
	}
	return nil, "", err
	}

and here

mysql/packets.go

Lines 469 to 474 in d523deb

	func (mc *mysqlConn) readAuthResult() ([]byte, string, error) {
	data, err := mc.readPacket()
	if err != nil {
	return nil, "", err
	}

and send us the resulting packet dump so that we can use it to create a regression test.

[julienschmidt]

@gocuntian did you resolve the problem?

[Sharethings]

I have the same question, my question is my server send the init packet without the way of auth
accroding source code:
auth.go:240, in func auth(), add the code:
if plugin == "" {
plugin = "mysql_native_password"
}
my problem have been solved

[alpicola]

I got the same warning when connecting to MySQL 5.1.

auth.go:293: unknown auth plugin:
driver.go:120: could not use requested auth plugin '': this authentication plugin is not supported

The branch https://github.com/go-sql-driver/mysql/tree/empty_auth fixed it. Do you have a plan to merge the branch? @julienschmidt

[mbertschler]

I have the same problem.
driver.go:113: could not use requested auth plugin 'mysql_native_password': this user requires mysql native password authentication.
Fails on master (go get)
Fails with v1.4.0
Works with v1.3.0

I could provide more info if you need it. Or do you think that is another problem and I should create a new issue?