I am running MySQL 3.23.43 (installed via RPM)
The RPM's default socket is: /var/lib/mysql/mysql.sock The my.cnf file that I setup has the following settings: [mysqld2] port = 3333 socket = /tmp/mysql.sock.3333 master-host = 192.168.0.204 master-user = mysql_replication master-password = xxxxx master-port = 3333 master-connect-retry = 10 ... I start up the server using mysqld_multi: /usr/bin/mysqld_multi --config-file=/dharma/conf/mysql.conf start 2-3 The server stats just fine, I can connect with mysqladmin and with mysql without any problems. However, the slave process will not run, it errors with the following message: 020211 12:12:59 Slave thread: error connecting to master: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (2), retry in 10 sec For some reason, it is not using the socket in the config file. When I do a mysqladmin -P 3333 -p -S /tmp/mysql.sock.3333 variables it has the proper socket: /tmp/mysql.sock.3333 How can I get the slave thread to use the correct socket? Thanks, Frank --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
