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.

PDO / MySQL - Install concerns

Discussion in 'Database Discussions' started by doulos61, Mar 27, 2015.

  1. doulos61

    doulos61 Well-Known Member

    Joined:
    Dec 13, 2006
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    Greetings -

    I have been asked by a client to install PDO php function component as part of a shopping cart. My concerns are that I am running MySQL on the server right now.

    To put in simplest terms am I able to run the PDO php function, and MySQL on the same server simultaneously? If so, what do I need to take into consideration.

    I appreciate any information in consideration of this matter.

    Thanks
    Shoop
     
  2. 24x7ss

    24x7ss Well-Known Member

    Joined:
    Sep 30, 2014
    Messages:
    271
    Likes Received:
    16
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Yes, you can run both pdo and mysql simultaneously there is no issue with it. First check pdo is installed on the server or not by creating php info file or you can directly check it on server via ssh.

    If it is not installed then you can install it by performing easyapache on server. It will not affect your Mysql settings.
     
  3. doulos61

    doulos61 Well-Known Member

    Joined:
    Dec 13, 2006
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    Response appreciated,

    My intention was to install the PDO via easyApache. I just got to that point on the build selections and had the thought of potential conflict with MySQL that is already on the server. From what I can see from the backend WHM GUI it isn't installed.

    Thanks
    Shoop
     
  4. 24x7ss

    24x7ss Well-Known Member

    Joined:
    Sep 30, 2014
    Messages:
    271
    Likes Received:
    16
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello Shoop,

    FYI both PDO and MySQL extension are different when it comes to PHP coding. PHP's MySQL extension provides simple methods that are synonymous to the C API that is available for MySQL. All in all, it's not an advanced system, and most importantly, it is no longer maintained where PDO aims to provide a consistent API that means when a database engine is changed, the code changes to reflect this should be minimal. When using PDO, your code will normally "just work" across many database engines, simply by changing the driver you're using.
     
  5. LostNerd

    LostNerd Well-Known Member

    Joined:
    Mar 12, 2014
    Messages:
    258
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Hastings, East Sussex, UK
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi Shoop,

    Just to add to the end of what 24x7ss has already said, it's great to note that EasyApache is usually really good at warning you if two extensions/plugins you have added are ikely to conflict and will usually prompt you to disable one or the other.

    You can't go too wrong with EasyApache unless you try... I think... I may be wrong... *breaks Apache* :)

    Peter
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page