for a normal replication, you need to create a replication user by issuing such command:
GRANT FILE ON *.* TO repl@"%" IDENTIFIED BY '<password>'; for a secured replication (mysql-4.0.7-gamma), do you need to issue a REQUIRE SSL, eg: GRANT FILE ON *.* TO repl@"%" IDENTIFIED BY '<password>' REQUIRE SSL; but when REQUIRE SSL is issued, the slave would not be able to connect to the master anymore. i would really appreciate if someone could guide me to the correct way of implementing a secured replication setup for mysql. also, here is my.cnf configuration for the slave: [mysqld] [...] log-bin server-id = 2 master-host = 192.168.1.1 master-user = repl master-password = $jhM*prs master-ssl master-ssl-key = /usr/local/ssl/certs/some.key master-ssl-cert = /usr/local/ssl/certs/some.crt regards, ivan --------------------------------------------------------------------- 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
