Laravel MySQL database setup error

Question

I want to use a MySQL database with my Laravel 5.2 framework. I'm not able to access phpMyAdmin after I run php artisan serve and open a localhost page.

My .env file :

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_DATABASE=people
DB_USERNAME=pftest
DB_PASSWORD="pftest_2016#9"

After doing this, I ran php artisan migrate and got the following error:

[PDOException] could not find driver

Following which, I have installed the php-mysql extension and checked for its presence in php.ini file. But I'm still getting the following error :

[PDOException]  SQLSTATE[HY000] [2002] Connection refused

So what is the issue and how to solve it?

Run php --ini from the command line and make sure it is using the same .ini file you think it is using. — Pitchinnate
– Pitchinnate, Commented Jun 7, 2016 at 15:44
@kirangadhvi its not same.. read the error.. my error is : [PDOException] SQLSTATE[HY000] [2002] Connection refused — s_user
– s_user, Commented Jun 8, 2016 at 4:08
@Pitchinnate After I ran php --ini , I found the configuration file pointing at this place: /etc/php/7.0/cli/php.ini. Where is it suppose to point ?? how to know which path its suppose to point ?? — s_user
– s_user, Commented Jun 8, 2016 at 4:17
@s_user hey please check this link and check answer i think that's what you looking for. stackoverflow.com/questions/25329302/… — kiran gadhvi
– kiran gadhvi, Commented Jun 8, 2016 at 5:18

Paul-Beyond · Accepted Answer · 2017-06-05 17:24:45Z

2

In the .env file, set

APP_ENV=local
DB_PORT=3306

and then run php artisian migrate --env="local"

Same is valid for dev,production env.

edited Jun 5, 2017 at 17:24

Paul-Beyond

1,7671 gold badge14 silver badges31 bronze badges

answered Jun 8, 2016 at 9:27

s_user

6442 gold badges9 silver badges19 bronze badges

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

1 Comment

Ravikumar Yadav Over a year ago

artisian shoud be renamed to 'artisan'

Collectives™ on Stack Overflow

Laravel MySQL database setup error

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related