[FIX]Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = enrolmentsystem and table_name = migrations and table_type = 'BASE TABLE')

Illuminate\Database\QueryException 

  SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = enrolmentsystem and table_name = migrations and table_type = 'BASE TABLE')

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:678

    674▕         // If an exception occurs when attempting to run a query, we'll format the error

    675▕         // message to include the bindings with SQL, which will make this exception a

    676▕         // lot more helpful to the developer instead of just the database's errors.

    677▕         catch (Exception $e) {

  ➜ 678▕             throw new QueryException(

    679▕                 $query, $this->prepareBindings($bindings), $e

    680▕             );

    681▕         }

    682▕ 

      +33 vendor frames 

  34  artisan:37

      Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

@mohammed, this is usually attributed to the authentication plugin that your mysql database is using. 

By default and for some reason, mysql 8 default plugin is auth_socket. Applications will most times expect to log in to your database using a password. 

If you have not yet already changed your mysql default authentication plugin, you can do so by:
1. Log in as root to mysql
2. Run this sql command: 

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

Replace 'password' with your root password. In case your application does not log in to your database with the root user, replace the 'root' user in the above command with the user that your application uses.