FC3 - MySQL can't connect to external Server

[Ep Woody]

Hi,

I've got a website which runs on 2 servers. I want that FC3 connects to my router where the DB-Server is located. (MySQL 3.23)

Somehow it won't succeed, and if I try another db-server on the web it doesn't work either.

FC3 just wants to connect to it's own mysql-server.

Does anyone now why?

Tia

Ep

[awesomejt]

Sounds like you need to setup your MySQL users for each host you plan to chat from.

GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'hostname'
IDENTIFIED BY 'secret' WITH GRANT OPTION;

Of course, this is not exact and you will want to change the GRANT permissions to fit your needs. The above script effectively gives you full persmissions (admin rights) on the database you assign it.

The *hostname* field can be interpreted as the "client" host name -- basically any host that will be accessing the MySQL database.

See the MySQL Documentation:
http://dev.mysql.com/doc/mysql/en/adding-users.html

Also make sure the firewall isn't preventing you from reaching it also.