SQLSTATE[HY000] [1045] Access denied for user &#39;root&#39;@&#39;localhost&#39;

Level 102

So the error says you are using wrong username or password?

1 like

Level 8

@Sinnbeck Thanks. But I put correct uesrname & password.

kokoshneta

Level 27

@afoysal Clearly you didn’t, because as you can see in your screenshot, it’s trying to connect WITHOUT a password.

Also, it’s not composer update that’s causing the error (that doesn’t access your Laravel database). It’s Laravel’s ‘discover packages’ script that is set to run after Composer’s update script.

If you don’t need the package discovery script – and often you don’t actually – you can just remove it from your composer.json file.

1 like

Level 8

@kokoshneta Thanks. How can I remove it from composer ? Should I remove it from here ? "scripts": { "post-autoload-dump": [ "Illuminate\\Foundation\\ComposerScripts::postAutoloadDump", "@php artisan package:discover --ansi" ], "post-root-package-install": [ "@php -r \"file_exists('.env') || copy('.env.example', '.env');\"" ], "post-create-project-cmd": [ "@php artisan key:generate --ansi" ] }

kokoshneta

Level 27

@afoysal Yes, exactly. At least, I’ve found that removing , "@php artisan package:discover --ansi" from my Composer file had no ill effects.

1 like

Level 104

Is your config cached?

php artisan cache:clear

1 like

Level 8

@tykus Thanks. I am getting this error. https://i.stack.imgur.com/PqYzl.png

Level 104

@afoysal you are probably making a database call in a ServiceProvider (which calls to your helpers file on line 183) - if you can wrap whatever that code is like this:

if (!app()->runningInConsole()) {
    // make the query
}

then you should be able to clear the incorrect cache

1 like

Level 8

@tykus Thanks. Did you check my screenshot properly ?

Sinnbeck

Level 102

@afoysal As @tykus could point to exactly which file the problem is in, I am pretty sure they did

1 like

Level 8

@Sinnbeck Thanks . But I couldn't find that ServiceProvider. That's why I asked that. Thanks.

Sinnbeck

Level 102

@afoysal Well you can open the helpers file and instead check on line 183. That is doing a database call which is being run on every single request (and cli call)

1 like

Level 8

@Sinnbeck Thanks. But now I am getting another error. https://i.stack.imgur.com/PmTsb.png

Level 104

@afoysal maybe you don't understand the meaning of probably? Anyway, I told you where to look and what to do as mitigation, so good luck with that 👍

1 like

Level 8

@tykus Thanks. But now I am getting another error. https://i.stack.imgur.com/PmTsb.png

kokoshneta

Level 27

@afoysal So look on line 32 in your AppServiceProvider as the error message is telling you to…

1 like