problems with database connection in laravel 5

laravel-5 laravel-artisan artisan-migrate
Gaetan Sobze picture Gaetan Sobze · Feb 8, 2015 · Viewed 23.5k times · Source

I use the command php artisan migrate to migrate my database connection but I still get the same error and I checked everything, nothing wrong. I used the same connection that I always use in Laravel 4.2

Here is the message I get on my console:

exception 'PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user 'homestead'@'localhost' (using password: YES)' in C:\xampp\htdocs\Projects\blog\vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php:47

Answer

baao picture baao · Feb 8, 2015

You need to change the values in your .env file, located in the root folder of your project.

If there is no .env file, copy the .env.example file to .env.

Laravel uses this file to protect your passwords. The values as you are setting those are only used if there is no configuration available in the .env file, homestead is the standard user there.

Related questions

Laravel migration (errno: 150 "Foreign key constraint is incorrectly formed")

I have an orders table and a have a sell_shipping_labels which references orders.id as a foreign. However when I run the Laravel migration I get the dreaded error code: [Illuminate\Database\QueryException] SQLSTATE[HY000]: General error: 1005 Can't …

Read More
php artisan migrate:make create_mytable fails: "migrate:make" is not defined

When running the following command at the root of my Laravel 5 application, php artisan migrate:make create_mytable I get the following error: [InvalidArgumentException] Command "migrate:make" is not defined. Did you mean one of these? migrate:reset migrate:refresh …

Read More
Call to undefined method Illuminate\Database\Schema\MySqlBuilder::defaultStringLength()

Firstly i was getting an error in php artisan migrate as SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes and Then i found a post on laracasts to fix this as use …

Read More