Data Migration error. Settings

[soonerdm]

Migrating from 1.9.0.1 on shared hosting to a private hosting Magento 2 version 2.1 development instance with PHP 7, MariaDB I get this error:

[Zend_Db_Adapter_Exception]
SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

[PDOException]
SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

[PDOException]
PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password]

A little research shows to downgrade my PHP? Surely there's a better way? 

[soonerdm]

In case anyone else runs into these error messages all I did was change the password on the Magento 1 mysql connection to a longer password and it worked.  

[sivashchenko]

Experienced the same issue.

Fixed by adding to my.cnf.

[mysqld]
default_authentication_plugin=mysql_native_password

And creating a user like:

CREATE USER 'magento'@'%' IDENTIFIED WITH mysql_native_password BY 'password';