SOLUTION: FOR DIGITALOCEAN USERS: SET PRIMARY KEY REQUIRED TO OFF VIA THE API

PATCH A COMMAND TO THE FOLLOWING:

{
 "config": {
 "sql_mode": "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES",
 "sql_require_primary_key": false
 }
}

UPDATE! CONNECTED TO DATABASE: ITS RECEIVING AND SENDING CALLS. THIS IS THE FULL ERROR:


root@LARAVEL9-MAIN-FRAMEWORK:/var/www/html# php artisan migrate:fresh --seed
Dropped all tables successfully.
Migration table created successfully.
Migrating: 2014_10_12_000000_create_users_table
Migrated: 2014_10_12_000000_create_users_table (12.45ms)
Migrating: 2014_10_12_100000_create_password_resets_table

Illuminate\Database\QueryException

SQLSTATE[HY000]: General error: 3750 Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting. (SQL: create table `password_resets` (`email` varchar(255) not null, `token` varchar(255) not null, `created_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC)

at vendor/laravel/framework/src/Illuminate/Database/Connection.php:716
712â–• // If an exception occurs when attempting to run a query, we'll format the error
713â–• // message to include the bindings with SQL, which will make this exception a
714â–• // lot more helpful to the developer instead of just the database's errors.
715â–• catch (Exception $e) {
➜ 716▕ throw new QueryException(
717â–• $query, $this->prepareBindings($bindings), $e
718â–• );
719â–• }
720â–• }

+9 vendor frames
10 database/migrations/2014_10_12_100000_create_password_resets_table.php:20
Illuminate\Support\Facades\Facade::__callStatic()

+33 vendor frames
44 artisan:37
Illuminate\Foundation\Console\Kernel::handle()

Hi,

If I remember correctly DigitalOcean uses self-signed certificates and require SSL to connect to their database servers.

This might be helpful: https://stackoverflow.com/questions/53061182/mysql-connection-over-ssl-with-laravel

Kind regards,
Jaden

Yes I have. Its a digital ocean database. Still cannot connect. It says it requires ssl connection

Hi Kenneth,

Are there any more detailed errors?

Have you filled in the database details in the .env file?

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