How to connect concrete5 to a remote database at the initial setup?

Permalink
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

1 Attachment

 
Mnkras replied on at Permalink Reply
Mnkras
This is not an issue with concrete5, please check your mysql server settings and make sure its not blocking the connections.

Mike
asteriskue replied on at Permalink Reply
I am not saying that it is a problem with concrete5. I am telling that I am encountering this problem and may be some guys (like you) may have a solution on this.

Anyway, thanks but no thanks Mike. I will just wait for other person to drop some technical suggestion here.