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.

MySQLi (mysql improved) ?

Discussion in 'General Discussion' started by sh4ka, Jun 17, 2008.

  1. sh4ka

    sh4ka Well-Known Member

    Joined:
    May 12, 2005
    Messages:
    442
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    US
    cPanel Access Level:
    DataCenter Provider
    Hello,

    One of my customers asked me to install this php library on the server, it seems to be available from EasyApache.. but Im already using this:

    MySQL (compile mysql support using the PHP bundled libraries)
    MySQL of the system (compile mysql and mysqli (if checked) against system libraries)

    My question:
    May this new mysql library (MySQLi) cause any conflict with the other two I mentioned before?

    This is a RHE 5.2 + cPanel with latest R version.

    Thanks.
     
  2. sneader

    sneader Well-Known Member

    Joined:
    Aug 21, 2003
    Messages:
    1,126
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    La Crosse, WI
    cPanel Access Level:
    Root Administrator
    I have the exact same situation and question. I have a customer asking for MySQLi support and am unsure of the repercussions of adding it to the build. Any suggestions?

    - Scott
     
  3. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    MySQLi will not interfere with the normal PHP MySQL extension. Only applications that explicitly use the MySQLi extension will use it.
     
  4. sneader

    sneader Well-Known Member

    Joined:
    Aug 21, 2003
    Messages:
    1,126
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    La Crosse, WI
    cPanel Access Level:
    Root Administrator
    Thanks Ken. I ran through EasyApache tonight and added MySQLi support (via exhaustive PHP options) and also took the opportunity to upgrade my PHP to 5.2.8 (looks like a pile of security fixes -- surprised there isn't a lot of chatter about this).

    So far, MySQLi is working for the customer, and I'm not seeing any impact otherwise.

    Thanks again!

    - Scott
     
  5. ANewDay

    ANewDay Well-Known Member

    Joined:
    Sep 11, 2006
    Messages:
    86
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    USA
    Need to add anything in the php.ini files to take advantage of mysqli?
     
  6. sneader

    sneader Well-Known Member

    Joined:
    Aug 21, 2003
    Messages:
    1,126
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    La Crosse, WI
    cPanel Access Level:
    Root Administrator
    Why not just use EasyApache and add MySQLi support (via exhaustive PHP options)? Worked for me.

    - Scott
     
  7. ANewDay

    ANewDay Well-Known Member

    Joined:
    Sep 11, 2006
    Messages:
    86
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    USA
    I'm using litespeed instead of apache.
     
Loading...

Share This Page