error LAMP casolà
xunilung | 09 Maig, 2007 18:57
Una vegada instal·lat el LAMP casolà no em podia connectar des d'un client al servidor mysql
xuni@apmf:~$ mysql -h 192.168.0.22 -u usuarimysql -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.22' (111)
Solució:
Comentar la línia
bind-address = 127.0.0.1
de l'arxiu /etc/mysql/my.cnf
.....
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
#
# * Fine Tuning
#
.....
Au! ja va bé
xuni@apmf:~$ mysql -h 192.168.0.22 -u usuarimysql -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.22' (111)
Solució:
Comentar la línia
bind-address = 127.0.0.1
de l'arxiu /etc/mysql/my.cnf
.....
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
#
# * Fine Tuning
#
.....
Au! ja va bé
MySQL | 
Següent | 
Anterior | 
Comentaris (0) | 
Retroenllaços (0)
Comentaris
Menú
Cerca
Calendari
| « | Setembre 2008 | » | ||||
|---|---|---|---|---|---|---|
| Dl | Dm | Dc | Dj | Dv | Ds | Dg |
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| 29 | 30 | |||||