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.
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
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.