"Access denied for user ''@'localhost' to database 'forge" appears randomly

Question

I have a search function for my database but sometimes I get this message:

[2016-02-04 07:03:18] local.ERROR: PDOException: SQLSTATE[HY000] [1044] Access denied for user ''@'localhost' to database 'forge' in C:\xampp\htdocs\reko\api\vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php:55
Stack trace:
#0 C:\xampp\htdocs\reko\api\vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php(55): PDO->__construct('mysql:host=loca...', 'forge', '', Array)
...

In one of ten calls I get this 500 error message, but I don't know why. The other calls give the right result.

.env

APP_ENV=local
APP_DEBUG=true
APP_KEY=bJM6O0MnrIPaTNwKKOqNJkGinRDv1fnc

DB_HOST=localhost
DB_DATABASE=reko
DB_USERNAME=root
DB_PASSWORD=

CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=sync

Search function:

public function search(Modul $modul, Request $request)
{
    $question = Question::whereModulId($modul->id)
        ->where('value', 'LIKE', '%' . $request->get('keywords') . '%')
        ->with('tags')
        ->whereHas('exams', function ($query) use ($request) {
            $query->where('date', '>=', $request->get('year').'-01-01');
        });
    if (!$request->get('parent'))
        $question->where('type', '<>', 'parent');
    if (!$request->get('own'))
        $question->where('type', '<>', 'own');
    if (!$request->get('normal'))
        $question->where('type', '<>', 'normal');
    if ($request->get('answered'))
        $question->has('answers');
    return $question->paginate(10);
}

database.php

'mysql' => [
        'driver'    => 'mysql',
        'host'      => env('DB_HOST', 'localhost'),
        'database'  => env('DB_DATABASE', 'forge'),
        'username'  => env('DB_USERNAME', 'forge'),
        'password'  => env('DB_PASSWORD', ''),
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => false,
    ],

I haven't modified the database.php file and all other calls work great.

I have never used it, the user doesn't even exists. There is nothing written in my code — cre8
– cre8, Commented Feb 3, 2016 at 21:18
Check your database's logs for errors. The fact that its inconsistently failing means it's probably the database's fault, not PHP's. — Mr. Llama
– Mr. Llama, Commented Feb 3, 2016 at 21:20
I think I found the error. The forge user is the default value of laravel in the database.php. So it can happen that laravel forgets to load the .env file and uses this wrong user. I updated the file and now it seems to work. — cre8
– cre8, Commented Feb 3, 2016 at 21:22
I believe this is a common problem. You may want to cache your config files by running php artisan config:cache, but it is recommended you do this in production mode only since you're likely to change your environment variables often during development. — Thomas Kim
– Thomas Kim, Commented Feb 3, 2016 at 21:30
It's funny cuz this happens once every so often for me... I'm only developing in local windows environment with .env file. But why does laravel not load the env file sometimes? — Thomas Cheng
– Thomas Cheng, Commented Sep 28, 2016 at 5:52

thisiskelvin · Accepted Answer · 2020-02-27 12:33:59Z

4

PLEASE RUN THIS COMMAND

php artisan cache:clear

THEN

php artisan config:cache

edited Feb 27, 2020 at 12:33

thisiskelvin

4,2021 gold badge12 silver badges18 bronze badges

answered Oct 13, 2019 at 4:01

VIKAS KATARIYA

6,0153 gold badges19 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:00:29Z

2

This seems to hold most of the answers : Laravel 5.2 not reading env file

Remember to not to edit your core files as one of the users said. Just do the safe checks, clear cache, should work.

Hope it helps.

As a workaround you can add to your DB forge account with all privileges.

edited May 23, 2017 at 12:00

CommunityBot

11 silver badge

answered Mar 23, 2017 at 13:53

dExIT

2222 silver badges13 bronze badges

Comments

anan karki · Accepted Answer · 2017-12-01 04:25:40Z

1

Try php artisan clear:cache to clear your cache and re-configure your cache php artisan config:cache it might works for you .

answered Dec 1, 2017 at 4:25

anan karki

194 bronze badges

Comments

Arsii Rasheed · Accepted Answer · 2019-10-24 20:02:52Z

0

I had the same issue once. what I discovered was that my default connection was set to PostgreSQL instead of MySQL so I changed my default connection in database.php

'default' => env('DB_CONNECTION', 'mysql'),

other wise do add following to your .env

DB_CONNECTION=mysql

answered Oct 24, 2019 at 20:02

Arsii Rasheed

3612 gold badges5 silver badges18 bronze badges

Comments

Clint · Accepted Answer · 2020-01-09 02:48:46Z

0

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=homestead
DB_USERNAME=root
DB_PASSWORD=

try adding remaining methods in your .env file

edited Jan 9, 2020 at 2:48

Clint

2,79326 silver badges44 bronze badges

answered Jan 9, 2020 at 0:33

rohit prasain

293 bronze badges

Comments

2 revs · Accepted Answer · 2021-05-21 06:10:07Z

0

Too often we have to face this error when hosting.

You should see that you have given Privileged Users permission to the database in the hosting.

First

First I need to see if the database name is correct.

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=zhara_demo
DB_USERNAME=zhara_admin
DB_PASSWORD=zhara@2021

or

Try php artisan clear:cache to clear your cache and re-configure
your cache php artisan config:cache it might works for you .

edited May 21, 2021 at 6:10

community wiki

2 revs
ᴄᴏᴅᴇ ᴋɪʟʟᴇʀ ᴢʜᴀʀᴀ

Collectives™ on Stack Overflow

"Access denied for user ''@'localhost' to database 'forge" appears randomly

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related