Hello members, I have two mysqld run on the same host (redhat linux OS with 2.4 kernel). the two mysqld are in different versions, one is 4.0.20,another is 5.0.45.
the mysql 4.0.20 uses /etc/my.cnf as its config file,listening on default 3306 port. the mysql 5.0.45 uses /etc/mysql5.cnf as its config file,listening on 3307 port. I start them on command line: /usr/local/mysql/bin/mysqld_safe & # for mysql4 /opt/mysql5/bin/mysqld_safe --defaults-file=/etc/mysql5.cnf & # for mysql5 All run fine.I didn't see exceptions in mysql's error logs. But, when I try to connect to mysql5, with the command, mysql -uroot -P3307 -h127.0.0.1 Sometime I login it successfully,but most time I can't. The connection seems be blocked. (I don't run any iptables or firewall on this host). This let me really be confused. please help. Thanks! --Ken National Bingo Night. Play along for the chance to win $10,000 every week. Download your gamecard now at Yahoo!7 TV. http://au.blogs.yahoo.com/national-bingo-night/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]