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.
|