Hi List, Though new to mysql server, I was pretty happy with what I was doing till I needed to run another instance of mysql server on the same machine.
My first installation is running on port 3307 instead of default which I achieved by adding a port attribute in /etc/my.cnf file. Rest of the /etc/my.cnf file contains the basedir, data dir . logs and pid etc. Now I need to install a second server running on 3306 and all different pid, datadir paths etc... When I install the second version giving all the enw paths to configure and then run mysqld, it always say mysqld is already running. I have tried other ways using the default-files option, changing the cnf file locations.... and none if it working. I will appreciate any pointers please! Thanks