Page 1 of 1

Mysql access from remote computer.

PostPosted: 22. December 2008 02:15
by zugsat
Hi! I´m quite new at this, i install xampp a few days ago and on the local computer everything works fine.

On the local computer i run HeidiSQL and Mysql Front to access to mysql database and works fine, on the host name i put localhost or 127.0.0.1 and all works ok.

The problem is when i tried to access to mysql database from a remote computer using either HeidiSQL or Mysql Front i cant connect to the database, on the host name i put my external ip address that is correct (because i can access to my web page) or my dns name, but i cant have access to my database, the port 3306 is also open on my router.

Probably i am missing something on the host name, could someone give me some help on this, i think it is a host name problem but i cant figure where is the problem.

Regards

Zugsat

Re: Mysql access from remote computer.

PostPosted: 22. December 2008 02:26
by Wiedmann
could someone give me some help on this,

If HeidiSQL or Mysql Front does not provide a helpfull error message (original error message from the mysql client library), please use the MySQL command line client for a connection test.

Re: Mysql access from remote computer.

PostPosted: 22. December 2008 17:25
by zugsat
Hi, it seems that first i have a firewall problem the 3306 port was closed now it´s ok.

After that, the user i was trying to login don't have privileges :( but after a little more search finally i managed to have access to my database ufff :D

Thanks.

Regards