[caching_sha2_password] error when running php artisan migrate

Posted 1 year ago by nickdavies07

Having an issue, hopefully someone can help as I'm tearing my hair out with this one.

Running the command php artisan migrate in terminal throws the following error:

   Illuminate\Database\QueryException  : SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')

  at /Users/nickdavies07/Sites/office-365-portal/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/nickdavies07/Sites/office-365-portal/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68

  2   PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=office_365_portal", "root", "mypassword", [])
      /Users/nickdavies07/Sites/office-365-portal/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68

  Please use the argument -v to see more details.
nickdavies07 ? (master) 

I have brew installed php 7.2, MySQL 8.0.11 and am running Valet.

Tried resetting the root password which didn't make a difference.

Please sign in or create an account to participate in this conversation.

Reply to

Use Markdown with GitHub-flavored code blocks.