Problemas com migrate
[Finalizado Pelo Aluno]
Illuminate\Database\QueryException : SQLSTATE[HY000] [2054] The server requested authentication method unk
nown to the client (SQL: select * from information_schema.tables where table_schema = food and table_name = mi
grations and table_type = 'BASE TABLE')
Exception trace:
1 PDOException::("PDO::__construct(): The server requested authentication method unknown to the client [ca
ching_sha2_password]")
/home/otavio/laravel/food/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70
2 PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=food", "root", "root", [])
/home/otavio/laravel/food/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70
Please use the argument -v to see more details.
Resolvi o problema. tentei com HOST=mysql e com HOST=localhost, rodou com HOST=127.0.0.1 no .env
hhjhjk
Bom dia!
Quando uso o comando php artisan migrate obtenho essa resposta!!
Illuminate\Database\QueryException : SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (SQL: create table `users` (`id` bigint unsigned not null auto_increment primary key, `name` varchar(255) not null, `email` varchar(255) not null, `email_verified_at` timestamp null, `password` varchar(255) not null, `remember_token` varchar(100) null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')
at C:\xampp\htdocs\csfood\vendor\laravel\framework\src\Illuminate\Database\Connection.php:669
665| // If an exception occurs when attempting to run a query, we'll format the error
666| // message to include the bindings with SQL, which will make this exception a
667| // lot more helpful to the developer instead of just the database's errors.
668| catch (Exception $e) {
> 669| throw new QueryException(
670| $query, $this->prepareBindings($bindings), $e
671| );
672| }
673|
Exception trace:
1 PDOException::("SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists")
C:\xampp\htdocs\csfood\vendor\laravel\framework\src\Illuminate\Database\Connection.php:463
2 PDOStatement::execute()
C:\xampp\htdocs\csfood\vendor\laravel\framework\src\Illuminate\Database\Connection.php:463
Please use the argument -v to see more details.
Olá, Joubert!
Tudo bem?
Cria uma nova thread (ticket) para discutirmos a sua dúvida.
No aguardo.
Precisa estar logado para conseguir responder a este ticket!
Clique Aqui Para Entrar!