As you all know that MySql 8.X will be released soon.
So is Magento 2 compatible with MySql 8?
Magento 2 doesn't support MySQL 8 so far.
The information schema statistics is cached in MySQL 8 so there a lot of issues with auto increments and mview change logs in Magento 2.
Yes Magento 2 is compatible with MySQL 8
However for Magento's latest version MySQL 5.6 can be used (you can also use MySQL 5.6.x) Other compatible database for Magento 2 will be MariaDB 10 and above
Magento Latest version 2.2.3 requirements:
MySQL 5.6, 5.7
Magento is also compatible with MySQL NDB Cluster 7.4.*, MariaDB 10.0, 10.1, 10.2, Percona 5.7, and other binary-compatible MySQL technologies.
Expanding on CedCommerce anwer:
I installed Magento with mysql 8 and it works. The new default caching_sha2_password authentication plugins however introduces a breaking change as detailed in this article:
But you can still use the mysql_native_password authentication plugin with which magento will run. When you create the MySQL user for the Magento database this is the code you have to run:
CREATE USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password BY '<password>';
Or if you have an existing user, change the authentication plugin with this line:
ALTER USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password BY '<password>';