Changing default values
We originally installed a MySQL instance on two separate servers, using all of the default settings, to include datadir, socket, log-error, pid-file, etc.
We recently decided to cluster these servers, but the two database instances cannot co-exist on the same server at the same time, because they're both using the same port numbers, same log directories, etc.
I need to modify at least one of these configurations, so that it logs, and accesses the database instance via a different port.
Can anyone tell me which files need to be modified, and in which directories they exist?
I already created a copy of the mysqld startup script, and modified the entries in it.
Everything seems to startup just fine, as long as I don't change the socket location.
But, even though the mysqld command appears to work, and it can be seen using a ps -ef, I can not connect to the actual database.
I keep getting the following error message:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysel/mysql.soc' exists!
Does anyone know how to modify the startup script, or configuration files, to move the database instance to the new port?
Thanks in advance, and have a great day.
Joe F.