Multiple mysql server in linux
 

Can anyone tell me how can I setup multiple mysql server on the same machine. I have check so many website and read all the articles, but still can't figure out how to do it. I am using Redhat 9.0 and mysql-3.23.54a-11. It already has mysql in it. It's data directory is located at /usr/bin/mysql and all the (mysqladmin, safe_mysqld, mysql, mysql_install_db) is under the /usr/bin folder.

I would like to have another mysql server which has it's data directory as /usr/bin/mysql2

How can I do it? Do I have to install another mysql server.

I have read about changing the my.cnf and using the mysqld_multi. But was not successful.

Can anyone please help me.

These should get you on the way..
What are the problems you encounter?

http://dev.mysql.com/doc/mysql/en/multiple-servers.html
http://dev.mysql.com/doc/mysql/en/mysqld-multi.html
http://dev.mysql.com/doc/mysql/en/replication-faq.html