MySQLCommunityServer can't connect on 64bit

Databases
1

On mac 10.11 and xojo2015r3 and 64bit build can’t connect.
On 32bit same code works.

[code]Dim mDb As New MySQLCommunityServer

mDb.Host = “"
mDb.UserName = "”
mDb.Password = “"
mDb.DatabaseName = "”

If mDb.Connect Then[/code]

Do I have to change something?

Thanks

Jukka

2

Correction, it does not connect in xojo2015r3 with 32bit or 64bit.
But in xojo2015r2.4 and 32bit it works.

Jukka

3

Error message:
“Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled)”

4

Ok, I found solution.
I had to comment out old_passwords=1 from mysql-server and recreate the mysql user.
Seems that old passwords does not work anymore.

5

You should file a bug report in Feedback if you want us to look at it.

6

I can’t see where I would need those old (16byte) passwords, since new (41byte) passwords seem to work everywhere.
It’s just been habit to make it in mysql server config.
But this has defenetly changed from r2.4 -> r3
It might be problem to someone who can’t modify server-settings, if there is no workaround.

7

All new MySQL libraries now use secure_auth by default, and those are what the new 2015r3 plugin use. However, a feature request was filed to be able to toggle this. We are looking into adding that for a future release (specifically for those who cannot update their MySQL user’s password to the current format).