可是外部卻不行,是不是什麼設定漏了
還請各位高手幫幫忙
參考資料
環境:debian stable
IP=192.168.1.209
debian:~# uname -a
Linux debian 2.4.18-bf2.4 #1 Son Apr 14 09:53:28 CEST 2002 i586 unknown
debian:~# dpkg -l | grep mysql
ii libdbd-mysql-p 1.2216-2 mySQL database interface for Perl
ii libmysqlclient 3.23.49-8 mysql database client library
ii mysql-client 3.23.49-8 mysql database client binaries
ii mysql-common 3.23.49-8 mysql database common files (e.g. /etc/mysql
ii mysql-doc 3.23.51-0woody mysql database documentation
ii mysql-server 3.23.49-8 mysql database server binaries
debian:~# mysqladmin -u mike -p status
Enter password:
Uptime: 21820 Threads: 1 Questions: 46 Slow queries: 0 Opens: 17 Flush tabl
es: 1 Open tables: 6 Queries per second avg: 0.002
debian:~# mysql --user=root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 3.23.49-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select user, host from mysql.user;
- 代碼: 選擇全部
+------------------+---------------+
| user | host |
+------------------+---------------+
| mike | % |
| mike | 192.168.1.134 |
| | debian |
| root | debian |
| | localhost |
| admin | localhost |
| debian-sys-maint | localhost |
| mike | localhost |
| root | localhost |
+------------------+---------------+
9 rows in set (0.00 sec)
環境:win2k server
IP=192.168.1.134
C:\mysql\bin>mysqladmin -h 192.168.1.209 -u mike -p status
Enter password: *******
mysqladmin: connect to server at '192.168.1.209' failed
error: 'Can't connect to MySQL server on '192.168.1.209' (10061)'
Check that mysqld is running on 192.168.1.209 and that the port is 3306.
You can check this by doing 'telnet 192.168.1.209 3306'
C:\mysql\bin>telnet 192.168.1.209 3306
正連線到 192.168.1.209...無法開啟連接到主機的連線 連接埠 3306 : 連線失敗
