MySQL Forums
Forum List  »  Other Migration

Changing default values
Posted by: Joseph Fisher
Date: March 05, 2009 04:12PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Changing default values
6171
March 05, 2009 04:12PM
3723
March 06, 2009 04:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.