Salam....
Saya belajar mysql dan php...sudah menyalin script kecil dari manual mysql
namun saat dijalankan muncul error di browser sbb
---------
Warning: MySQL Connection Failed: Can't connect to local MySQL server throughsocket
'/var/lib/mysql/mysql.sock' (111) in /var/www/swatindo/coba/index.php3
on line 7
Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111) in
/var/www/swatindo/coba/index.php3 on line 9
---------
Saya mencoba mencari tahu caranya dan dijelasakan sebagai berikut :
1. Restart daemon mysql : cara ini tidak berhasil..
2. Melakukan test-test sebagai berikut :
- mysqladmin version : testnya ok
- mysqladmin variables : ok
- mysqladmin -h 'hostname' version variables : ok
- mysqladmin -h 'hostname' --port=3306 version : ok
- mysqladmin -h 'ip for your host' version : gagal, keluar eror sbb
[root@buaya /root]# mysqladmin -h '192.168.1.1' version
mysqladmin: connect to server at '192.168.1.1' failed
error: 'Host '' is not allowed to connect to this MySQL server'
[root@buaya /root]#
- mysqladmin --socket=/var/lib/mysql/mysql.sock version : gagal
dengan koment sbb berikut :
root@buaya /root]# mysqladmin -h --socket=/var/lib/mysql/mysql.sock version
mysqladmin: connect to server at '--socket=/var/lib/mysql/mysql.sock' failed
error: 'Unknown MySQL Server Host '--socket=/var/lib/mysql/mysql.sock' (11)'
Check that mysqld is running on --socket=/var/lib/mysql/mysql.sock and that the port
is 3306.
You can check this by doing 'telnet --socket=/var/lib/mysql/mysql.sock 3306'.
Saya sudah telnet localhost 3306 dengan hasil sbb ;
[root@buaya /root]# telnet localhost 3306
Trying 127.0.0.1...
Connected to buaya.
Escape character is '^]'.
1
3.23.22-beta-log=[4.-4\U,Connection closed by foreign host.
Tetapi kalau saya : telnet 192.168.1.1 3306 ; gagal...errornya sbb :
[root@buaya /root]# telnet 192.168.1.1 3306
Trying 192.168.1.1...
Connected to 192.168.1.1.
Escape character is '^]'.
9Host '' is not allowed to connect to this MySQL serverConnection closed by foreign
host.
[root@buaya /root]#
Bagaimana caranya agar mau konek ke server mysql ???
terima kasih
dede yang lagi bingung
--
Utk berhenti langganan, kirim email ke [EMAIL PROTECTED]
Informasi arsip di http://www.linux.or.id/milis.php3
