Page 3 of 3

Re: Access MySQL from outside

PostPosted: 06. January 2011 15:27
by mythrix
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

Re: Access MySQL from outside

PostPosted: 06. January 2011 15:40
by Nobbie
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".

Re: Access MySQL from outside

PostPosted: 06. January 2011 17:03
by JonB
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
:)

Re: Access MySQL from outside

PostPosted: 06. January 2011 18:45
by mythrix
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 -_-

Re: Access MySQL from outside

PostPosted: 07. January 2011 00:36
by JonB
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)

Re: Access MySQL from outside

PostPosted: 07. January 2011 21:32
by mythrix
doesn't work