Master/slave mysql ssl

Discussion in 'Installation/Configuration' started by pititis, Apr 5, 2012.

  1. pititis

    pititis Member

    Hello,

    I have enabled ssl and certificates for my master server(mysql), also I have added an user to mysql:

    Code:
    
    CREATE USER 'root'@'192.168.0.106' IDENTIFIED BY 'myrootpassword';
    GRANT ALL PRIVILEGES ON * . * TO 'root'@'192.168.0.106' IDENTIFIED BY 'myrootpassword' [B]REQUIRE SSL[/B] WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
    
    
    After this, in the slave I want to join the master server running the install script. Here is my question, need I enable ssl and generate the certificates in the slave too?
     
  2. till

    till Super Moderator

    I dont think so as the slave connects to the master and not the master to the slave.
     

Share This Page