[Question]Let server connect to an other database.

[Lolkereltje]

I have my own website where the database is not running on my computer. But I want to put a AdminCP or ROseCMS on it. But if I want to let the servers connect to that database, it can't connect. Is it even possible?

Thanks,

Lolkereltje

 

[Lolkereltje]

Bump...

 

[MjClarke1]

Forward the SQL Port.

Default 3306


If that doesn't work.. no idea.

 

[spotlifter]

Create another user on the mysql server. Username 'root' is not allowed.
Changes in your config files.

mysql_host=(your database ip)
mysql_user=(new user, not 'root')
mysql_password=(new password, not use by 'root')
mysql_database=roseon(or whatever you name it)

Other configs is pretty much the same. I hope this could help you and may it works for you.

 

[Lolkereltje]

Hey spotlifter,

Thank you for your idea , but how do I know what my database IP is. I always put localhost in mysql_host, and it works (for my site). So how can I know what my database IP is?

Thank you again

 

[spotlifter]

Hey spotlifter,

Thank you for your idea , but how do I know what my database IP is. I always put localhost in mysql_host, and it works (for my site). So how can I know what my database IP is?

Thank you again

I'm confused here. Didn't you mention "I have my own website where the database is not running on my computer. " ???
So whats your website domain name/ip?? Just use that domain or ip. Put it on the server config file. Don't tell me your website url is 'http://localhost' .... :sweatdrop

Ok, let me make it more simple:

 2 computers, Comp A & B.
Comp A running web & mysql. All config file hosted in Comp A is called "localhost" or "127.0.0.1".
If from Comp B wants to connect to Comp A, you have put the host "Comp A ip", not localhost or 127.0.0.1.

Understand now?

 

[Lolkereltje]

I fixed it. Thank you very very much