Chinaunix

标题: [mysql端口3306]外部机器无法连接mysql[root帐号进入localhost没有问题] [打印本页]

作者: 庄周蝴蝶 时间: 2006-01-20 10:51
标题: [mysql端口3306]外部机器无法连接mysql[root帐号进入localhost没有问题]
我在freebsd上已经能够进入mysql,  root帐号进入localhost没有问题，但是外部机器进来却不成功(另外root帐号进入127.0.0.1也不成功)

我用 ps -aux|grep mysql 命令可看到一些mysql的进程

1. 已经确认在 /etc/servers 里面有下面两句
mysql 3306/tcp # mysql
mysql 3306/udp # mysql

2. /etc/my.cnf 内容如下：

[client]
#password = 123456
port = 3306
socket = /tmp/mysql.sock

[mysqld]
skip-innodb
skip-locking
skip-networking
set-variable = port=3306
set-variable = socket=/tmp/mysql.sock
set-variable = back_log=50
set-variable = connect_timeout=3
set-variable = key_buffer=128M
set-variable = max_connections=1000
set-variable = max_allowed_packet=1M
set-variable = net_buffer_length=8K
set-variable = wait_timeout=3
set-variable = read_buffer_size=1M
set-variable = sort_buffer_size=1M
set-variable = table_cache=256
set-variable = myisam_sort_buffer_size=32M
set-variable = log_slow_queries=/var/log/log_slow_queries.log
#log-bin
server-id = 1

[mysqldump]
quick
set-variable = max_allowed_packet=16M

3. netstat -a 显示如下：

Active Internet connections (including servers)
Proto Recv-Q Send-Q  Local Address       Foreign Address       (state)
tcp4    0    40  freebsd.ssh          bluehe.1986          ESTABLISHED
tcp4    0    0  *.finger             *.*                   LISTEN
tcp4    0    0  *.login             *.*                   LISTEN
tcp4    0    0  *.shell             *.*                   LISTEN
tcp4    0    0  *.telnet             *.*                   LISTEN
tcp4    0    0  *.ftp                *.*                   LISTEN
tcp4    0    0  localhost.smtp       *.*                   LISTEN
tcp4    0    0  *.ssh                *.*                   LISTEN
tcp6    0    0  *.ssh                *.*                   LISTEN
udp4    0    0  *.syslog             *.*
udp6    0    0  *.syslog             *.*
Active UNIX domain sockets
Address  Type Recv-Q Send-Q Inode    Conn    Refs  Nextref Addr
c1daa4ec stream    0    0 c2025770       0       0       0 /tmp/mysql.sock
c1daa3d4 stream    0    0       0 c1daa460       0       0
c1daa460 stream    0    0       0 c1daa3d4       0       0
c1dab000 stream    0    0 c1da9220       0       0       0 /var/run/devd.pipe
c1daaa64 dgram    0    0       0 c1daae38       0 c1daab7c
c1daaaf0 dgram    0    0       0 c1daaec4       0       0
c1daab7c dgram    0    0       0 c1daae38       0       0
c1daae38 dgram    0    0 c1db3770       0 c1daaa64       0 /var/run/logpriv
c1daaec4 dgram    0    0 c1db3880       0 c1daaaf0       0 /var/run/log

作者: chinayx 时间: 2006-01-20 14:20
默认mysql由于安全性原因是不能从非本地（localhost）连接的。
你可以按照需要添加远程用户

作者: chujian 时间: 2006-01-21 22:17
localhost 改为 %

作者: qlks 时间: 2006-01-22 12:47
需要授权
例如你允许192.168.1.3机器访问，并且密码为1234
你可以这样:mysql>grant all on *.* to root@192.168.1.3 identified by '1234'
具体的可以看MySQL帮助

作者: ashchen 时间: 2006-01-22 14:57
楼上的回答都不对。

BSD我已经回答你了

skip-networking

这是关闭mysql tcp/ip子系统的，注释掉重启mysql就行了

作者: macrodba 时间: 2006-01-23 09:08
支持楼上的

作者: darkcom 时间: 2008-11-10 10:01
标题: 回复 #5 ashchen 的帖子
5楼很伟大

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)