Issues with the php artisan twill:setup

[patrickblackjr]

Copied File [/vendor/area17/twill/migrations/create_tags_tables.php] To [/database/migrations/2018_07_14_205036_create_tags_tables.php]
Copied File [/vendor/area17/twill/migrations/create_blocks_table.php] To [/database/migrations/2018_07_14_205036_create_blocks_table.php]
Copied File [/vendor/area17/twill/migrations/create_users_tables.php] To [/database/migrations/2018_07_14_205036_create_users_tables.php]
Copied File [/vendor/area17/twill/migrations/create_files_tables.php] To [/database/migrations/2018_07_14_205036_create_files_tables.php]
Copied File [/vendor/area17/twill/migrations/create_medias_tables.php] To [/database/migrations/2018_07_14_205036_create_medias_tables.php]
Publishing complete.
Copied File [/vendor/spatie/laravel-activitylog/migrations/create_activity_log_table.php.stub] To [/database/migrations/2018_07_14_205036_create_activity_log_table.php]
Publishing complete.

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

  at /Users/patrickblackjr/code/blog/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
    660|         // If an exception occurs when attempting to run a query, we'll format the error
    661|         // message to include the bindings with SQL, which will make this exception a
    662|         // lot more helpful to the developer instead of just the database's errors.
    663|         catch (Exception $e) {
  > 664|             throw new QueryException(
    665|                 $query, $this->prepareBindings($bindings), $e
    666|             );
    667|         }
    668|

  Exception trace:

  1   PDOException::("PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password]")
      /Users/patrickblackjr/code/blog/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68

  2   PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=blog", "root", "", [])
      /Users/patrickblackjr/code/blog/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68

  Please use the argument -v to see more details.

I tried to run php artisan twill:setup.

[HeshamEG]

php artisan twill:setup make migrations for database .
check your .env file
DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=twill
DB_USERNAME=root
DB_PASSWORD=root
then make sure database/migrations not having same tables name .

[patrickblackjr]

Hey @HeshamEG, thanks for the reply. I will be sure to check this out as soon as I can.

[HeshamEG]

@Mortiferr wish it helps 👍

[ifox]

Hey @Mortiferr, thanks for reporting!

This seems to be related to MySQL v8. There's a Laravel issue here and a PR here that discuss your specific error message.

[patrickblackjr]

@ifox Hm. Good to know. I'll look into it more.