Mysql access from remote computer.
Posted: 22. December 2008 02:15
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
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