Hi,
I can't install MySQL on my windows XP SP2 (Professional Edition), without any other firewall programs (only the bult-in winXP fw), and I have NOD32 as antivirus.
I get this error when I try to configure the instance of MySQL server ! I've another PC (with XP SP2 Home Edition) on my home lan, with MySQL.
I've checked :
1) The Windows Firewall (the only firewall on this PC) or disable it
2) The /etc/hosts file
3) try to ping localhost, ping 127.0.0.1, ping <nameMachine>
4) try to change the default port 3306
5) try without LAN
6) try to open the 3006 port on my Router
7) try with dynamic IP and static IP with the same DNS server of the other PC with mysql
8) try to modify the windows registry with this :
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
9) try 4.xx and some other 5.xx MySQL version
10) some commands :
C:\Documents and Settings\Lorenzo>tracert 127.0.0.1
Rilevazione instradamento verso localhost [127.0.0.1]
su un massimo di 30 punti di passaggio:
1 <1 ms <1 ms <1 ms localhost [127.0.0.1]
C:\Programmi\MySQL\MySQL Server 5.0\bin>mysqladmin -h 127.0.0.1 variables
mysqladmin: connect to server at '127.0.0.1' failed
error: 'Can't get hostname for your address'
C:\Programmi\MySQL\MySQL Server 5.0\bin>mysqladmin -h starlight variables
mysqladmin: connect to server at 'starlight' failed
error: 'Can't get hostname for your address'
C:\Programmi\MySQL\MySQL Server 5.0\bin>mysqladmin -h 192.168.1.100 variables
mysqladmin: connect to server at '192.168.1.100' failed
error: 'Can't get hostname for your address'
C:\Documents and Settings\Lorenzo>telnet 127.0.0.1
Connessione a 127.0.0.1...Impossibile aprire una connessione con l'host. sulla p
orta 23: Connessione non riuscita
C:\Documents and Settings\Lorenzo>telnet 127.0.0.1 3306
Connessione a 127.0.0.1...Impossibile aprire una connessione con l'host. sulla p
orta 3306: Connessione non riuscita
Anyone can help me ?
Edited 1 time(s). Last edit at 08/26/2007 02:53AM by Lorenzo Franceschini.