How do you allow SECURE remote MySQL connections?

Valetia

Well-Known Member
Jun 20, 2002
216
10
168
cPanel Access Level
Root Administrator
Cpanel servers by default allow MySQL connections via port 3306, but these are not secure connections.

How do you allow secure connections?
 

Valetia

Well-Known Member
Jun 20, 2002
216
10
168
cPanel Access Level
Root Administrator
Read through that, and here's what you're supposed to do in step 2:

"When you configure MySQL, run the configure script with the --with-vio and --with-openssl options."

How would you do that on a Cpanel machine? Do you have the exact steps? Would this screw Cpanel up?
 

mickalo

Well-Known Member
Apr 16, 2002
782
5
318
N.W. Iowa
Originally posted by Valetia
Read through that, and here's what you're supposed to do in step 2:

"When you configure MySQL, run the configure script with the --with-vio and --with-openssl options."

How would you do that on a Cpanel machine? Do you have the exact steps? Would this screw Cpanel up?
Not sure if this would break Cpanel or not, but probably as Cpanel is not setup to enter the privilege settings for the SSL privileges plus the RPM's used by Cpanel don't use MySQL-Max server, it uses the std MySQL server RPM.

You may want to setup a second MySQL server, compiled from a binary or custom build from source, using a different port, like 3307, and different server locations, then set it up with the SSL configuration. We've run multiple MySQL servers for production/developement work on other servers w/Cpanel with no problems. As long as you maintain all the default MySQL cpanel configurations, you can run a second copy and use it for testing or custom appilications.

I would strongly suggest if you go this route, to pick a some good referenece books on MySQL or go through the docs on MySQL site.... it can get a bit confusing :D

Mickalo