Skip to main content

MySQLi by default

Tcalp
A bit disappointing that MySQLi extension hasn't been included by default yet, given that PHP 5.5 is now default.

Comments

11 comments

Date Votes
  • cPanelMichael
    Hello :) Could you provide some additional background information on this request? Are you requesting that MySQLi is enabled by default as a PHP extension instead of forcing users to enable it manually in the EasyApache build profile? Thank you.
    0
  • Tcalp
    Sorry Michael, this was a reply to a new EasyApache 3.2.1 announcement, it wasn't intended to be it's own thread, which defaults to PHP 5.5, but doesn't include MySQLi by default. ~~ Seems a bit odd to include depreciated code by default but not the current / supported code base. But yes, your assumption was correct.
    0
  • cPanelMichael
    Could you elaborate on how the lack of MySQLi support by default is impacting your servers? For instance, is the MySQL native driver not sufficient?
    0
  • Tcalp
    Hi Michael, In PHP 5.5 MySQL is depreciated (
    0
  • cPanelMichael
    The following PHP modules are enabled by default in EasyApache build profiles: Mysql (compile MySQL support using the PHP bundled libraries (if the System MySQL option is checked it takes precedence over this option)) Mysql of the system (compile mysql (and mysqli if its checked) support against the system libraries) PDO MySQL (This option will make the following changes to your profile prior to the build: Enables: PDO)
    Per additional
    0
  • Tcalp
    If you attempt to use PHP 5.5 + MySQL ext you would get an error like : Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/********/mysql.php on line 6
    0
  • cPanelMichael
    Could you open a support ticket using the link in my signature so we can take a closer look? I've not been able to reproduce the issue using the default EasyApache build profiles. You can post the ticket number here so we can update this thread with the outcome. Thank you.
    0
  • Tcalp
    Well it was never really that important of an issue, I was just making a comment on a specific Easy Apache build release, with EA4 upcoming this will be a null issue I'm sure anyhow.
    0
  • cPanelMichael
    Well it was never really that important of an issue, I was just making a comment on a specific Easy Apache build release, with EA4 upcoming this will be a null issue I'm sure anyhow.

    I believe you might be misunderstanding the mysqlnd MySQL Native Driver. You should not encounter any problems on EasyApache 3, so the error message you reported suggests there might be an issue on your system we need to address. Feel free to open a support ticket if you want us to take a closer look. Thank you.
    0
  • Tcalp
    Michael, we see the error on brand fresh installs along with existing servers, on 20+ servers, the issue is by no means a limited issue / single server issue. That said, it's not really something that concerns me.
    0
  • cPanelMichael
    Hello :) Thank you for taking the time to provide the additional information. I now understand the issue you are reporting, as this affects scripts that are outdated and were not designed for PHP 5.5 or newer. The following third-party URL explains the issue you are reporting: The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead It offers some guidance on how users can update their scripts to ensure compatibility with PHP 5.5 and newer. You are asking for a default selection and installation of mysqli with PHP, so that users who choose to update their scripts to use MySQLi will see it work right away instead of having to request the cPanel administrator to enable MySQLi in the EasyApache build profile. Is that correct? Thank you.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post