Web

mysql setup:

CREATE USER drupalDBuser@localhost
alter user 'drupalDBuser'@'localhost' identified with mysql_native_password by 'password'

need  mysql_native_password  plugin because php didn't know new mysql_native_password method.

drupal 8: see refer page here. need manually modify the source code.