Wrong Database Connection in env(&#39;DATABASE_URL&#39;)

Level 34

@lutkabe check your config/database.php https://github.com/laravel/laravel/blob/8.x/config/database.php#L18

There might be a hardcoded credentials in that file.

1 like

Level 1

Already did. No hardcoded value, just 'url' => env('DATABASE_URL').

rovshena

Level 2

Check your .env file in root of your project.
Check config/database.php

2 likes

Level 1

No specific settings there in the .env and database.php.

Level 75

Un-comment driver in php.ini. Restart server.

Level 1

Checked this before too, the extensions extension=mysqli and extension=pdo_mysql were uncommented.

Level 1

Not sure if this makes a difference or not, I am using Laragon as my dev environment. Thanks!

Level 75

Show the database section from the env file, x out password. Also what is APP_URL set to?

Level 1

Here is the my env database section:

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

and here is the APP_URL: APP_URL=http://localhost

Level 75

Is localhost correct, and is mydb the correct database?

Also can you successfully connect to that database from the command line?

Level 1

Both the localhost and mydb are correct. Using Tinker, I get the following error:

>>> DB::connection()->getPdo();
PDOException with message 'could not find driver'

I checked the PHP extension path and I can see the drivers exist.

Worth mentioning, using Tinker the env('DATABASE_URL') is:

>>> env('DATABASE_URL')
=> "postgres://postgres:[email protected]:5432/"

which confuses me. I do not have an active postgres database at all.

Looks like the DATABASE_URL has been set globally somewhere. Is there any global config that overrides the local config? I even set the DATABASE_URL to a bogus string in my project's .env file, cleared the cache and config, and restarted the server but still see the same postgres connection string above when query it from Tinker!

Thanks for taking time to looking into this!

Level 75

Open database.php in config, comment out postgres whole section, run config:clear again.

Try without tinker.

Level 1

Commented out the postgres whole section in the database.php, ran php artisan config:clear, and then php artisan migrate. It did not work and threw the same exception.

Level 75

Grep the folders looking for a stray Global Connection. Also were you able to connect to mySQL from the command line. Not tinker the actual command line.

Laravel should be picking up the environment variables.

Level 1

Grep returns billion results which I am still looking into them. How do you connect to mysql from the command line?

Level 75

Command line admin: Change to the MySql bin folder:

c:\xampp\mysql\bin>mysql -uroot -pyour_password

Then to test you can:

show databases;

Level 1

Yes, I can connect to the databases using the mysql cmdl. Besides, I have been using HeidiSQL to connect to my local MySQL databases forever.

Level 75

Make sure your APP_URL in .env is correct.

Best Answer

Level 1

I just commented out the 'url' => env('DATABASE_URL') in the database.php and it worked like a charm. Here is my updated 'mysql' config:

        'mysql' => [
            'driver' => 'mysql',
            // 'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
            'engine' => null,
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
            ]) : [],
        ],

Thanks everyone!