The server requested authentication method unknown to the client MacOs Mojave

I am new to iOS and have been trying to configure the mysql on my machine, i've installed mysql by following this, you can see the server running in below image

now when i run the laravel project by command php artisan server it says

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

I've already searched for the issue on google and have already setup my.cnf as below

[client]

port = 3306
socket = /tmp/mysql.sock


[mysqld]

port = 3306
socket = /tmp/mysql.sock
datadir = /usr/local/mysql-5.7.17-macos10.12-x86_64/data
tmpdir = /tmp
default_authentication_plugin= mysql_native_password

but no progress, then i tried to update my user using this command suggested here

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password
BY 'password'; 

but it says

ERROR 1726 (HY000): Storage engine 'MyISAM' does not support system tables. [mysql.db]

now as i've allot of database which i want to use for my already running project and someone says DO NOT CHANGE THE ENGINE FOR SYSTEM TABLES here i am not sure what to do next to run my Laravel applications on macos.

Please suggest as i've already tried enough and have spent almost 2 days just to configure things on mac.

Thanks in advance. :)

Note: Macos: mojave

via Chebli Mohamed