FluxCP Connection

[Decimal]

So I have rAthena and MySQL Server running on my computer and the FluxCP running on Go Daddy.

My question is;

How do I connect the FluxCP to my computer?

What I tried is;

FluxCP/config/servers

'Hostname'   => 'My Computer WAN-IP (I even tried no-ip adress)',
'Username'   => 'MySQL Username',
'Password'   => 'MySQL Password',
'Database'   => 'MySQL Database',

I also configured my router to forward PORT 3306. I even turned the Firewall Off.

Edited February 9, 2012 by Decimal

[JayPee]

if they both run on the same computer your hostname should be localhost while your username can be root and password is the given password by your host or sometimes default password is root or blank. For the database its the database of your ro server currently use.

[Decimal]

Both aren't running on the same computer, that's the problem.

rAthena and MySQL Server are running on "A computer" which is my home's computer. The FluxCP is running on "B Computer" which is my web host's computer (Go Daddy).

Edited February 9, 2012 by Decimal

[JayPee]

try to turn on the error reporting at config/error.php this will give full detail of error.

This might fix the problem

• Grant permission on your fluxcp address in your mysql use MySQL Bundle if your hosting at windows os if linux just google it.
  

[Decimal]

try to turn on the error reporting at config/error.php this will give full detail of error.

Here, take a look;

Note: The error happens when I try to use the features which needs SQL connection, like in; Registration, Log-in, Server Info, Server Status, etc...

Grant permission on your fluxcp address

My File Permission is: 777 (Read Write and Execute for Owner, Group and Public).

in your mysql use MySQL Bundle if your hosting at windows os if linux just google it.

Yes, I am using Windows. I'm using XAMMP for MySQL Server, do I need that MySQL Bundle still?

Edited February 9, 2012 by Decimal

[Asura]

Hi Decimal,

I can only come up with 2 reasons for why this may be happening...

1) Port 3306 is not opened on your computer hosting the MySQL Server

2) GoDaddy's webhosting has not white-listed your MySQL Server's IP, blocking their server from communicating outside

Try to resolve this, good luck.

[Hyvraine]

Try this:

If you're using Windows 7, go open Windows Firewall with Advanced Security

-Click Inbound Rules

-On the right pane, create a new rule

-Select port

-Specific local ports: 3306 (or any port as long as it's the one rAthena and MySQL is using.

-Allow the connection

-Then follow the instructions.

====

Okay so I'm not sure if it's inbound or outbound.. but I feel that it's inbound...

[Decimal]

Well, I've made a MySQL DB on "B Computer" which is my web host's computer; then MySQL connected perfectly to the CP. However now, I've to connect my Inter_Athena to "B Computer".

Anywayy, everything's working now. Thanks for everyone's help.

[Hayate Yoshida]

Have you given access to your external server? If not, use this:

Example:

GRANT SELECT, UPDATE, DELETE, INSERT ON db_name.table_name TO mysqluser@externalhost IDENTIFIED BY 'yourpassword';

Edit: oops I should have read your lasy post a bit more carefully, I'll leave this here that way if someone has a similar problem this might be useful.

Edited March 26, 2012 by Shinon Yoshida