MySQL Handshake Errors

[hujambo]

Hi guys,

Has anyone else experienced handshake errors using the built in MySQL features of 5.7LTS with Windows?

I'm finding that if I connect to a database via XAMP on 127.0.0.1 I get no errors - no handshake errors at all, but when I connect to any other server (with any pc , on any network) I get lots of handshake errors created on the MySQL server.

Unfortunately, so far I haven't been able to narrow anything down - but they are being created with standard select queries.

Thanks for your help

10.3.17-MariaDB - Purebasic 5.7LTS 64bit

[mk-soft]

I am using a MySQL server from my NAS.

I have not noticed any problems with this.
Maybe the user doesn't have the necessary authorization on the database.

[hujambo]

Thanks for the reply mk-soft. I tried setting a user with all rights and it still happens. They are handshake errors, which according to the Maria/MySql docs are at a 'hardware protocol level'. So the queries are working, results back ok and each one finished with finishquery but during the process 7 out of 10 times an error is registered. Once these get too high flush hosts fixes it. I've altered the mysql variables to stop the counter locking the client out, but it isn't a fix.

Certainly odd