Which is the supported PHP MySQL driver for PHP7?
OS: CentOS 6.x
w refers to the webtatic release for php.
I'm seeing php70w-mysql and php70w-mysqlnd?
Thanks for your support.
Regards,
Noveck
I think you want php70w-mysqlnd
You could use either but not both.
the 'nd' means 'native driver' and is the newer. As I understand it, MySQL now providing drivers for talking to PHP where before libs had to be loaded.
Some report better performance using php70w-mysqlnd
'spirit of sharing', Ken
Thanks Ken and Howard.
This is the context. (Bug Tracker report: https://tracker.moodle.org/browse/MDL-62020)
I was using PHP56/MYSQL56 on Moodle 3.1
Upgraded to PHP70 to move towards Moodle 3.4
I had an external database auth that immediately broke.
3.1 was happy with the php56-mysql.
as soon as we moved to php70, the ext db authentication broke with a cryptic error, even though I followed the utt8mb4 instructions to the dot.
! ) Warning: mysqli_real_connect(): (HY000/2019): Can't initialize character set utf8mb4 (path: /usr/share/mysql/charsets/) in /var/www/html/lib/adodb/drivers/adodb-mysqli.inc.php on line 124
It was solved by removing php70-mysql and installing php70-mysqlnd
Thanks again for your feedback. I'll keep my eyes pegged for any downstream issues in this test environment, but I'm hoping for the best.
Hope this can help someone else if faced with a similar issue.