Hello, I have installed multiple mysql servers on the same box running Redhat linux 9.0. one through mysql RPM (version 3.2.54a) and other through source (version 3.2.58). The RPM installation has default configuration (like /etc/my.cnf, /var/lib/mysql etc etc). The second source installation has been configured as follows:- port = 4406, --prefix=/usr/local/somedir/sw/mysql/ --localstatedir=/usr/local/somedir/db/ --with-unix-socket-path=/usr/local/somedir/sock/mysql.sock --with-tcp-port=4406 The problem is that even after specifying the prefix and localstatedir the second type of installation references the configuration directives from my.cnf and the database is installed in /var/lib/mysql and the socket and ports are from the default. Is there a way to run multiple mysql servers with different ports, database directories and different sockets on Redhat 9.0 ??? any help in this regard is appreciated...in advance.
thanks Tasvir --------------------------------- Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online
