How to connect to MySQL through internet?
 

I have to use Internet IP as host now since I have 2 rackservers (not located in same area).
Have use "amx_sql_host 127.0.0.1" a long time now without any problems on the 1st server I got.
But this time I have 2 rackservers and want the 2nd to connect & use same MySQL/database over the Internet since I have AMXBans installed on the 1st one.
How can I do this?
I have try Google, found most Linux users and older version of MySQL and threads which haven't been answered. I'm a Windows user.
EDIT: I'm using PhpMyAdmin.
I have setup a user (admin) in PhpMyAdmin which I want to use in amxmodx/configs/sql.cfg file.
[IMG]http://img132.**************/img132/3927/65921753.jpg[/IMG]

But I just get this output:
with correct information in sql.cfg file.
I'm also logged in as admin@localhost, access denied with admin@<ip> in PhpMyAdmin.

Re: How to connect to MySQL through internet?
 

Is the port open on the host machine? If not, you'd be able to connect locally, but not remotely.

Re: How to connect to MySQL through internet?
 

EDIT: Oh, wait.
No I guess not. Tested via Telnet and it doesn't respond, but it does to the webserver.

Re: How to connect to MySQL through internet?
 

Haha! Solved xD
The problem was i didn't enable 3306 port in Windows Firewall :P
Now its working! :D

Re: How to connect to MySQL through internet?
 

you should delete that 'Any' user from the accounts table :)

Re: How to connect to MySQL through internet?
 

I'm also logged in as admin@localhost

Re: How to connect to MySQL through internet?
 

It's a denial entry.