Monitoring MySQL 8 / mysql_native_password being deprecated

You can try to use external monitor as workaround:

1. extract mysql 8 tar package in F5 (using the linux cli), preferably in /var/tmp folder.
Do this in both active and standby node.
In mysql.com download, select "linux generic" to get the tar package options.

2. in f5 web gui (local traffic >>> monitor), create external LTM monitor containing script executing proper mysql command:
#!/bin/sh
/var/tmp/..../mysql .....

3. assign the external monitor to the pool