Hello @piersert,
Yes, WooCommerce will works fine if mysql 5.7. After install WooCommerce plugin, you can get system reports and check.
For check System report, Go to WooCommerce > System Status
Please let me know if you need more help..:)
Thanks,
is mysql 5.7 the best version or newer version are better?
It’s fine mysql 5.7 version.
You can know by below url:
https://docs.woocommerce.com/document/server-requirements/
Thanks,
Newer versions are typically going to be better, just like PHP 7 is better than PHP 5.6.
Though for mysql, it’s a bit less of a difference. 5.6 or 5.7 will both work fine.