Hi, If you plan to use RPM installation, you could encounter some difficulties.
Because RPM overrides the existing one. To avoid this , you can do a BINARY install with which you can choose the directories of two MySQL servers. After finishing to download the MySQL BINARY distribution that you want , just decompress it into 2 distinct directories, like : SERVER 1 : /usr/local/mysql-4.0.x SERVER 2 : /usr/local/mysql-4.0.y Note that if you have 2 MySQL servers on the same machine, pay attention to name some files like socket file, log file, err file, startup scripts with different names. Also the my.cnf file will not located in /etc because it becomes server specific options/configuration file. You have to place for example the 2 my.cnf files into data directory of each MySQL server directory : SERVER 1 : /usr/local/mysql-4.0.x/data/my.cnf SERVER 2 : /usr/local/mysql-4.0.y/data/my.cnf Try this workaround , hope this help Regards Thierno 6C ----- Original Message ----- From: "Minuk Choi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 31, 2004 4:00 PM Subject: redhat9 multiple instances walkthrough > Hey, I have RedHat 9, with the default MySQL RPM pre-installed. > > I'd like to set up multiple instances of MySQL. > > That is, have multiple data directories(all with separate mysql database and > tables) on different ports.(I have a few projects which "share" user names > but different privileges). > > What I need, because I'm new at this is a walkthrough. > > I would appreciate any help you can provide, as I tried to read and follow > the online documentation regarding "mysqld_multi" but I couldn't make heads > or tails out of it - I need some working examples. > > Thanks in advance, > -Minuk > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]