SQLSTATE HY000 1045 Access denied for user root localhost using password YES symfony2

Question

When I try to login I get an error   SQLSTATE HY000   1045  Access denied for user  root   localhost   using password  YES   parametrs yml   This file is auto-generated during the composer install  parameters      database driver  pdo mysql     database host  localhost     database port  null     database name  sgce     database user  root     database password  mikem     mailer transport  smtp     mailer host  127 0 0 1     mailer user  null     mailer password  null     locale  en     secret  ThisTokenIsNotSoSecretChangeIt   My OS is Debian  Thanks for your help    mysqld safe  socket         var run mysqld mysqld sock nice          0   mysqld        Basic Settings    skip-grant-tables user          mysql pid-file       var run mysqld mysqld pid socket         var run mysqld mysqld sock port          3306 basedir        usr datadir        var lib mysql tmpdir         tmp lc-messages-dir    usr share mysql skip-external-locking     Instead of skip-networking the default is now to listen only on   localhost which is more compatible and is not less secure   bind-address         127 0 0 1 bind-address          10 1 4 3

User · Accepted Answer

This is due to your mysql configuration  According to this error you are trying to connect with the user  root  to the database host  localhost  on a database namend  sgce  without being granted access rights   Presuming you did not configure your mysql instance  Log in as root user and to the folloing   CREATE DATABASE sgce   CREATE USER  root   localhost  IDENTIFIED BY  mikem   GRANT ALL PRIVILEGES ON sgce    TO  root   localhost   FLUSH PRIVILEGES    Also add your database port in the parameters yml  By default mysql listens on 3306   database port  3306

User · Answer

I m Using Xampp and Laravel 5 8 in Windows 10  and i ve been like this before  When i got this problem  My XAMPP is no have Password Then I tried to delete some codes in  config gt database php   password    gt  env  DB PASSWORD          And in  env  DB PASSWORD SECRET   the Problem is solved

User · Answer

Countercheck if boostrap cache config php database details are correct  That should give you an hint if they are   If they are not  then you need to clear the cache using the following steps     rm -fr bootstrap cache   php artisan optimize

User · Answer

default    gt  env  DB CONNECTION    mysql      add this in your code

User · Answer

database password  password would between quotes    or      like so   database password   password

User · Answer

write direct password into config gt database php   password     gt  env  DB PASSWORD        Change to   password     gt    your password

[php] SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) symfony2

Examples related to php

Examples related to mysql

Examples related to symfony