MySql connection using SSL
Today we are here to discuss about MySql connection using secure connection SSL (Secure Socket Layer) 1) Connect on local machine using command line. Here is simple MySql client command to access MySql server. mysql -u root -p root 2) MySql connection using SSL certificates. Tasks to perform on server side. Note: If you don't have openssl then download it and extract after that find "openssl.cnf" file and set it into environment variables. Variable Name: OPENSSL_CONF Variable Value: directory location\openssl.cnf For SSL connection we need to generate certificates. Generate RSA private key. openssl genrsa 2048 > "ca-key.pem" Generate self-signed CA certificate using RSA private key. openssl req -new -x509 -nodes -days 3600 -key "ca-key.pem" > "ca-cert.pem" Generate server RSA key. openssl req -newkey rsa:2048 -days 3600 -nodes -keyout "server-key.pem" > "server-req.pem" Generate server certificate. openssl x509
