5 months ago

php artisan migrate ERROR for sqlite connection

Posted 5 months ago by Joycey

i am working on laravel on my local system for the first time and followed the step by step instructions but I am getting errors at this point.

This is my .env file: DB_CONNECTION=sqlite DB_HOST= DB_PORT=3306 DB_DATABASE=database/database.sqlite DB_USERNAME=homestead DB_PASSWORD=secret

This is my database.php: 'default' => env('DB_CONNECTION', 'sqlite')),

    'sqlite' => [
        'driver' => 'sqlite',
        'url' => env('DATABASE_URL'),
       'database' => env('DB_DATABASE', database_path('database/database.sqlite')),
        'prefix' => '',
        'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true),

I have created my database/database.sqlite file.

I have ran: php artisan make:auth

Now, I am running php artisan migrate and keep getting the error below:

Illuminate\Database\QueryException : SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. (SQL: select * from information_schema.tables where table_schema = homestead and table_name = migrations and table_type = 'BASE TABLE')

at C:\wamp64\www\laravel_bum\student_bum\vendor\laravel\framework\src\Illuminate\Database\Connection.php:664 660| // If an exception occurs when attempting to run a query, we'll format the error 661| // message to include the bindings with SQL, which will make this exception a 662| // lot more helpful to the developer instead of just the database's errors. 663| catch (Exception $e) {

664| throw new QueryException( 665| $query, $this->prepareBindings($bindings), $e 666| ); 667| } 668|

Exception trace:

1 PDOException::("SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. ") C:\wamp64\www\laravel_bum\student_bum\vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php:70

2 PDO::__construct("mysql:host=;port=3306;dbname=homestead", "homestead", "secret", []) C:\wamp64\www\laravel_bum\student_bum\vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php:70

Please use the argument -v to see more details. _________________________________________________________--

Can you please assist on how to fix this error?

Please sign in or create an account to participate in this conversation.