WARNING: mysqli_connect(): (HY000/3159): Disallowing connections using insecure transport when --require_secure

For a project, I'm trying to make an application where users can enter their values, but when I test it on localhost I keep getting this error: warning: mysqli_connect(): (HY000/ 3159): Disable transmission when using an insecure connection --require_secure_transport=ON. This is my php code:

$bedrijfsnaam = $_POST['bedrijfsnaam']; $dag = $_POST['dag']; $caption = $_POST['caption']; var_dump($bedrijfsnaam, $dag, $caption); $dbh = mysqli_connect(hostname: $host, username: $username, password: $password, database: $dbname); if (mysqli_connect_errno()) { die("Connection error: " . mysqli_connect_errno()); } $sql = "INSERT INTO file_upload (bedrijfsnaam, dag, caption) VALUES (?, ?, ?)"; $stmt = mysqli_stmt_init($conn);

Is there a secure way to fix this error since the project must be released and from what I understand it is not safe to turn off secure_transport.

I tried using another external database, which resulted in another error, the connection was actively refused. This code does work because I tried running it on localhost and it does work

$mysqli = mysqli_init(); if (!$mysqli) { die('mysqli_init failed'); } $mysqli->ssl_set( '/path/to/client-key.pem', '/path/to/client-cert.pem', '/path/to/ca-cert.pem', NULL, NULL ); //any paths here will work if (!$mysqli->options(MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT = 0')) { die('Setting MYSQLI_INIT_COMMAND failed'); } if (!$mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 5)) { die('Setting MYSQLI_OPT_CONNECT_TIMEOUT failed'); }