2
respostas

Problemas no Migrations

Estou com um problema que aparece quando executo o:

php artisan migrate

Aparece a seguinte mensagem :

  Illuminate\Database\QueryException

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

  at C:\Users\Pedro\Desktop\Projetos\sistema_oficina\vendor\laravel\framework\src\Illuminate\Database\Connection.php:671
    667|         // If an exception occurs when attempting to run a query, we'll format the error
    668|         // message to include the bindings with SQL, which will make this exception a
    669|         // lot more helpful to the developer instead of just the database's errors.
    670|         catch (Exception $e) {
  > 671|             throw new QueryException(
    672|                 $query, $this->prepareBindings($bindings), $e
    673|             );
    674|         }
    675|

  1   C:\Users\Pedro\Desktop\Projetos\sistema_oficina\vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php:70
      PDOException::("PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password]")

  2   C:\Users\Pedro\Desktop\Projetos\sistema_oficina\vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php:70
      PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=teste", "root", "", [])

Alguém será que sabe?

2 respostas

Olá Pedro,

Confere se essa resposta do Otávio te ajuda:

https://cursos.alura.com.br/forum/topico-sqlstate-hy000-2054-the-server-requested-authentication-method-unknown-to-the-client-sql-select-from-produtos-81693

Qualquer dúvida é só falar!

Conseguiu resolver, Pedro? :-)