Make one installation use another server database (on another loacation)

Hello!

Is there any way to make wordpress use another server/ website database than the one installed for the current installation.

I.E:

WordPress is running on example.com database is currently on that domain as well.

We want the SQL database to load from database-server.domain while the actual installation is on example.com

This while the new users of course also is registered into that database.
(As wordpress uses the database to store all kinds of stuff the content will be loaded from there)

i have tried the following:

define('DB_NAME', 'new_database_name_here');

/** MySQL database username */
define('DB_USER', 'new_username_here');

/** MySQL database password */
define('DB_PASSWORD', 'new_password_here');

/** MySQL hostname */
define('DB_HOST', 'new_server_location');

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

And then copied then copying the salts/ keys etc

When connecting to the site i just get this error: “Error establishing a database connection”

when trying to connect to the “/wp-admin.php” i get: https://prntscr.com/61ozko

Any suggestions/ ideas on how to proceed?

Thanks in advance”