Friday, December 16, 2005 10:37 AM, "Nyoman D" wrote:
Hello sizzle,
Hello juga Nyoman,
Secara default, akan listen di semua IP address, di server saya ada IP
publicnya, jadi saya cuma mau listen di localhost dan IP Local saja,
mungkin tidak ?
kalo saya secara pribadi akan listen di IP Local saja, toh komputer lokal
juga masih bisa akses kesana, CMIIW. Saya hanya user biasa dan ga ada
network disini jadi ga tau gimana persisnya kalo diimplementasikan di
jaringan :(
mysql> connect mysql;
Connection id: 5
Current database: mysql
mysql> select host,user,password from user;
+-------------+----------+------------------+
| host | user | password |
+-------------+----------+------------------+
| 127.0.0.1 | root | 0b89d2383b82c0b7 |
| 192.168.0.1 | sqladmin | 0b89d2383b82c0b7 |
+-------------+----------+------------------+
2 rows in set (0.00 sec)
[EMAIL PROTECTED]:/home/strider# netstat -tna
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:37 0.0.0.0:* LISTEN
tcp 0 0 192.168.0.1:3306 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:6000 0.0.0.0:* LISTEN
tcp 0 0 192.168.0.1:80 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:113 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:53 0.0.0.0:* LISTEN
[EMAIL PROTECTED]:/home/strider# mysql -u root -h 127.0.0.1 -p
Enter password:
ERROR 2003: Can't connect to MySQL server on '127.0.0.1' (111)
[EMAIL PROTECTED]:/home/strider# mysql -u sqladmin -h 192.168.0.1 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.58-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Nyoman.
Regards,
---
Anton
--
FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
Unsubscribe: kirim email ke [EMAIL PROTECTED]
Arsip dan info milis selengkapnya di http://linux.or.id/milis
