PHPFixing
  • Privacy Policy
  • TOS
  • Ask Question
  • Contact Us
  • Home
  • PHP
  • Programming
  • SQL Injection
  • Web3.0

Monday, February 14, 2022

[FIXED] Enable OpenSSL on MAMP MYSQL (MAC)

 February 14, 2022     macos, mamp, mysql, openssl, ssl     No comments   

Issue

Hi i'm having a problem trying to enable SSL on Mysql (MAMP version 3.0.5 for mac)
When i try to add :

ssl
or ssl-ca=/Users/myuser/Documents/ssl/ca-cert.pem

lines on my.cnf
On the log of mysql i got the Error

unknown variable ssl
unknown variable ssl-ca=

can someone help me please?


Solution

Check if mysql was compiled with ssl support using mysqld --ssl --help. You will get unknown option --ssl if its not compiled in.

You can also try the following queries SHOW VARIABLES LIKE 'have_ssl'; and SHOW VARIABLES LIKE 'have_openssl';

If you don't have it compiled in you may need to replace it with the version from homebrew/macports or compile from source.



Answered By - Tricky
  • Share This:  
  •  Facebook
  •  Twitter
  •  Stumble
  •  Digg
Newer Post Older Post Home

0 Comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Total Pageviews

Featured Post

Why Learn PHP Programming

Why Learn PHP Programming A widely-used open source scripting language PHP is one of the most popular programming languages in the world. It...

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Copyright © PHPFixing