The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How do you allow SECURE remote MySQL connections?

Discussion in 'General Discussion' started by Valetia, Jun 3, 2004.

  1. Valetia

    Valetia Well-Known Member

    Joined:
    Jun 20, 2002
    Messages:
    207
    Likes Received:
    1
    Trophy Points:
    18
    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?
     
  2. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    this should help MySQL SSL Connections , it pretty much goes through the process required to utilize SSL connections.

    Mickalo
     
  3. Valetia

    Valetia Well-Known Member

    Joined:
    Jun 20, 2002
    Messages:
    207
    Likes Received:
    1
    Trophy Points:
    18
    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?
     
  4. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    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
     
Loading...

Share This Page