External SSL MySQL connection

Yii 2.0 General Discussions
1

I need to connect to an external MySQL connection with SSL but I can’t seem to make it work. I couldn’t find any topic regarding the matter or I may have missed it. Help to make this working would make my sad life easier.

Here’s what I did:

Thanks

2

Hi!

Not sure but it could be related to following:

You said external MySQL connection,

but in your DB config you have:

"dsn" => mysql:host=localhost;

Regards

3

Sorry for using localhost in this example, it’s for the sake of showing the attributes value. Now suppose “localhost” is actually an external ip, what would you do to connect it through SSL?. Thanks for responding.

4

Hi,

Sorry, can’t help further since I have not done external MySQL connection over SSL so far.

I found this.

It is for Yii 1 but maybe it can help?

http://www.yiiframework.com/forum/index.php/topic/29094-mysql-ssl-connection/page__view__findpost__p__214000

Regards

5

Hi,

Thanks for the efforts. Seems I made a stupid path error and messed it up. It’s working properly now. Works on both external and internal MySQL connections.

I posted it here:

http://adzbyte.com/2015/10/22/configuring-yii2-to-use-mysql-ssl-connections/

Happy Developing!!!