Wednesday, April 4, 2018

laravel 5.2 import a project and QLSTATE[HY000] [2002] or SQLSTATE[42S02]


php artisan clear-compiled [PDOException]  SQLSTATE[HY000] [2002] No such file or directory  
change .env  to: 

DB_HOST=localhost
DB_DATABASE=jos_db
DB_USERNAME=root
DB_PASSWORD=root
DB_SOCKET=/Applications/MAMP/tmp/mysql/mysql.sock

and config/database.php




'mysql' => [ 
'driver' => 
'mysql', 'host' => 
env('DB_HOST', 'localhost'), 'database' => 
env('DB_DATABASE', 'db'), 'username' => 
env('DB_USERNAME', 'root'), 'password' => 
env('DB_PASSWORD', 'root'), 'unix_socket' => 
env('DB_SOCKET', ''), 'charset' => 
'utf8', 'collation' => 
'utf8_unicode_ci', 'prefix' => 
'', 'strict' => false, 'engine' => 
'InnoDB', 'options' => env('DB_COMPRESS', false) ? [\PDO::MYSQL_ATTR_COMPRESS => true] : [],],



php artisan clear-compiled  [Illuminate\Database\QueryException] SQLSTATE[42S02]: Base table or view not found: 1146 Table 
import exist database to mysql server

No comments: