I have no issues setting up the database on a localhost basis but what I wanted to do (and had been doing) in production was to put the databases in one server.

How do I tell concrete5 that the database is located at 192.168.10.1 and NOT at the localhost?

My workaround:
I made a workaround by setting it up using its localhost database (it went well) then after I change the site.php file and point DB-Server to 192.168.10.1 - save site.php, restart apache but it failed to connect with the database.

see attached image.

These databases have the same details except of its location:
1 - localhost and other 1 is in 192.168.10.1

How do i resolve this? during the setup / installation of concrete5 and post installation / setup? (ie: moving of database from host1 to host2)

Thanks, Aste