Cannot connect to Laravel mysql database

Question

I have problems in connected with laravel to mysql database. I have change the localhost to localhost:8091 because this is the local server name in my wamp server. I have also installed xampp and uniserver which listens to other ports. Is it possible that laravel i confused with the other servers i have installed in my machine? Not only for the url but for the phpmyadmin too, for example.

this is the error

PDOException in Connector.php line 119: could not find driver

This is my .env file

APP_ENV=local
APP_KEY=base64:h0GyUa1VdjV22LXpRiOSOw+9HxXV+Qm0XO2zz9RRz6s=
APP_DEBUG=true
APP_LOG_LEVEL=debug
APP_URL=http://localhost:**8091**

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=test1
DB_USERNAME=root
DB_PASSWORD=

This is my config.php file

  'mysql' => 
  array (
    'driver' => 'mysql',
    'host' => 'localhost',
    'port' => '3306',
    'database' => 'test1',
    'username' => 'root',
    'password' => '',
    'charset' => 'utf8',
    'collation' => 'utf8_unicode_ci',
    'prefix' => '',
    'strict' => true,
    'engine' => NULL,
  ),

This is my database.php file

    'mysql' => [
        'driver' => 'mysql',
        'host' => env('DB_HOST', 'localhost'),
        'port' => env('DB_PORT', '3306'),
        'database' => env('DB_DATABASE', 'test1'),
        'username' => env('DB_USERNAME', 'root'),
        'password' => env('DB_PASSWORD', ''),
        'charset' => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix' => '',
        'strict' => true,
        'engine' => null,
    ],

Solution on last comment of correct answer

stop the local server if youre on something like artisan serve (local php server), do artisan config:clear . serve again and you should be good to go. you also have the password empty (not sure if this is the correct setting or not) — Sari Yono
– Sari Yono, Commented Sep 19, 2016 at 12:12
Can you post your logs please. Based on your description it's difficult to determine what is going wrong. — AHL
– AHL, Commented Sep 19, 2016 at 12:12
@SariYono Hey sari, i did what you said and didn;t work and the password should be empty (i think it should be because its suppose to be on wamp). Has the password something to do with artisan serve? I am really new at this so any info would be very useful — Iraklis
– Iraklis, Commented Sep 19, 2016 at 12:18
Ok so it looks like there is a problem with your DB connector according to the exception. I can't see what's in your Connector.php on line 119 which is what your exception refers to. But you may check this post (stackoverflow.com/questions/9308147/…) and see if it's a simple configuration problem. I.e. use pdo_mysql as driver instead of mysql. — AHL
– AHL, Commented Sep 19, 2016 at 12:25

Tadas Paplauskas · Accepted Answer · 2016-09-19 13:09:21Z

1

You can quickly check if there's a problem with php config. Find your php.ini file, it should be somewhere in xampp folders - do a file search if you have trouble finding it.

Alternatively, you can create a simple file like this:

<?php
phpinfo();

Or do it the laravel way:

Route::get('info', function() { phpinfo(); });

Now call that route through the browser - you will see php configs.

What you're looking is pdo_mysql. See if it is enabled. If it isn't, go to your php.ini file and find the following line:

extension=php_pdo_mysql.dll

Make sure it is uncommented. Restart you servers and you should be good to go.

Also, you do not need to make any changes to database.php or app.php files to connect to the database - changing .env is enough, so remove database connection details from your source files, just leave them as they were initially. Since most of your settings are the same as the defaults, the only parameters that you have to set in .env are:

DB_DATABASE=test1
DB_USERNAME=root

Try these things and let me know if it helps :)

edited Sep 19, 2016 at 13:09

answered Sep 19, 2016 at 13:00

Tadas Paplauskas

1,91312 silver badges16 bronze badges

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

6 Comments

Iraklis Over a year ago

Hey Tadas thanks for the reply. In phpinfo i cannot even see pdo_mysql. But in my php ini the line you told is uncommented. In /env i also changed what needed to be change. Nothing works...

Iraklis Over a year ago

I can only see a PDO section where pdo drivers has 'no value'

Tadas Paplauskas Over a year ago

well here's your problem :). Now we need to figure out how to turn on that PDO driver. It should be as simple as enabling it in php.ini. Notice that comments in ini files begin with semicolon, so make sure that the line in "extension=php_pdo_mysql.dll" in php.ini file has NO semicolon in front of it. Maybe you edited the wrong php.ini file that's left from another instalation or as a backup - do a search for php.ini in files explorer and change that line everywhere. If nothing works, I would encourage you to setup another dev environment, as the one you got is very peculiar.

Iraklis Over a year ago

The problem is that it's ok on my wamp server but not on laravel when i run it with php artisan serve

Tadas Paplauskas Over a year ago

Find the config file that is used by your local php installation and make the mentioned changes. Artisan serve is most probably not using the same PHP setup as wamp. You have probably set up PHP separately from wamp somewhere in your system. If you're on windows, look into Advanced system settings -> environment variables -> Path variable value - there you will find a path to a PHP setup that is used by artisan.

|

Collectives™ on Stack Overflow

Cannot connect to Laravel mysql database

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related