Enable mysql remote access

[lsvcam]

Hi,

please allow remote access for my mysql-database (again). 

lsvcam.heliohost.us
Database: lsvcam_webcamData
User: lsvcam_webcamLSVdbUser

Thanks a lot in advance.

 

[wolstech]

For mysql, you actually do it yourself. In plesk, edit the database user, and there's an option for remote access at the bottom below the permissions section.

[lsvcam]

Thanks, I already set this option to "Allow remote connections from any host" and also tried "Allow remote connections from". Both did not work.

I still get the error message:

Quote

Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'lsvcam_webcamLSVdbUser'@'www640.your-server.de' (using password: YES

Code:

$conn = new mysqli(
    "lsvcam.heliohost.us", 
    "lsvcam_webcamLSVdbUser",
    "xxxxxx", 
    "lsvcam_webcamData"
);

if ($conn->connect_error) {
    die("❌ Verbindung fehlgeschlagen: " . $conn->connect_error);
} else {
    echo "✅ Verbindung erfolgreich hergestellt!<br>";
}v

 

In Plesk, my Database server is:

Database server 

localhost:3306 (default for MariaDB, v10.5.27)

 

Can I change that to "lsvcam.heliohost.us"?