Access MySQL from outside

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Re: Access MySQL from outside

Postby mythrix » 06. January 2011 15:27

Nobbie wrote:The next step is reading documentation. Either get you a book, or some tutorials, or simply the original doc from http://www.mysql.com
And be patiently - nobody had learned all that stuff in a few minutes, neither via a forum. A forum is good place for certain technical problems, but it cannot replace the need of reading documentation.

you don't have to be a smart ass.. instead of giving a useless reply and you don't know how to fix my problem DON'T post... just increasing your post number on this forum doesn't make you a pro
mythrix
 
Posts: 14
Joined: 03. January 2011 17:34

Re: Access MySQL from outside

Postby Nobbie » 06. January 2011 15:40

mythrix wrote:you don't have to be a smart ass.. instead of giving a useless reply and you don't know how to fix my problem DON'T post... just increasing your post number on this forum doesn't make you a pro


Simply dont read my reply if you dont like the truth. I dont think that somebody will help you furthermore for your kindly "ass".
Nobbie
 
Posts: 8775
Joined: 09. March 2008 13:04

Re: Access MySQL from outside

Postby JonB » 06. January 2011 17:03

I think you are dealing with a MySQL socket problem - the XAMPP default id the MySQL socket, which only works locally. If you want to use tools or updates that don't use the phpmyAdmin instance built into XAMPP or PHP or Perl scripts that execute locally - you will need to make the MySQL socket type 'TCP/IP'. I use MySQL Workbench this way.. I have MYSQL Workbench installed at my office, and I can connect to the XAMPP server's MySQL instance to DL tables, lookup, update tables etc.

read this topic.
viewtopic.php?f=16&t=42567&p=167604&hilit=Mysql+socket#p167604

Good Luck
:)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Access MySQL from outside

Postby mythrix » 06. January 2011 18:45

JonB wrote:I think you are dealing with a MySQL socket problem - the XAMPP default id the MySQL socket, which only works locally. If you want to use tools or updates that don't use the phpmyAdmin instance built into XAMPP or PHP or Perl scripts that execute locally - you will need to make the MySQL socket type 'TCP/IP'. I use MySQL Workbench this way.. I have MYSQL Workbench installed at my office, and I can connect to the XAMPP server's MySQL instance to DL tables, lookup, update tables etc.

read this topic.
viewtopic.php?f=16&t=42567&p=167604&hilit=Mysql+socket#p167604

Good Luck
:)

i modified my.ini like you said but i still can't update the database -_-
mythrix
 
Posts: 14
Joined: 03. January 2011 17:34

Re: Access MySQL from outside

Postby JonB » 07. January 2011 00:36

I suggest you temporarily make a 'dummy' home page, and then enable port 80 forwarding. (and make the basic security precautions).

This way, you will be able to determine that your DynDBS setup is working correctly. (I can't think of any other reasonable way to test it).

If you are able to connect to that web page - then we are down to MySQL problems.

I see you are relying on your own code, that's making a lot of assumptions in asking for help; therefore I also suggest that you use a standard query tool to test the connection, not your own code. (MySQL Workbench is free and easy to get working - just my 2 cents :wink: )

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Access MySQL from outside

Postby mythrix » 07. January 2011 21:32

doesn't work
mythrix
 
Posts: 14
Joined: 03. January 2011 17:34

Previous

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 45 guests