Is it possible to set the default value of "allowNativePasswords" to "true"?

[bingosummer]

Issue description

The default value of allowNativePasswords should be true. But it's false by default. Using other language's mysql driver, the connection is established without the option allowNativePasswords, when the mysql server requires native password authentication.
So is it possible to set the default value to true?

Example code

package main

import (
        "database/sql"
        "log"
         _ "github.com/go-sql-driver/mysql"
)

func main() {
        db, err := sql.Open("mysql", "<username>:<password>@tcp(host:port)/database_name")
        if err != nil {
                log.Fatal(err)
        }
        defer db.Close()

        err = db.Ping()
        if err != nil {
                log.Fatal(err)
        }
}

Error log

2017/08/01 08:32:44 this user requires mysql native password authentication.

Configuration

Driver version (or git SHA): 1.3

Go version: go version go1.8 linux/amd64

Server version: MySQL 5.7

Server OS: N/A

[elemount]

I see allowOldPasswords and allowClearPasswords, that is needed because those password method is not secure and need to set false. But native password is the default options. Why the native password should be set false by this options?

[elemount]

@bingosummer , Could you help to close it? The code is merged.

[julienschmidt]

I can help 😉

[bingosummer]

Thank everyone for this change. @elemount @julienschmidt @twocode