Raised This Month: $51 Target: $400
 12% 

How to connect to MySQL through internet?


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Rirre
Veteran Member
Join Date: Nov 2006
Old 05-23-2009 , 14:21   How to connect to MySQL through internet?
Reply With Quote #1

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:
Code:
Can't connect to MySQL server on '<ip>' (10060) (2003)
with correct information in sql.cfg file.
I'm also logged in as admin@localhost, access denied with admin@<ip> in PhpMyAdmin.

Last edited by Rirre; 05-23-2009 at 15:49.
Rirre is offline
Spunky
Senior Member
Join Date: May 2008
Location: Orlando, Fl.
Old 05-23-2009 , 16:20   Re: How to connect to MySQL through internet?
Reply With Quote #2

Is the port open on the host machine? If not, you'd be able to connect locally, but not remotely.
Spunky is offline
Send a message via AIM to Spunky
Rirre
Veteran Member
Join Date: Nov 2006
Old 05-23-2009 , 16:24   Re: How to connect to MySQL through internet?
Reply With Quote #3

Quote:
Originally Posted by Spunky View Post
Is the port open on the host machine? If not, you'd be able to connect locally, but not remotely.
EDIT: Oh, wait.
No I guess not. Tested via Telnet and it doesn't respond, but it does to the webserver.

Last edited by Rirre; 05-23-2009 at 17:27.
Rirre is offline
Rirre
Veteran Member
Join Date: Nov 2006
Old 05-23-2009 , 19:25   Re: How to connect to MySQL through internet?
Reply With Quote #4

Haha! Solved xD
The problem was i didn't enable 3306 port in Windows Firewall
Now its working!
Rirre is offline
alexinno
Senior Member
Join Date: Mar 2007
Location: C:\
Old 05-24-2009 , 03:27   Re: How to connect to MySQL through internet?
Reply With Quote #5

you should delete that 'Any' user from the accounts table
__________________

[IMG]http://img188.**************/img188/5787/banner2rcw.png[/IMG]
alexinno is offline
obamaviva
Zero Posts
Join Date: May 2009
Old 05-26-2009 , 23:56   Re: How to connect to MySQL through internet?
Reply With Quote #6

I'm also logged in as admin@localhost
__________________
obamaviva is offline
danielkza
AMX Mod X Plugin Approver
Join Date: May 2007
Location: São Paulo - Brasil
Old 05-29-2009 , 15:07   Re: How to connect to MySQL through internet?
Reply With Quote #7

Quote:
Originally Posted by alexinno View Post
you should delete that 'Any' user from the accounts table
It's a denial entry.
__________________

Community / No support through PM
danielkza is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 16:54.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode