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"?

 

[wolstech]

You should be using johnny.heliohost.org as the database server hostname.

Also, the error you're getting makes me think you have the DB settings wrong somewhere else in your code, as it's mentioning  'lsvcam_webcamLSVdbUser'@'www640.your-server.de' If this were set up correctly on your end, that bold part should be showing johnny.heliohost.org.