Alejandro Recalde

[FEATURE REQUEST] Show mysql warnings from insert statements or at least from insert ignore statements (myloader)

2

**Describe the Feature Request** It would be great if myloader logs mysql warnings from insert statements or at least when using insert ignore (`-N, --insert-ignore` mydumper option) **Current behaviour** myloader...

Fix/Grant update failed: not allowed to create a user with grant

2

### Description of your changes Fixes #127 I have: - [x] Read and followed Crossplane's [contribution process]. - [x] Run `make reviewable` to ensure this PR is ready for review....

[mysql] FLUSH PRIVILEGES is only required after making manual edits to tables such as mysql.user, not after CREATE, ALTER or DROP USER

4

### What problem are you facing? Why every time a `CREATE`, `ALTER` or `DROP USER` statement is executed, `FLUSH PRIVILEGES` is called after? It's also present after `GRANT` and `REVOKE`...

(Grant Error) update failed: Error 1410: You are not allowed to create a user with GRANT

3

### What happened? When creating or updating a grant sql provider always try to grant it for ``@`%`, instead of ``@``. Which results in an `Error 1410: You are not...

Feat/support authentication plugins like ldap simple

5

### Description of your changes Fixes [#125](https://github.com/crossplane-contrib/provider-sql/issues/125) I have: - [x] Read and followed Crossplane's [contribution process]. - [x] Run `make reviewable` to ensure this PR is ready for review....

### What problem are you facing? I would like to create mysql (v8.0+) users identified by ldap ([authentication_ldap_simple](https://dev.mysql.com/doc/refman/8.0/en/ldap-pluggable-authentication.html)) instead of by password ([mysql_native_password](https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html)). Also it would be great if authenticating...