问题:
I tried to run: php artisan migrate
Also to connect to MySQL using Xampp on Windows.
I Got this error:
IlluminateDatabaseQueryException : SQLSTATE[HY000] [1044]...
可以将文章内容翻译成中文,广告屏蔽插件会导致该功能失效:
问题:
I tried to run: php artisan migrate
Also to connect to MySQL using Xampp on Windows.
I Got this error:
IlluminateDatabaseQueryException : SQLSTATE[HY000] [1044] Access denied for user ''@'localhost' to database 'homestead' (SQL: select * from information_schema.tables where table_schema = homestead and table_name = migrations)
at C:UsersharshLaravel1vendorlaravelframeworksrcIlluminateDatabaseConnection.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::("SQLSTATE[HY000] [1044] Access denied for user ''@'localhost' to database 'homestead'") C:UsersharshLaravel1vendorlaravelframeworksrcIlluminateDatabaseConnectorsConnector.php:70
2
PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=homestead", "homestead", "", []) C:UsersharshLaravel1vendorlaravelframeworksrcIlluminateDatabaseConnectorsConnector.php:70
Please use the argument -v to see more details.
.env file:
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=homestead
DB_USERNAME=homestead
DB_PASSWORD=
回答1:
Open the .env
file and edit it. Just set up correct DB credentials:
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE= // Your Database Name
DB_USERNAME= // Yout Database Username
DB_PASSWORD= // Your Database Password
The DB_USERNAME
should be set to root
if you do not have a default username in the installation of MySQL in xampp.
If no password is set on the database, clear it DB_PASSWORD
, empty space must also be removed(In the past I've also faceout this problem, window consider blank space as a password)
After completion of .env
edit please enter this command in your terminal for clear cache:
php artisan config:cache
回答2:
Hi go to xampp phpmyadmin create a database for exemple stack and change your .env to this:
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=stack
DB_USERNAME=root
DB_PASSWORD=
by default phpmyadmin username is root and without password save and try php artisan migrate
回答3:
You should try this:
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=your database name
DB_USERNAME= your localhost-database username (i.e `root`)
DB_PASSWORD= your localhost-database password (i.e `root`)
then you run below command
php artisan config:cache
php artisan cache:clear
php artisan migrate