Ken, You should probably be specifying the socket for both the startup commands and the connect commands just to be sure. Without seeing your config files, it's hard to say much else.
Rich(ard) On Nov 6, 2007 9:37 PM, tech user <[EMAIL PROTECTED]> wrote: > 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] > > -- Richard Edward Horner Engineer / Composer / Electric Guitar Virtuoso [EMAIL PROTECTED] http://richhorner.com - updated June 28th -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
