Re: MySQL connection sting in C# via SSL
Posted by: Gabriela Martinez Sanchez
Date: February 26, 2015 12:28PM

Hi Mitch,
The configuration is located on the root of the folder where the mysql server files are. Did you install the server using the msi? or the zip? If you use the msi the default folder is under the "Program Files x86" or "Program Files".
If you download a zip file then you probably have a folder like \mysql-5.5.30-winx64\ in one of the disk of your system.

Under this folder you find the .ini files. There are several options. For a development environment you can pick the my-small.ini. This file would need to be renamed to my.ini so the server can pick it up as the configuration file.

In order to set up the SSL certificates you would need to add these lines at the [mysqld] section:

ssl-key=C:/Program Files/MySQL/MySQL Server X.X/cert/server-key.pem
ssl-cert=C:/Program Files/MySQL/MySQL Server X.X/cert/server-cert.pem
ssl-ca=C:/Program Files/MySQL/MySQL Server X.X/cert/ca-cert.pem

Where "C:/Program Files/MySQL/MySQL Server 5.0/cert/" is a path to certs.

You can check more information on the official documentation.

http://dev.mysql.com/doc/refman/4.1/en/secure-create-certs.html


Hope this helps.

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL connection sting in C# via SSL
February 26, 2015 12:28PM


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.